以前用的是安装版的MYSQL,现在换免安装的出现了问题。
(1)把MYSQL压缩包直接解压到随便一个磁盘上。(我解压到了C盘)
(2)设置PATH。(比如我的:path=C:\mysql-5.0.27-win32\bin)
打开cmd窗口,连接失败:
C:\Documents and Settings\lingirl>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
怎么办?
好办。
解决方法:在bin目录下找到mysqld-nt.exe,双击运行它。
接着再重新打开一个cmd:
C:\Documents and Settings\lingirl>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
好了,连接成功。
(1)把MYSQL压缩包直接解压到随便一个磁盘上。(我解压到了C盘)
(2)设置PATH。(比如我的:path=C:\mysql-5.0.27-win32\bin)
打开cmd窗口,连接失败:
C:\Documents and Settings\lingirl>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
怎么办?
好办。
解决方法:在bin目录下找到mysqld-nt.exe,双击运行它。
接着再重新打开一个cmd:
C:\Documents and Settings\lingirl>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
好了,连接成功。