ubuntu14.04 安装mysql 失败经历（Access denied for user 'root'@'localhost' (using password: YES)）

超、凢脫俗 2022-04-15 04:27 80阅读 0赞

\# mysql -uroot -p

输入密码：

\-----》Access denied for user 'root'@'localhost' (using password: YES)

\# cat /etc/mysql/debian.cnf

\[client\]  
host     = localhost  
user     = debian-sys-maint  
password = hxhbsi8z7QApavYe  
socket   = /var/run/mysqld/mysqld.sock  
\[mysql\_upgrade\]  
host     = localhost  
user     = debian-sys-maint  
password = hxhbsi8z7QApavYe  
socket   = /var/run/mysqld/mysqld.sock  
basedir  = /usr

\# mysql -u debian-sys-maint -p

输入密码：hxhbsi8z7QApavYe

Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

\# mysql

只有一个数据库

\-----》information\_schema

\# SET PASSWORD FOR ['debian-sys-maint'@'localhost'][debian-sys-maint_localhost] = PASSWORD('hxhbsi8z7QApavYe');

\# mysql -u debian-sys-maint -p

输入密码：hxhbsi8z7QApavYe

按照网上说的做了   啊  还是不行

最后找到 my.cnf

\[mysqld\]  
\#  
\# \* Basic Settings  
\#  
user        = mysql  
pid-file    = /var/run/mysqld/mysqld.pid  
socket        = /var/run/mysqld/mysqld.sock  
skip-grant-tables  
port        = 3306  
basedir        = /usr  
datadir        = /var/lib/mysql  
tmpdir        = /tmp  
lc-messages-dir    = /usr/share/mysql  
skip-external-locking

发现三个数据库

\# use mysql;

\# update user set password=PASSWORD("rootadmin") where user='root';

注释掉

\[mysqld\]  
\#  
\# \* Basic Settings  
\#  
user        = mysql  
pid-file    = /var/run/mysqld/mysqld.pid  
socket        = /var/run/mysqld/mysqld.sock  
\#skip-grant-tables  
port        = 3306  
basedir        = /usr  
datadir        = /var/lib/mysql  
tmpdir        = /tmp  
lc-messages-dir    = /usr/share/mysql  
skip-external-locking

重启MySQL服务

[debian-sys-maint_localhost]: https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=%20debian-sys-maint%20@%20localhost