输入 mysql -uroot -p后输入密码
但是我没有设置过密码啊
所以密码是多少?
cat /var/log/mysqld.log |grep password
https://blog.csdn.net/ory001/article/details/108385542
卸载数据库
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中定义的错误日志路径,从错误日志中提示密码