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服务是否开机自启。
感谢阅览,暂时到这,结束。