CentOS7安装mysql5.7.16

1. 解压mysql安装包

去mysql官网下载mysql-5.7.16-linux-glibc2.5-x86_64.tar 上传到/home/mysql

msyql>   cp  /home/mysql/mysql-5.7.16-linux-glibc2.5-x86_64.tar  /usr/java   复制到 /usr/java文件夹下

[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# cd /usr/java

[root@iZwz91nfqrmmcjz3ax4vqvZ java]# tar xvf mysql-5.7.16-linux-glibc2.5-x86_64.tar  解压
mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
mysql-test-5.7.16-linux-glibc2.5-x86_64.tar.gz
[root@iZwz91nfqrmmcjz3ax4vqvZ java]# ls
mysql-5.7.16-linux-glibc2.5-x86_64.tar     mysql-test-5.7.16-linux-glibc2.5-x86_64.tar.gz
mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
[root@iZwz91nfqrmmcjz3ax4vqvZ java]#  tar -zxvf  mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz  解压

[root@iZwz91nfqrmmcjz3ax4vqvZ java]# mv mysql-5.7.16-linux-glibc2.5-x86_64 mysql 重命名

2.检查mysql组和用户是否存在，如无创建。

创建mysql组，账户，设置mysql不能登录（防止别人利用mysql账号登录主机）

groupadd mysql
useradd -g mysql mysql

usermod -s /bin/false mysql

3.安装和初始化数据库

[root@iZwz91nfqrmmcjz3ax4vqvZ java]#   cd mysql

[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# mkdir data
[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# cd bin
[root@iZwz91nfqrmmcjz3ax4vqvZ bin]# ./mysql_install_db --user=mysql --basedir=/usr/java/mysql --datadir=/usr/java/mysql/data

2016-12-30 17:18:22 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-12-30 17:18:33 [WARNING] The bootstrap log isn't empty:
2016-12-30 17:18:33 [WARNING] 2016-12-30T09:18:24.809318Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead

[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# cp -a ./support-files/my-default.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? yes
[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# cp -a ./support-files/mysql.server /etc/init.d/mysqld
[root@iZwz91nfqrmmcjz3ax4vqvZ mysql]# cd bin/
[root@iZwz91nfqrmmcjz3ax4vqvZ bin]# ./mysqld_safe --user=mysql --basedir=/usr/java/mysql --datadir=/usr/java/mysql/data &

到/etc目录下配置my.cnf

shell> cd /etc/

shell> vi my.cnf #修改或添加以下内容 

basedir=/usr/local/mysql 

datadir=/usr/local/mysql/data

port = 3306 

socket=/tmp/mysql.sock 

shell> vi /etc/profile  #配置环境变量 添加如下内容 

export MYSQL_HOME="/usr/java/mysql" 

export PATH="$PATH:$MYSQL_HOME/bin"

shell> source  /etc/profile  #使配置及时生效

[root@iZwz91nfqrmmcjz3ax4vqvZ ~]# cd /usr/local

[root@iZwz91nfqrmmcjz3ax4vqvZ local]# ln -s /usr/java/mysql mysql

[root@iZwz91nfqrmmcjz3ax4vqvZ ~]# chkconfig mysqld on 设置开机启动
[root@iZwz91nfqrmmcjz3ax4vqvZ ~]# chmod 755 /etc/init.d/mysqld   修改mysqld执行权限
[root@iZwz91nfqrmmcjz3ax4vqvZ ~]# service mysqld start  启动mysql
Starting MySQL.[  OK  ]

a) 开启防火墙mysql 3306端口的外部访问 CentOS升级到7之后，使用firewalld代替了原来的iptables。下面记录如何使用firewalld开放Linux端口 

shell>  firewall-cmd --zone=public --add-port=3306/tcp --permanent

shell>  firewall-cmd --reload  #重启防火墙

4.初始化密码

mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要登录。

[root@iZwz91nfqrmmcjz3ax4vqvZ bin]# cat /root/.mysql_secret
# Password set for user 'root@localhost' at 2016-12-30 17:18:22 
xh<Mwwa+ZIXi
[root@iZwz91nfqrmmcjz3ax4vqvZ bin]#  ./mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.16


Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>SET PASSWORD = PASSWORD('123456');

Query OK,0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;

Query OK,0 rows affected (0.00 sec)

5.添加远程访问权限

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> select host,user from user;
+-----------+-----------+
| host      | user      |
+-----------+-----------+
| %         | root      |
| localhost | mysql.sys |
+-----------+-----------+
2 rows in set (0.00 sec)

mysql> quit;   退出mysql;

//重启生效

[root@iZwz91nfqrmmcjz3ax4vqvZ bin]# service mysqld restart

可能碰到异常

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 异常

先把mysql关闭

用mysqld_safe --user=mysql --skip-grant-tables --skip-networking启动mysql 然后进去给root把密码加上

mysql -u root mysql 进入

mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='username';（5.7之前用此方法）

mysql> UPDATE user SET authentication_string=PASSWORD("new password") WHERE user='username';（5.7之后用此方法）

mysql> FLUSH PRIVILEGES;    //刷新系统权限表

mysql> quit;

杀死mysql，重启mysql

登录mysql