本文共 2690 字，大约阅读时间需要 8 分钟。

前言

Mysql5.6和Mysql5.7是2个分界线，安装是大不相同的。

下载

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

将下载好的安装包放到 /usr/local/mysql 下

解压

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

移动

mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/

重命名

mv /usr/local/mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql

配置安装

准备

1.新建data目录

mkdir /usr/local/mysql/data

2.新建mysql用户、mysql用户组

mysql用户组

groupadd mysql

mysql用户

useradd mysql -g mysql

3.将/usr/local/mysql的所有者及所属组改为mysql

chown -R mysql.mysql /usr/local/mysql

配置

/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 --initialize2018-07-14 06:40:32 [ERROR]   Child process: /usr/local/mysql/bin/mysqldterminated prematurely with errno= 322018-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

[mysqld]datadir=/usr/local/mysql/databasedir=/usr/local/mysqlsocket=/tmp/mysql.sockuser=mysqlport=3306character-set-server=utf8# 取消密码验证skip-grant-tables# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# skip-grant-tables[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

后期配置

1.开启服务

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

2.开机自启

chkconfig mysql on

3.开启mysql

service mysql start

4.设置密码

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

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

操作mysql数据库

use mysql;

修改密码

注意：mysql5.7+更改密码password变成了authentication_string

update user set authentication_string=password(“new_pass”) where user=“root”;

flush privileges;

exit;

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

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

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

ALTER USER “root”@“localhost” IDENTIFIED BY “123456”;

exit;

7.允许远程连接

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

use mysql;

update user set host="%" where user = “root”;

flush privileges;

eixt;

8.添加快捷方式

ln -s /usr/local/mysql/bin/mysql /usr/bin

OK

就可以通过工具（Navicat）进行连接远程的Mysql了

转载地址：http://serub.baihongyu.com/