mysql 安装后没有用户名和密码
Tofloor
poster avatar
svod5306
deepin
2019-04-20 00:54
Author
debian.cnf文件如下:

[client]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = root
password =
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr


网上的很多帮助都解决不了
Reply Favorite View the author
All Replies
avatar
观摩
deepin
2019-04-22 02:28
#1
获取初始密码安装后从安装日志中获取初始密码:
  1. grep "password" /var/log/mysqld.log

  2. 2018-04-02T08:06:58.551730Z 1 [Note] A temporary password is generated for root@localhost: 3pbe+go#xB:T
Copy the Code

修改 root 密码
密码需要符合复杂度要求,字母大小写+数字+特殊字符
  1. mysql -uroot -p初始密码

  2. mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'gYb@123456';
Copy the Code

设置 root 可远程访问
  1. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'gYb@123456' WITH GRANT OPTION;

  2. # 刷新授权表
  3. mysql> FLUSH PRIVILEGES;
Copy the Code



Reply View the author