linux上安装mysql5.7

1、下载tar包，这里使用wget从官网下载

wget https://dev.Mysql.com/get/Downloads/MysqL-5.7/MysqL-5.7.22-linux-glibc2.12-x86_64.tar.gz

2、将MysqL安装到/usr/local/MysqL下

# 解压

tar -xvf MysqL-5.7.22-linux-glibc2.12-x86_64.tar.gz

# 移动

# 重命名

3、新建data目录

4、新建MysqL用户、MysqL用户组

# MysqL用户组

groupadd MysqL

# MysqL用户

useradd MysqL -g MysqL

5、将/usr/local/MysqL的所有者及所属组改为MysqL

chown -R Mysql.MysqL /usr/local/MysqL

6、配置

/usr/local/MysqL/bin/MysqL_install_db --user=MysqL --basedir=/usr/local/MysqL/ --datadir=/usr/local/MysqL/data

# 如果出现以下错误：

2018-07-14 06:40:32 [WARNING] MysqL_install_db is deprecated. Please consider switching to MysqLd --initialize
2018-07-14 06:40:32 [ERROR] Child process: /usr/local/MysqL/bin/MysqLdterminated prematurely with errno= 32
2018-07-14 06:40:32 [ERROR] Failed to execute /usr/local/MysqL/bin/MysqLd --bootstrap --datadir=/usr/local/MysqL/data --lc-messages-dir=/usr/local/MysqL/share --lc-messages=en_US --basedir=/usr/local/MysqL
-- server log begin --

-- server log end --

# 则使用以下命令：

/usr/local/MysqL/bin/MysqLd --user=MysqL --basedir=/usr/local/MysqL/ --datadir=/usr/local/MysqL/data --initialize

# 如果出现以下错误：

/usr/local/MysqL/bin/MysqLd: error while loading shared libraries: libnuma.so.1: cAnnot open shared object file: No such file or directory

# 则执行以下命令：

yum -y install numactl

# 完成后继续安装：

/usr/local/MysqL/bin/MysqLd --user=MysqL --basedir=/usr/local/MysqL/ --datadir=/usr/local/MysqL/data --initialize

# 编辑/etc/my.cnf

7、开启服务

# 将MysqL加入服务

cp /usr/local/MysqL/support-files/Mysql.server /etc/init.d/MysqL

# 开机自启

chkconfig MysqL on

# 开启

service MysqL start

8、设置密码

# 登录（由于/etc/my.cnf中设置了取消密码验证，所以此处密码任意）

/usr/local/MysqL/bin/MysqL -u root -p

# 操作MysqL数据库

>>use MysqL;

# 修改密码

>>update user set authentication_String=password(‘你的密码‘) where user=‘root‘;

>>flush privileges;

>>exit;

9、将/etc/my.cnf中的skip-grant-tables删除

10、登录再次设置密码（不知道为啥如果不再次设置密码就操作不了数据库了）

/usr/local/MysqL/bin/MysqL -u root -p

 >>ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘修改后的密码‘;

>>exit;

11、允许远程连接

/usr/local/MysqL/bin/MysqL -u root -p

>>use MysqL;

>>update user set host=‘%‘ where user = ‘root‘;

>>flush privileges;

>>eixt;

12、添加快捷方式

ln -s /usr/local/MysqL/bin/MysqL /usr/bin