MySQL 5.7.13-1.el6.x86_64 安装配置总结

最新推荐文章于 2021-03-18 05:27:47 发布

weixin_33937499

最新推荐文章于 2021-03-18 05:27:47 发布

阅读量112

点赞数

文章标签：数据库运维 python

原文链接：https://my.oschina.net/hycx227/blog/686799

版权

# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

[root@test]# yum install mysql

[root@test]# yum install mysql-server

[root@test]# yum install mysql-devel

[root@test /]# /etc/init.d/mysqld restart 重启一下数据库，会自动进行初始化。

[root@test /]# cat /var/log/mysqld.log | grep "temporary password" 查看密码

2016-06-03T11:22:35.841809Z 1 [Note] A temporary password is generated for root@localhost: 8!Q%r!3:6zs(

[root@test /]# mysql -uroot -p //输入密码

mysql> update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost'; //更新密码

===========================================================

安装完mysql 之后，登陆以后，不管运行任何命令，总是提示这个

You must reset your password using ALTER USER statement before executing this statement.

step 1: SET PASSWORD = PASSWORD('your new password');

step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

step 3: flush privileges;

============================================================

mysql> update mysql.user set host = '%' where user ='root'; //设置意IP可以访问

mysql> flush privileges;

必须使用alter user 重置密码：

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 '********'

配置文件目录： /etc/my.cnf

set GLOBAL max_connections=300

升级到最新的mysql

yum -y upgrade mysql

CentOS Linux更改MySQL5.7数据库目录位置

cp -a mysql /data/mysql/ 参数a表示权限一致

datadir=/data/mysql

socket=/data/mysql/mysql.sock

转载于:https://my.oschina.net/hycx227/blog/686799

关注