开机后没有mysqld.exe 看了一下,这次装了后服务里面没有mysql. 输入那个看端口的命令也没有任何东西出来.还有,运行的时候 Could not open required defaults file: C:\Program Files\MySQL\MySQL Server 5.1\my.ini Fatal error in defaults handling. Program aborted Enter password: my.ini没有的话好像不影响使用吧.
my.ini 是它的配置文件,当然需要。 你的 C:\Program Files\MySQL\MySQL Server 5.1\my.ini 这个文件存在不存在?
搜索一下你的磁盘,需要找到mysql的数据库文件需要找到一个叫 mysql的文件夹,里面有 user.frm 等文件。 可以在你的 C:\Documents and Settings\ 中
这个问题不知道就怎么好,我把以前装过的一个也是使用mysql的数据软件装一下就OK了。另外,麻烦帮我在看一个郁闷的问题,同样的句子,一个朋友能创建成功,我就不行。(mysql 5.1)mysql> use trydb; Database changed mysql> select * from pet; +------+------+ | id | name | +------+------+ | 1 | jeck | | 2 | an | +------+------+ 2 rows in set (0.00 sec)mysql> describe pet; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | name | varchar(10) | YES | | NULL | | +-------+-------------+------+-----+---------+-------+ 2 rows in set (0.01 sec)mysql> create view vvv -> as select * from pet; ERROR 1064 (HY000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'view vvv as select * from pet' at line 1 mysql>
先提供一下你的版本信息。 mysql> select version(); +----------------------+ | version() | +----------------------+ | 5.1.33-community-log | +----------------------+ 1 row in set (0.06 sec)mysql>
2.你卸载后,打开管理工具-》服务,里面还有mysql的服务吗?
3.你的端口是3306吗?有其它程序占用吗?最后5和6一起用,不是个好主意
mysqld.exe 2808 NT AUTHORITY\SYSTEMH:\>[/code][code=BatchFile]H:\>netstat -na | find "3306"
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1875 127.0.0.1:3306 CLOSE_WAIT
TCP 127.0.0.1:1908 127.0.0.1:3306 ESTABLISHED
TCP 127.0.0.1:3306 127.0.0.1:1908 ESTABLISHEDH:\>[/code]
看了一下,这次装了后服务里面没有mysql.
输入那个看端口的命令也没有任何东西出来.还有,运行的时候
Could not open required defaults file: C:\Program Files\MySQL\MySQL Server 5.1\my.ini
Fatal error in defaults handling. Program aborted
Enter password:
my.ini没有的话好像不影响使用吧.
你的 C:\Program Files\MySQL\MySQL Server 5.1\my.ini 这个文件存在不存在?
谢谢啊!是不是要拷一个my.ini过来?
搞晕呼了!
那你是怎么运行的呢?手工运行的mysqld.exe ?
就是mysql.exe我手动运行的.
2. 检查在你的PC上有没有mysqld.exe 或 mysqld*.exe 之类的进程在运行。(你可以通过任务管理器查看进程)
[code=BatchFile]H:\>pulist | find "mysqld"
mysqld.exe 2808 NT AUTHORITY\SYSTEMH:\>[/code]
3. 检查一下你的mysql的安装目录下都有些什么东西。 比如
[code=BatchFile]H:\>dir "C:\Program Files\MySQL\MySQL Server 5.1"
Volume in drive C is xxxxxx
Volume Serial Number is xxxxxx Directory of C:\Program Files\MySQL\MySQL Server 5.104/24/2009 02:36p <DIR> .
04/24/2009 02:36p <DIR> ..
06/05/2009 03:58p <DIR> bin
03/16/2009 01:29p 19,071 COPYING
06/12/2009 09:20a <DIR> DATA
04/11/2009 07:35p <DIR> Docs
03/16/2009 01:29p 5,139 EXCEPTIONS-CLIENT
03/16/2009 01:29p 5,036 my-huge.ini
03/16/2009 01:29p 21,272 my-innodb-heavy-4G.ini
03/16/2009 01:29p 5,010 my-large.ini
03/16/2009 01:29p 5,017 my-medium.ini
03/16/2009 01:29p 2,500 my-small.ini
11/12/2008 02:13a 13,129 my-template.ini
04/18/2009 12:08a 8,956 my.bak1
04/19/2009 06:15p 9,056 my.bak2
04/23/2009 09:26p 9,501 my.bak3
04/23/2009 09:26p 9,562 my.bak4
05/06/2009 11:38p 9,699 my.ini
04/11/2009 07:35p <DIR> share
13 File(s) 122,948 bytes
6 Dir(s) 31,792,887,808 bytes freeH:\>dir "C:\Program Files\MySQL\MySQL Server 5.1\bin"
Volume in drive C is xxxxxx
Volume Serial Number is xxxxxx Directory of C:\Program Files\MySQL\MySQL Server 5.1\bin06/05/2009 03:58p <DIR> .
06/05/2009 03:58p <DIR> ..
05/17/2009 06:11p 3,223 222.sql
06/05/2009 03:59p 0 aa.sql
03/16/2009 01:29p 2,359,296 libmySQL.dll
06/03/2009 05:06p 8 myisamchk
03/16/2009 01:29p 2,089,600 myisamchk.exe
03/16/2009 01:29p 1,979,008 myisamlog.exe
03/16/2009 01:29p 2,007,680 myisampack.exe
03/16/2009 01:29p 1,966,720 myisam_ftdump.exe
03/16/2009 01:29p 2,347,648 mysql.exe
03/16/2009 01:29p 5,623,808 mysql.pdb
03/16/2009 01:29p 2,282,112 mysqladmin.exe
03/16/2009 01:29p 5,419,008 mysqladmin.pdb
03/16/2009 01:29p 2,368,128 mysqlbinlog.exe
03/16/2009 01:29p 5,885,952 mysqlbinlog.pdb
03/16/2009 01:29p 2,278,016 mysqlcheck.exe
03/16/2009 01:28p 10,715,776 mysqld-debug.exe
03/16/2009 01:28p 2,624,552 mysqld-debug.map
03/16/2009 01:28p 20,434,944 mysqld-debug.pdb
03/16/2009 01:29p 6,562,432 mysqld.exe
03/16/2009 01:29p 3,330,554 mysqld.map
03/16/2009 01:29p 20,557,824 mysqld.pdb
03/16/2009 01:29p 2,331,264 mysqldump.exe
03/16/2009 01:29p 5,566,464 mysqldump.pdb
03/16/2009 01:29p 2,273,920 mysqlimport.exe
03/16/2009 01:29p 5,394,432 mysqlimport.pdb
02/06/2009 12:17a 2,971,776 MySQLInstanceConfig.exe
03/16/2009 01:29p 2,318,976 mysqlmanager.exe
03/16/2009 01:29p 704,517 mysqlmanager.map
03/16/2009 01:29p 5,885,952 mysqlmanager.pdb
03/16/2009 01:29p 2,273,920 mysqlshow.exe
03/16/2009 01:29p 5,386,240 mysqlshow.pdb
03/16/2009 01:29p 2,417,280 mysqltest.exe
03/16/2009 01:29p 2,609,152 mysql_client_test.exe
03/16/2009 01:29p 1,802,880 mysql_upgrade.exe
03/16/2009 01:29p 1,728,512 my_print_defaults.exe
03/16/2009 01:29p 1,716,224 perror.exe
03/16/2009 01:29p 1,720,320 replace.exe
03/16/2009 01:29p 1,703,936 resolveip.exe
38 File(s) 149,642,054 bytes
2 Dir(s) 31,792,887,808 bytes freeH:\>[/code]
2009-06-12 23:47 <DIR> ..
2009-05-23 01:12 19,071 COPYING
2009-05-23 01:12 5,139 EXCEPTIONS-CLIENT
2009-05-23 01:12 4,907 my-huge.ini
2009-05-23 01:12 4,881 my-large.ini
2009-05-23 01:12 4,890 my-medium.ini
2009-05-23 01:12 2,462 my-small.ini
2009-05-23 01:12 20,646 my-innodb-heavy-4G.ini
2008-11-12 03:13 13,129 my-template.ini
2009-06-12 23:47 <DIR> bin
2009-06-12 23:47 <DIR> Docs
2009-06-12 23:47 <DIR> Embedded
2009-06-12 23:47 <DIR> include
2009-06-12 23:47 <DIR> lib
2009-06-12 23:47 <DIR> scripts
2009-06-12 23:47 <DIR> share
2009-06-12 23:47 5,499 register.htm
2009-06-12 23:47 1,251 svctag.xml
2008-11-12 03:13 71,772 loginhdr.jpg
11 个文件 153,647 字节
9 个目录 1,148,559,360 可用字节C:\Program Files\MySQL\MySQL Server 5.1>cd binC:\Program Files\MySQL\MySQL Server 5.1\bin>dir
驱动器 C 中的卷没有标签。
卷的序列号是 7802-48A7 C:\Program Files\MySQL\MySQL Server 5.1\bin 的目录2009-06-12 23:47 <DIR> .
2009-06-12 23:47 <DIR> ..
2009-05-23 01:12 2,347,648 mysql.exe
2009-05-23 01:12 2,318,976 mysqlmanager.exe
2009-05-23 01:12 5,894,144 mysqlmanager.pdb
2009-05-23 01:12 704,682 mysqlmanager.map
2009-05-23 01:12 2,417,280 mysqltest.exe
2009-05-23 01:12 2,609,152 mysql_client_test.exe
2009-05-23 01:12 1,720,320 replace.exe
2009-05-23 01:12 5,623,808 mysql.pdb
2009-05-23 01:12 2,359,296 libmySQL.dll
2009-05-23 01:12 2,089,600 myisamchk.exe
2009-05-23 01:12 1,979,008 myisamlog.exe
2009-05-23 01:12 2,007,680 myisampack.exe
2009-05-23 01:12 1,966,720 myisam_ftdump.exe
2009-05-23 01:12 2,282,112 mysqladmin.exe
2009-05-23 01:12 5,419,008 mysqladmin.pdb
2009-05-23 01:12 2,368,128 mysqlbinlog.exe
2009-05-23 01:12 5,885,952 mysqlbinlog.pdb
2009-05-23 01:12 2,278,016 mysqlcheck.exe
2009-05-23 01:12 2,331,264 mysqldump.exe
2009-05-23 01:12 5,566,464 mysqldump.pdb
2009-05-23 01:12 2,273,920 mysqlimport.exe
2009-05-23 01:12 5,394,432 mysqlimport.pdb
2009-05-23 01:12 2,273,920 mysqlshow.exe
2009-05-23 01:12 5,386,240 mysqlshow.pdb
2009-05-23 01:12 1,802,880 mysql_upgrade.exe
2009-05-23 01:12 1,728,512 my_print_defaults.exe
2009-05-23 01:12 1,703,936 resolveip.exe
2009-05-23 01:12 1,716,224 perror.exe
2009-05-23 01:12 6,578,816 mysqld.exe
2009-05-23 01:12 20,582,400 mysqld.pdb
2009-05-23 01:12 3,334,104 mysqld.map
2009-05-23 01:11 10,736,256 mysqld-debug.exe
2009-05-23 01:10 20,459,520 mysqld-debug.pdb
2009-05-23 01:10 2,626,811 mysqld-debug.map
2009-02-06 01:17 2,971,776 MySQLInstanceConfig.exe
35 个文件 149,739,005 字节
2 个目录 1,148,559,360 可用字节C:\Program Files\MySQL\MySQL Server 5.1\bin>
可以在你的 C:\Documents and Settings\ 中
Database changed
mysql> select * from pet;
+------+------+
| id | name |
+------+------+
| 1 | jeck |
| 2 | an |
+------+------+
2 rows in set (0.00 sec)mysql> describe pet;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(10) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)mysql> create view vvv
-> as select * from pet;
ERROR 1064 (HY000): You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near 'view
vvv
as select * from pet' at line 1
mysql>
mysql> select version();
+----------------------+
| version() |
+----------------------+
| 5.1.33-community-log |
+----------------------+
1 row in set (0.06 sec)mysql>
+-----------+
| version() |
+-----------+
| 4.0.16-nt |
+-----------+
1 row in set (0.00 sec)晕,怎么是4.0 我在官网上,下的是5.1的啊。
mysql-5.1.35-win32.msi 这个就是从官网上下的。好像我装了6.1(mysql-6.0.11-alpha-win32.msi也官网下的)的也显示是这个。
是不是我装了那个软件引起的(协创饰品销售管理系统)。
果然是我有些东西没有删干净.非常感谢ACMAIN_CHM和neohope两位大侠的鼎力相助