Rocky下安装mysql

安装版本

Rocky 8.5
Mysql 8.0.28

检查是否已安装

rpm -qa | grep mysql

下载安装包

若无wget命令，使用yum安装下

yum -y list wget

yum -y install wget.x86_64

下载

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.28-linux-glibc2.12-x86_64.tar

移动到/usr/local目录

mv mysql-8.0.28-linux-glibc2.12-x86_64.tar /usr/local

解压到安装目录，创建binlog、存储目录

tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar

继续解压mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz

tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz

得到解压后的目录，重命名下

mv mysql-8.0.28-linux-glibc2.12-x86_64 mysql

创建binlog和库文件的存储目录
mkdir -p /usr/local/mysql/binlog /appdata/data_mysql

创建mysql用户组、用户，赋权给mysql目录

groupadd mysql
useradd -g mysql mysql
chown -R mysql.mysql /usr/local/mysql/ /appdata/data_mysql

编译安装初始化

cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/appdata/data_mysql --basedir=/usr/local/mysql --lower_case_table_names=1

注：lower_case_table_names 在初始化时才能设置

记下root用户的临时密码，后面用于登录

创建my.cnf配置文件

cd /etc/
vi my.cnf

添加以下内容

[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set=UTF8MB4
[mysqld]
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
user = mysql
port = 3306
lower_case_table_names=1
character_set_server=UTF8MB4
innodb_file_per_table=1
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /appdata/data_mysql
log-error = /usr/local/mysql/mysql_error.log
#pid-file = /usr/local/mysql/mysql.pid
open_files_limit = 65535
back_log = 600
max_connections = 5000
max_connect_errors = 1000
table_open_cache = 1024
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 600
#thread_concurrency = 8
#query_cache_size = 128M
#query_cache_limit = 2M
#query_cache_min_res_unit = 2k
default-storage-engine = MyISAM
default-tmp-storage-engine=MYISAM
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 128M
max_heap_table_size = 128M
log-slave-updates
log-bin = /usr/local/mysql/binlog/binlog
binlog-do-db=oa_fb
binlog-ignore-db=mysql
binlog_cache_size = 4M
binlog_format = MIXED
max_binlog_cache_size = 8M
max_binlog_size = 1G
relay-log-index = /usr/local/mysql/relaylog/relaylog
#relay-log-info-file = /usr/local/mysql/relaylog/relaylog
relay-log = /usr/local/mysql/relaylog/relaylog
expire_logs_days = 10
key_buffer_size = 256M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
#myisam_recover
interactive_timeout = 120
wait_timeout = 120
#skip-name-resolve
#master-connect-retry = 10
slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
#master-host = 192.168.1.2
#master-user = username
#master-password = password
#master-port = 3306
server-id = 1

slow_query_log_file=/usr/local/mysql/mysql_slow.log
long_query_time = 1
[mysqldump]
quick
max_allowed_packet = 32M

启动服务，并添加自启动

添加软连接

ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

切换mysql用户，启动

su mysql
service mysqld start

如果启动失败，可能是开启了selinux
Starting MySQL… ERROR! The server quit without updating PID file (/appdata/data_mysql/master.pid).
添加selinux 安全标签解决此问题。参考：selinux mysql_MySQL的selinux配置

chcon -R -t mysqld_db_t /storage/db/

启动成功

添加服务

chkconfig --add mysqld

登录并重置密码，开放远程链接

登录数据库

/usr/local/mysql/bin/mysql -u mysql -p

有如下报错

root用户执行如下命令解决，参考：mysql 报 error while loading shared libraries: libtinfo.so.5 解决办法

ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

继续登录，然后又报错Access denied for user ‘mysql’@‘localhost’ (using password: YES)

参考博客链接的方式解决，跳过密码登录，重置密码后再正常启动登录

先执行

flush privileges;

重置密码

ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

创建新用户并授权:

grant all privileges on *.* to mysqldev@'%' identified by '123456' with grant option;

create user mysqldev@'%' identified by '123456';
grant all privileges on *.* to mysqldev@'%' with grant option;
flush privileges;
alter user mysqldev@'%' identified with mysql_native_password by '123456';

开放端口

开放防火墙3306端口，参考博客
远程连接成功