Linux下安装mysql5.7及相关配置记录

linux 安装mysql 5.7
1.下载mysql

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar

1. 解压

tar -xf  mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar

解压完成后由这么几个文件：

mysql-community-client-5.7.12-1.el6.x86_64.rpm
mysql-community-common-5.7.12-1.el6.x86_64.rpm
mysql-community-devel-5.7.12-1.el6.x86_64.rpm
mysql-community-embedded-5.7.12-1.el6.x86_64.rpm
mysql-community-embedded-devel-5.7.12-1.el6.x86_64.rpm
mysql-community-libs-5.7.12-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.12-1.el6.x86_64.rpm
mysql-community-server-5.7.12-1.el6.x86_64.rpm
mysql-community-test-5.7.12-1.el6.x86_64.rpm

依次执行安装：

rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm
......

启动mysql：

/etc/init.d/mysqld start

查看mysql目录：

ps aux|grep mysql

出现如下：

root      5688  0.0  0.0 113224  3080 pts/0    S    09:35   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     5886  0.0  2.3 1932112 181040 pts/0  Sl   09:35   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

进入mysql安装目录：

cd /var/lib/mysql

查看mysql默认密码：

grep "password" /var/log/mysqld.log

查找如下语句：A temporary password is generated for root@localhost: fQk2wWh&YRcT
最末尾就是默认初始密码

登录mysql：

/var/lib/mysql/mysql -u root -p

重设密码：

SET PASSWORD = PASSWORD('123456');

如果有强制密码检查插件，则过简单的密码会提示：Your password does not satisfy the current policy requirements
则需要设置一定强度的强密码，或者启用全局配置，修改密码插件验证规则：

set global validate_password_policy=0; //设置安全级别
set global validate_password_length=6; //默认密码长度为8，可以设置为其它值，最小4位

设置新密码:

SET PASSWORD = PASSWORD('123456');

赋所有权限：

grant all privileges on *.* to 'root' identified by '123456' with grant option;
flush privileges;

ok，可以访问了！