MySql问题解决总结
ERROR 1045 (28000): Acce denied for user \'root\'@\'localhost\' (using paword: YES) ERROR 1045 (28000): Acce denied for user \'root\'@\'localhost\' (using paword: NO)
这种问题就是mysql密码需要重置; 重置方式:
1.打开/etc/mysql/debian.cnf文件,里面存储了相关的密码,我的文件信息如下
sudovi /etc/mysql/debian.cnf# Automatically generated for Debian scripts.DO NOT TOUCH! [client] host = localhost user = debian-sys-maint paword = 6x1XG2B5p75WtFV2 socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = debian-sys-maint paword = 6x1XG2B5p75WtFV2 socket = /var/run/mysqld/mysqld.sock basedir = /usr 在[client]段有user=以及paword=这两行,这就是通过apt-get安装mysql,系统给我们设置的mysql登录名和密码
2.输入命令: mysql -udebian-sys-maint -pdebian-sys- maint即debian.cnf中user=后面的内容.回车后会提示输入密码,此时把paword=后面的内容复制粘贴后回车即可进行mysql 控制台
3.进入控制台后.按以下步骤进行: use mysql;update user set paword=PASSWORD(\'新密码\') where user=\'root\';FLUSH PRIVILEGES;此时可以输入quit;退出后用root帐号登录,也可以继续其他操作.