centos7.7安装mysql8多实例3307

检查系统中是否存在Mysql的文件

find / -name mysql

删除存在mysql的文件或文件夹

rm -rf /usr/lib64/mysql/

检查是否存在mysql的相关依赖

rpm -qa|grep mysql

卸载mysql的依赖

rpm -e mysql-.....

创建用户和文件夹

useradd mysql
passwd mysql
su mysql
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-el7-x86_64.tar.gz
mkdir /data && cd /data
tar -zxvf mysql-8.0.23-el7-x86_64.tar.gz
mv mysql-8.0.23-el7-x86_64 mysql_3306
cp -r mysql_3306 mysql_3307
su root
chown -R mysql:mysql /data/mysql_3306/ /data/mysql_3307/
su mysql
cd /data/mysql_3306

vim my.cnf

[mysqld]
port=3306
basedir=/data/mysql_3306/
datadir=/data/mysql_3306/data/
socket=/data/mysql_3306/mysql.sock
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
user=mysql
slow_query_log=on
slow_query_log_file=/data/mysql_3306/slow-query.log
[client]
port=3306
socket=/data/mysql_3306/mysql.sock
default-character-set=utf8
default_authentication_plugin=mysql_native_password

vim /data/mysql_3306/support-files/mysql.server

basedir=/data/mysql_3306/
datadir=/data/mysql_3306/data/

#Set some defaults
mysqld_pid_file_path=/data/mysql_3306/mysqld.pid
if test -z "$basedir"
then
  basedir=/data/mysql_3306/
  bindir=/data/mysql_3306/bin
  if test -z "$datadir"
  then
    datadir=/data/mysql_3306/data
  fi
  sbindir=/data/mysql_3306/bin
  libexecdir=/data/mysql_3306/bin

  #Try to find basedir in /etc/my.cnf
  conf=/data/mysql_3306/my.cnf

vim /data/mysql_3306/support-files/mysqld_multi.server

basedir=/data/mysql_3306/
bindir=/data/mysql_3306/bin

初始化，记录密码
cd /data/mysql_3306
./bin/mysqld --defaults-file=/data/mysql_3306/my.cnf --initialize --console --user=mysql

运行
cd /data/mysql_3306
./bin/mysqld_safe --defaults-file=./my.cnf &

连接MySQL
./bin/mysql --socket=./mysql.sock -uroot -p # 输入初始密码

修改密码
alter user root@localhost identified by “root”;

启动脚本
vim mysql_start.sh

./bin/mysqld_safe --defaults-file=./my.cnf &

关闭脚本
vim mysql_shutdown.sh

./bin/mysqladmin -uroot -p123456 -S /data/mysql_3306/mysql.sock shutdown

#远程设置

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

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

连接
cd /data/mysql_3306
./bin/mysql --socket=./mysql.sock -uroot -p

修改账户密码加密规则并更新用户密码
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新一下用户的密码

刷新权限并重置密码
FLUSH PRIVILEGES; #刷新权限

3307配置
vim /data/mysql_3307/support-files/mysql.server

[mysqld]
port=3307
basedir=/data/mysql_3307/
datadir=/data/mysql_3307/data/
socket=/data/mysql_3307/mysql.sock
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
user=mysql
slow_query_log=on
slow_query_log_file=/data/mysql_3307/slow-query.log
[client]
port=3307
socket=/data/mysql_3307/mysql.sock
default-character-set=utf8
default_authentication_plugin=mysql_native_password

vim /data/mysql_3307/support-files/mysql.server

vim /data/mysql_3307/support-files/mysqld_multi.server
初始化，记录密码

./bin/mysqld --defaults-file=/data/mysql_3307/my.cnf --initialize --console --user=mysql

运行
cd /data/mysql_3307

./bin/mysqld_safe --defaults-file=./my.cnf &

https://www.cnblogs.com/doseoer/p/9974795.html

https://www.cnblogs.com/fqgump/p/12957145.html