如何查看liunx下安装mysql后的默认密码

输入 mysql -uroot -p后输入密码
但是我没有设置过密码啊
所以密码是多少?

cat /var/log/mysqld.log |grep password

https://blog.csdn.net/ory001/article/details/108385542

img


查看自带数据库
rpm -qa | egrep "mariadb|mysql"

卸载数据库
rpm -e --nodeps name(name换成mysql数据库名字)

1> 下载MySQL
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

2> 安装MySQL
rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum install mysql-community-server -y

service mysqld status 查看服务
service mysqld start 开启服务
service mysqld stop 停止服务
service mysqld restart 重启服务

【配置密码】
1> 进入MySQL数据库
mysql -u root
2>
use mysql
3>删除user
delete from user;
4>配置密码语句
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

create user 'root'@'%' identified by 'Admin123';
GRANT ALL PRIVILEGES ON . TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Admin123';

grant all privileges on . to 'root'@'%';
5>退出
quit
6>重启MySQL服务
service mysqld restart

进入MySQL
mysql -u root -p
密码
Admin123

退出
quit

mysql初始化后的密码记录在mysql的错误日志中,看下my.cnf中定义的错误日志路径,从错误日志中提示密码