linux系安装Mysql8.0

参考:https://www.jb51.net/article/160736.htm

下载安装包

//切换到local 目录下
cd /user/local 
//下载安装包
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 
//解压安装包
tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 
//重命名
mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql8.0
//进入mysql 目录新建数据存放目录 data
cd mysql8.0
mkdir data
//创建mysql 用户和组
groupadd mysql 
useradd -s /sbin/nologin -g mysql mysql -d /usr/local/mysql8.0/
//更改目录所有者
chown -R mysql:mysql ./
chmod -R 755 /usr/local/mysql8.0/
           

//初始化MySQL 如果初始化失败重新初始化 必须清空data目录
./bin/mysqld --user mysql --basedir /usr/local/mysql8.0 --datadir /usr/local/mysql8.0/data --initialize
           

注意记录初始密码

//添加系统服务
cp -a /usr/local/mysql8.0/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
//查看是否添加
chkconfig--list
           

配置环境变量

vim /etc/profile
//使配置生效
source /etc/profile
           

//新建mysql配置文件
vim /etc/my.cnf
           

配置内容

[client]
port=3306
[mysqld]
port=3306
user=mysql
basedir=/usr/local/mysql8.0
datadir=/usr/local/mysql8.0/data
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
           

//启动mysql
service mysqld start
           

//修改mysql 密码
mysql -uroot -p
//输入初始化密码
use mysql;
//修改密码
ALTER user 'root'@'localhost' IDENTIFIED BY 'yourpassword';
//退出 查看密码是否生效
exit 
           

设置远程登录

use mysql
update user set host='%' where user='root' limit 1;