mysql
1、登录mysql数据库 用户名和密码如下:
#vi /etc/mysql/debian.cnf
[client]
host = localhost
user = debian-sys-maint
password = DrUleFaMZmNyZANw
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = DrUleFaMZmNyZANw
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
2、root用户登录,密码正确,但提示:ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
(1)用debian.cnf中的用户名/密码登录;
(2)修改root用户的密码
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
注意事项:
(1)密码在数据库中是密码保存的。所以不能在数据库中直接设置密码,要通过mysql命令来设置密码。
例如:password(‘password’)。