观摩
deepin
2019-04-22 02:28 获取初始密码安装后从安装日志中获取初始密码:
Copy the Code
修改 root 密码
密码需要符合复杂度要求,字母大小写+数字+特殊字符
Copy the Code
设置 root 可远程访问
Copy the Code
- grep "password" /var/log/mysqld.log
- 2018-04-02T08:06:58.551730Z 1 [Note] A temporary password is generated for root@localhost: 3pbe+go#xB:T
修改 root 密码
密码需要符合复杂度要求,字母大小写+数字+特殊字符
- mysql -uroot -p初始密码
- mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'gYb@123456';
设置 root 可远程访问
- mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'gYb@123456' WITH GRANT OPTION;
- # 刷新授权表
- mysql> FLUSH PRIVILEGES;
Reply Like 0 View the author


中文 

[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
网上的很多帮助都解决不了