ubuntu用apt安装mysql-server后找到默认账号密码

ubuntu版本是22.04.3 安装的 mysql-server 是 mysql 8.0

默认账号密码：

sudo cat /etc/mysql/debian.cnf

[client]
host     = localhost
user     = debian-sys-maint
password = xezrqqkk9Dely8hv
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = xezrqqkk9Dely8hv
socket   = /var/run/mysqld/mysqld.sock

连接数据库，并修改密码(账户密码替换成你自己的)：

mysql -u debian-sys-maint -p xezrqqkk9Dely8hv
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';FLUSH PRIVILEGES;

报错问题：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

修改mysql配置文件，原本是空的只有[mysql]一行，增加如下配置，重启mysql服务

sudo vim /etc/mysql/conf.d/mysql.cnf

[mysql]

[client]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
socket=/var/run/mysqld/mysqld.sock

版权属于：Joyber

本文链接：https://blog.qqvbc.com/default/1097.html

转载时须注明出处及本声明