linux下mysql的部署,Linux下部署MySQL5.7

MySQL安装

1.下载安装包

[root@wmxj local]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

2.解压

[root@wmxj local]# tar xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

3.重命名

[root@wmxj local]# mv mysql-5.7.24-linux-glibc2.12-x86_64 mysql

4.检查mysql用户组及用户，不存在则创建

[root@wmxj local]# cat /etc/group | grep mysql

[root@wmxj local]# cat /etc/passwd |grep mysql

[root@wmxj local]# groupadd mysql

[root@wmxj local]# useradd -r -g mysql mysql

5.给mysql用户赋权限

[root@wmxj local]# chown -R mysql:mysql /usr/local/mysql

[root@wmxj local]# chmod -R 755 /usr/local/mysql

6.编译安装并初始化mysql

[root@wmxj local]# cd /usr/local/mysql/bin

[root@wmxj bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

这一步可能出现错误，检查一下链接库文件有没有安装

[root@wmxj bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

[root@wmxj bin]# rpm -qa|grep libaio

[root@wmxj bin]# yum install libaio

初始化命令成功后，记住最后一句mysql管理员临时密码

2021-04-16T08:30:24.776712Z 1 [Note] A temporary password is generated for root@localhost: N4&H-_5.fZgG

7.编辑my.cnf

[root@wmxj mysql]# vim /etc/my.cnf

[mysqld]

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/usr/local/mysql/mysql.sock

symbolic-links=0

port=3306

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

max_connections=600

innodb_file_per_table=1

#lower_case_table_names=1

character_set_server=utf8

8.启动MySQL服务器

[root@wmxj mysql]# /usr/local/mysql/support-files/mysql.server start

Starting MySQL.

9.添加软链接，并重启mysql服务

[root@wmxj mysql]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

[root@wmxj mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

[root@wmxj mysql]# service mysql restart

10.登录mysql，修改密码(密码为步骤5生成的临时密码)

[root@wmxj mysql]# mysql -u root -p

Enter password:

mysql>set password for root@localhost = password('yourpass');

若登录不了可以先修改my.cnf，在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程，修改root密码后在改回密码登录

[root@wmxj mysql]# vim /etc/my.cnf

[mysqld]

skip-grant-tables

[root@wmxj mysql]# mysql

mysql> use mysql;

mysql> update user set authentication_string=password('123456') where user='root' ;

mysql> flush privileges;

mysql> quit

注释“skip-grant-tables”重启mysql

[root@wmxj mysql]# service mysql restart

11.开放远程连接

mysql>use mysql;

msyql>update user set user.Host='%' where user.User='root';

mysql>flush privileges;

12.设置开机自动启动

# 1、将服务文件拷贝到init.d下，并重命名为mysql

[root@wmxj /]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

# 2、赋予可执行权限

[root@wmxj /]# chmod +x /etc/init.d/mysqld

# 3、添加服务

[root@wmxj /]# chkconfig --add mysqld

# 4、显示服务列表

[root@wmxj /]# chkconfig --list