https://dev.mysql.com/downloads/repo/yum/
wget http://up.htmltoo.com/soft/yum/mysql80-community-release-el8-4.noarch.rpm
yum -y remove MariaDB-client
---检查是否已安装（强力卸载）
rpm -qa|grep mysql
rpm -e --nodeps
rm -rf /var/lib/mysql && rm -rf /etc/my.cnf && rm -rf /usr/share/mysql
whereis mysql
find /-name mysql
yum remove mysql mysql-server mysql-libs
rpm -ivh mysql80-community-release-el8-4.noarch.rpm
yum localinstall mysql80-community-release-el8-4.noarch.rpm -y
yum install mysql-server -y
systemctl start mysqld
-空密码登陆
mysql -A -uroot -p
配置root用户的远程登录
select version();
use mysql;
select host,User from user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
create user 'root'@'%' identified by '123456';
FLUSH PRIVILEGES;
grant all privileges on *.* to 'root'@'%';
FLUSH PRIVILEGES;
ps -ef | grep mysql
mysqladmin --version
---启动mysql服务,查看状态
systemctl restart mysqld
systemctl enable mysqld
systemctl status mysqld
systemctl stop mysqld
---相关安装目录
/usr/bin //相关命令
/usr/share/mysql //配置文件目录
/var/lib/mysql //数据库文件存放目录
/etc/my.cnf.d //mysql的启动配置文件
client.cnf //mysql客户端配置文件
mysql-server.cnf //mysql守护进程配置文件
mysql-default-authentication-plugin.cnf //默认权限授权配置文件
备注：可复制一份到/etc下，修改成my.cnf
---mysql登录（不用密码登录）
mysql -u root
---重置root密码
use mysql;
alter user 'root'@'localhost' identified by 'r';
-把Host表内容修改为%
use mysql;
update user set host='%' where host='localhost';
flush privileges;
yum -y remove mysql-server
rpm -qa | grep -i mysql
pm -e --nodeps mysql80-community-release-el8-2.noarch
---
cd /var/lib/
mv mysql /data/file/
ln -sf /data/db/mysql /var/lib
cd /var/log/
mv mysql /data/logs
ln -sf /data/logs /var/log/mysql
vim /etc/my.cnf.d/mysql-server.cnf
[mysqld]
port=3396
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid
server-id=2
binlog_format=row
log_bin = /var/log/mysql/mysql-bin
log_bin_index = /var/log/mysql/mysql-bin.index
log-error = /var/log/mysql/error.log
binlog_expire_logs_seconds = 7
max_binlog_size = 200M
sync_binlog = 1
#开启慢查询日志
slow_query_log=1
#超出时间设定值的SQL即被记录到慢查询日志
long_query_time = 2
slow_query_log_file = /var/log/mysql/slow.log
bind-address = 0.0.0.0
default_storage_engine = InnoDB
max_connections = 10000
max_allowed_packet = 500M
wait_timeout= 600
interactive_timeout = 600
