情况是这样的,我先装了mysql5.0的,然后装了6.0.两者一起的时候好像没有出什么问题,都可以用.可是我后来把两个都删除了在装以后,就进不去了,直接就2003,然后就退出来了.无论我怎么删 重装都不行.
网上说的那个用viewservice好像也不管用,跟本就没有sql sqlmanager帮我看一下吧.
网上说的那个用viewservice好像也不管用,跟本就没有sql sqlmanager帮我看一下吧.
解决方案 »
- c+mysql的应用领域有那些?
- mysql语句报错了,求解决
- 如何把记录中含有&..&中的文本提取并用逗号分隔返回呢?
- group by 排序问题
- Show master Status在master和Slava机器上结果不一样
- 在我的phpadmin中总有这句"使用链接表的额外特性尚未激活。要查出原因,请单击此处。"是什么意思呢?
- 求助: 创建数据库报表出错!
- c#操作mysql数据库有现成的方法 或者例子吗?
- mySql插入emoji表情的问题,编码全部正确还是报错,请教原因!!
- 触发器问题
- ERROR 1172 (42000): Result consisted of more than one row?
- 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两位大侠的鼎力相助