mysql8.0.13安装

1. 检查是否有安装mysql，有就删除

rpm安装查看：rpm -qa | grep mysql
dpkg安装查看：dpkg-l|grep mysql
yum安装查看：yum list installed | grep mysql
源码安装查看：查看是否有mysql文件

2. 下载最新版mysql

https://dev.mysql.com/downloads/mysql/
选择Linux Generic通用版和Compressed TAR Archive压缩源码,选择不登陆直接下载

3. 解压重命名

tar -zxvf  *.tar.gz
tar -xvJf  *.tar.xz  // 一般后缀为这个解压
mv * mysql  // *为文件名

4. 添加组和用户并创建存储文件夹

groupadd mysql  // 添加组
useradd -r -g mysql mysql  // 为组添加用户
mkdir /app/software/mysql_data  // 创建数据存储文件夹

5. 初始化mysql

./bin/mysqld  --user=mysql --lower-case-table-names=1 --initialize-insecure --basedir=/app/source/mysql --datadir=/app/software/mysql_data
# 使用mysql用户权限进行初始化，并设置数据读写忽略大小写，初始化密码为空，和确定初始化mysql文件夹于存储文件夹
# 如报错libaio.so.1, 则：yum install libaio

6. 修改配置/etc/my.cnf

[mysqld]
server-id                      = 1
user　　　　　　　　　　　　　　　　= mysql #指定用户，使用配置启动安全需求
port                           = 3306
mysqlx_port                    = 33060
mysqlx_socket                  = /tmp/mysqlx.sock
datadir                        = /app/software/mysql_data
socket                         = /tmp/mysql.sock
pid-file                       = /tmp/mysqld.pid
log-error                      = error.log #默认mysql_data目录
slow-query-log                 = 1
slow-query-log-file            = slow.log
long_query_time                = 0.2
log-bin                        = bin.log
relay-log                      = relay.log
binlog_format                  = ROW
relay_log_recovery             = 1
character-set-client-handshake = FALSE
character-set-server           = utf8mb4
collation-server               = utf8mb4_unicode_ci
init_connect                   = 'SET NAMES utf8mb4'
innodb_buffer_pool_size        = 1G
join_buffer_size               = 128M
sort_buffer_size               = 2M
read_rnd_buffer_size           = 2M
log_timestamps                 = SYSTEM
lower_case_table_names         = 1
default-authentication-plugin  = mysql_native_password

7. 更改权限，添加服务

chown -R mysql:mysql /app/software/mysql_data #修改所有者
chmod -R 777 /app/software/mysql_data #增加权限

./support-files/mysql.server文件中修改：
basedir=/app/source/mysql
datadir=/app/software/mysql_data

cp -a ./support-files/mysql.server  /etc/init.d/mysql  #添加服务

service mysql start/stop/restart #测试启动，如报错，查看error.log,根据错误提示解决

8. 设置全局

修改/etc/profile文件，在export PATH...上面：
#set for mysql
export MYSQL_HOME=/app/mysql
export PATH=$PATH:$MYSQL_HOME/bin

刷新配置source /etc/profile

9. 开机启动

# 设置开机启动
touch /usr/lib/systemd/system/mysql.service

[Unit]
Description=mysql
After=network.target
After=syslog.target

[Service]
User=mysql
Group=mysql
ExecStart=/app/source/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false

[Install]
WantedBy=multi-user.target

systemctl start/stop/restart mysql.service #启动服务
systemctl enable mysql.service #设为开机启动

 10 新增用户和权限

use mysql;

create user username identified by 'password';

select host, user from user;

show grants for username;

grant all on 数据库.* to 'username'@'%';

flush privileges;