MySQL安装以及登陆密码修改

最新推荐文章于 2024-10-18 00:15:00 发布

Still_Believe_

最新推荐文章于 2024-10-18 00:15:00 发布

阅读量875

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL学习文章标签： mysql 数据库

本文链接：https://blog.csdn.net/baidu_15952103/article/details/106597159

MySQL学习专栏收录该内容

17 篇文章

订阅专栏

1.MySQL安装

wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm

rpm -Uvh mysql57-community-release-el7-10.noarch.rpm

yum install -y mysql-community-server

systemctl start mysqld.service

环境安装

yum install cmake

yum -y install gcc+ gcc-c++

yum install mysql-devel 解决mysql.h库

2.修改数据库登陆密码

解决密码问题：
1.vi /etc/my.cnf
在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程，保存文档退出。

2.重启MySQL,systemctl restart mysqld.service

3.mysql 进入数据库，用以下命令修改root密码

update user set authentication_string=password("your password") where user="root";

4. 重新编辑vi /etc/my.cnf ,去掉skip-grant-tables”，再次重启MySQL,systemctl restart mysqld.service

上述的1-4步完成了密码的修改。

5.mysql -u root -p 进入数据库

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER "root"@"localhost" IDENTIFIED BY "your password";
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

6.解决以上两个ERROR，使用

set global validate_password_policy=LOW;

ALTER USER "root"@"localhost" IDENTIFIED BY "your password";

成功执行后，退出数据库，重启mysql.

7. mysql -u root -p j进入后，能正常执行命令：

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)