我安装了一个MySQL5.1,输入密码启动后,在“mysql>”提示中输入C:\setup.sql进行导入,好像没有成功,先用use confdb再用show databases显示不出来,不知什么原因?setup.sql文件代码如下:
# MySQL dump 8.13
#
# Host: localhost Database: confdb
#--------------------------------------------------------
# Server version 3.23.36USE mysql;DELETE FROM user WHERE user='admin' and Password = '43e9a4ab75570f5b';INSERT INTO user VALUES ('%','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('localhost','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');FLUSH PRIVILEGES;CREATE DATABASE /*!32312 IF NOT EXISTS*/ confdb;USE confdb;#
# Table structure for table 't_contact'
#CREATE TABLE t_contact (
name char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
email char(100) NOT NULL default '',
mobile char(15) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
phone char(30) NOT NULL default '',
PRIMARY KEY (name,user_name)
) TYPE=MyISAM;#
# Table structure for table 't_reservation'
#CREATE TABLE t_reservation (
conf_id char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
s_ipaddr char(30) NOT NULL default '',
chairman_pass char(40) NOT NULL default '',
active_pass char(40) NOT NULL default '',
passive_pass char(40) NOT NULL default '',
conf_subject char(100) NOT NULL default '',
year char(4) NOT NULL default '',
begin_month char(2) NOT NULL default '',
begin_day char(2) NOT NULL default '',
end_month char(2) NOT NULL default '',
end_day char(2) NOT NULL default '',
begin_hr char(2) NOT NULL default '',
begin_mi char(2) NOT NULL default '',
end_hr char(2) NOT NULL default '',
end_mi char(2) NOT NULL default '',
attendnum int(5) NOT NULL default '0',
bandwidth int(4) NOT NULL default '0',
maxvideo int(1) NOT NULL default '0',
conf_type int(1) NOT NULL default '0',
video_type int(1) NOT NULL default '0',
mix_type int(1) NOT NULL default '0',
PRIMARY KEY (conf_id)
) TYPE=MyISAM;#
# Table structure for table 't_server'
#CREATE TABLE t_server (
name char(30) NOT NULL default '',
ipaddr char(30) NOT NULL default '',
out_ipaddr char(30) NULL default '',
PRIMARY KEY (ipaddr)
) TYPE=MyISAM;#
# Table structure for table 't_user'
#CREATE TABLE t_user (
name char(30) NOT NULL default '',
pass char(40) NOT NULL default '',
level int(1) NOT NULL default '0',
email char(100) NOT NULL default '',
realname char(40) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
location char(100) NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM;#
# Dumping data for table 't_user'
#INSERT INTO t_user VALUES ('admin','21232f297a57a5a743894a0e4a801fc3',0,'','','','','');
# MySQL dump 8.13
#
# Host: localhost Database: confdb
#--------------------------------------------------------
# Server version 3.23.36USE mysql;DELETE FROM user WHERE user='admin' and Password = '43e9a4ab75570f5b';INSERT INTO user VALUES ('%','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('localhost','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');FLUSH PRIVILEGES;CREATE DATABASE /*!32312 IF NOT EXISTS*/ confdb;USE confdb;#
# Table structure for table 't_contact'
#CREATE TABLE t_contact (
name char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
email char(100) NOT NULL default '',
mobile char(15) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
phone char(30) NOT NULL default '',
PRIMARY KEY (name,user_name)
) TYPE=MyISAM;#
# Table structure for table 't_reservation'
#CREATE TABLE t_reservation (
conf_id char(30) NOT NULL default '',
user_name char(30) NOT NULL default '',
s_ipaddr char(30) NOT NULL default '',
chairman_pass char(40) NOT NULL default '',
active_pass char(40) NOT NULL default '',
passive_pass char(40) NOT NULL default '',
conf_subject char(100) NOT NULL default '',
year char(4) NOT NULL default '',
begin_month char(2) NOT NULL default '',
begin_day char(2) NOT NULL default '',
end_month char(2) NOT NULL default '',
end_day char(2) NOT NULL default '',
begin_hr char(2) NOT NULL default '',
begin_mi char(2) NOT NULL default '',
end_hr char(2) NOT NULL default '',
end_mi char(2) NOT NULL default '',
attendnum int(5) NOT NULL default '0',
bandwidth int(4) NOT NULL default '0',
maxvideo int(1) NOT NULL default '0',
conf_type int(1) NOT NULL default '0',
video_type int(1) NOT NULL default '0',
mix_type int(1) NOT NULL default '0',
PRIMARY KEY (conf_id)
) TYPE=MyISAM;#
# Table structure for table 't_server'
#CREATE TABLE t_server (
name char(30) NOT NULL default '',
ipaddr char(30) NOT NULL default '',
out_ipaddr char(30) NULL default '',
PRIMARY KEY (ipaddr)
) TYPE=MyISAM;#
# Table structure for table 't_user'
#CREATE TABLE t_user (
name char(30) NOT NULL default '',
pass char(40) NOT NULL default '',
level int(1) NOT NULL default '0',
email char(100) NOT NULL default '',
realname char(40) NOT NULL default '',
position char(40) NOT NULL default '',
corp_name char(40) NOT NULL default '',
location char(100) NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM;#
# Dumping data for table 't_user'
#INSERT INTO t_user VALUES ('admin','21232f297a57a5a743894a0e4a801fc3',0,'','','','','');
这样试下.source 好像他的的另外一种形式是 ./
我导入的setup.sql是用户是admin密码是admin。
BOOL CDBMySQL::db_init(char* db_IP, int db_port, bool)
{
MYSQL *tmpSql = NULL;
tmpSql = mysql_init(NULL);
if ( FALSE == mysql_real_connect(tmpSql, db_IP, "admin", "admin", "confdb",0,NULL,0))
{
mysql_close(tmpSql);
tmpSql = NULL;
SetEvent( g_hDBConnectOut );
return FALSE;
}
直接用source C:/setup.sql导入后?还要怎么修改用户和密码才能连接成功?