mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost]#
[root@localhost]# service mysqld start
初始化 MySQL 数据库: Installing MySQL system tables...
1.例如你的 root用户现在没有密码,你希望的密码修改为abc,那么命令是:
mysqladmin -u root password abc
2.如果你的root现在有密码了,那么修改密码为abc的命令是:
mysqladmin -u root -p password youyou
注意,命令回车后会问你旧密码,输入旧密码之后命令完成,密码修改成功。
3.运行mysqladmin命令不是双击这个文件,那样运行无法给参数,可以在开始运行里面输入命令,或者在开始、所有程序、附件、命令提示符里面输入命令,注意应该输入mysqladmin的全路径名,例如:
d:/mysql/bin/mysqladmin.exe -u root -p password youyou