linux 安装mysql 8

linux 下安装 myslq 8

一、下载

可以自己去官网下载 MySQL :: Download MySQL Community Server (Archived Versions)

链接：https://pan.baidu.com/s/1QzQTS-gKOYoOdQ14oGFpww 
提取码：4by6 

二、安装

把下载的安装包上传到Linux系统。

解压文件
将压缩包解压到/usr/local/目录下，并改名mysql
cd /usr/local/
 
tar -xvf /home/chenyb/software/mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz
 
mv mysql-8.0.15-linux-glibc2.12-x86_64/ ./mysql 
配置my.cnf文件，默认mysql会执行/etc/my.cnf这个配置文件
vi /etc/my.cnf
创建数据存放目录
mkdir /usr/local/mysql/data -p
[client]
port=3306
socket=/tmp/mysql/mysql.sock
 
[mysqld]
port=3306
user=mysql
socket=/tmp/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=error.log
 
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
 
#开启可以跳过认证，免密登录
skip-grant-tables
创建用户并授权
mkdir /tmp/mysql -p 
 
useradd mysql
 
chown -R mysql:mysql /tmp/mysql
 
chown -R mysql:mysql /usr/local/mysql
 
chmod -R 755 /tmp/mysql /usr/local/mysql
初始化
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
启用mysql命令 
ln -s /usr/local/mysql/bin/mysql /usr/bin
清空密码
启动mysql
/usr/local/mysql/support-files/mysql.server start
登录mysql，密码直接回车就好
mysql  -uroot -p 
清空密码
use mysql;
 
update user set authentication_string='' where user='root';
设置密码
注释掉/etc/my.cnf中的#skip-grant-tables，不跳过认证
重启mysql服务
/usr/local/mysql/support-files/mysql.server stop
 
/usr/local/mysql/support-files/mysql.server start
登录mysql，密码已经被清理，直接回车就好
样例中密码是root
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';
开机自启
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
 
chmod 755 /etc/init.d/mysql 
 
cd /etc/init.d
 
chkconfig --add mysql
 
chkconfig --level 345 mysql on
允许远程连接
在mysql配置文件中加入配置（/etc/my.cnf），设置密码加密方式
default_authentication_plugin=mysql_native_password 
进入mysql设置root用户远程访问权限和密码加密方式
use mysql;
 
update user set host ='%' where user='root';
 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
 
FLUSH PRIVILEGES;