Thursday, April 17, 2008

Can't connect to MySQL (10061)

Add this line to my.cnf file
bind-address = 127.0.0.1

restart mysql service

nowconnect mysql from command prompt
mysql -u root -p
Password
mysql>use mysql;
mysql>UPDATE user SET password=password("newpassword") WHERE user="root";
mysql>FLUSH PRIVILEGES;

No comments: