CentOS7-MySQL8.0.28安装记录+开机自启

CentOS7-MySQL8.0.28安装笔记记录

1. 下载

MySQL8.0.28

补图

补图

右击下载到本地再传，
或者 在线下载（注意版本号）

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-el7-x86_64.tar.gz

等下载完（推荐先更换yum源再下载，快很多，CentOS7换源看我这篇文章 点我跳转）

2. 解压

我这放在 /usr/local/ 目录下：

tar包先拆分

tar -xvf mysql-8.0.28-el7-x86_64.tar 

再解压

tar -zxvf mysql-8.0.28-el7-x86_64.tar.gz 

3. 重命名

[root@VM-0-2-centos local]# mv mysql-8.0.28-el7-x86_64/ mysql

4. 创建存储数据文件

[root@VM-0-2-centos local]# mkdir mysql/data

5. 设置用户组并赋权

[root@VM-0-2-centos local]# groupadd mysql
[root@VM-0-2-centos local]# useradd -r -g mysql mysql
[root@VM-0-2-centos local]# chown -R mysql:mysql /usr/local/mysql/
[root@VM-0-2-centos local]# chmod -R 755 /usr/local/mysql

6. 初始化MySQL

进入MySQL的bin目录

[root@VM-0-2-centos local]# cd mysql/bin

初始化

[root@VM-0-2-centos bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

./mysqld: error while loading shared libraries: libnuma.so.1: cannot
open shared object file: No such file or directory

报错，缺依赖::::
yum install -y libaio
yum -y install numactl

再初始化
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

7. 配置文件

[root@VM-0-2-centos bin]# vi /etc/my.cnf

配置文件修改为以下内容：

[client]
#password       = your_password
port               = 3306
socket          = /usr/local/mysql/data/mysql.sock
default-character-set = utf8mb4

[mysql]  
default-character-set = utf8mb4

[mysqld]  
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'

port            = 3306
socket          = /usr/local/mysql/data/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir = /usr/local/mysql/data

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

8. 启动MySQL

/usr/local/mysql/support-files/mysql.server start

9. 设置软连接，并重启MySQL

[root@VM-0-2-centos bin]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@VM-0-2-centos bin]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@VM-0-2-centos bin]# ln -s /usr/local/mysql/mysql.sock /var/mysql.sock 
[root@VM-0-2-centos bin]# service mysql restart

10. 登录并更改密码

[root@VM-0-2-centos bin]# mysql -u root -p
Enter password: 

首次改密：两种改密方式二选一，跟5.7版本的改密命令不同：

alter user 'root'@'localhost' identified by '123456';
set password for root@localhost = '123456';

最近又发现个问题，再次执行修改密码，竟然报错。。。？
ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@‘localhost’
后面想想是在第11步开放远程连接把表中的 localhosth 改为 % 了，第二次修改密码替换一下就好了，问题不大。

解决：
alter user 'root'@'%' identified by '123456';
flush privileges;

11. 开放远程连接

mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;    //刷新权限

12. 连接工具测试连接MySQL

然后退出MySQL使用 exit

13. 开机自启配置

将服务文件拷贝到init.d下，并重命名为mysqld

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

赋予可执行权限

chmod +x /etc/init.d/mysqld

添加服务

chkconfig --add mysqld

显示服务列表

chkconfig --list

注：如果看到mysql的服务，并且3,4,5都是开的话则成功，如果是关，则

chkconfig --level 345 mysqld on

重启电脑

reboot
ps -ef | grep mysql

查看mysql服务是否开机自启。

---

感谢阅览，暂时到这，结束。