1、检查是否已经安装mariadb,如果已经安装则进行删除:
![](https://img-blog.csdnimg.cn/37ad8cff60784659ad6ec3e70b837e98.png)
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
2、将安装包mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz上传到 /usr/local/src 文件夹下,解压mysql8, 通过xz命令解压出tar包, 然后通过tar命令解压出文件夹
xz -d mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
tar xvf mysql-8.0.26-linux-glibc2.12-x86_64.tar |
![](https://img-blog.csdnimg.cn/6b8510f1ab2d4fcdaa0fd3c607ee1c8f.png)
3、将/usr/local/src下的mysql-8.0.26-linux-glibc2.12-x86_64文件夹内容移动到/usr/local/mysql下
mkdir /usr/local/mysql
mv /usr/local/src/mysql-8.0.20-linux-glibc2.12-x86_64/* /usr/local/mysql
cd /usr/local/mysql |
![](https://img-blog.csdnimg.cn/7c8f1229b5df4fff8c9b93bc0e457919.png)
4、创建用户组及用户和密码
groupadd mysql
useradd -g mysql mysql |
5.授权用户
chown -R mysql.mysql /usr/local/mysql |
6. 使用命令 vim /etc/my.cnf 编辑my.cnf文件
文件内容:
[mysqld]
user=root
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
port=3306
max_connections=200
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
lower_case_table_names=1
group_concat_max_len=102400
[mysql]
default-character-set=utf8
[client]
port=3306
default-character-set=utf8 |
7. 进入到bin目录下, 初始化基础信息,最后一行后面会有个随机的初始密码保存下来一会登录要用(如果忘记了就删掉data重新初始化)
cd bin
./mysqld --initialize |
![](https://img-blog.csdnimg.cn/67522d188b4d41b684ca773ff809051e.png)
如果提示 :./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
8.添加mysqld服务到系统
8.1 先返回到mysql目录
![](https://img-blog.csdnimg.cn/18deb93ffbd841a182d690c639ca124b.png)
8.2 复制./support-files/mysql.server文件到/etc/init.d目录
cp -a ./support-files/mysql.server /etc/init.d/mysql |
![](https://img-blog.csdnimg.cn/acae99e5194143ca9af9a574b78f9f33.png)
8.3 添加系统服务,并设置开机启动
chmod +x /etc/init.d/mysql
chkconfig --add mysql |
![](https://img-blog.csdnimg.cn/06ef72ecaa4b483faae0f43e22dd7f53.png)
9.启动mysql
![](https://img-blog.csdnimg.cn/d0a6209c66df4dea94107e825642983d.png)
10 .将mysql添加到命令服务
ln -s /usr/local/mysql/bin/mysql /usr/bin |
11. 登录mysql,输入刚刚初始化时生成的密码
如果出现 mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory,则执行下面几条命令:
cd /usr/local/mysql/bin
ldd mysql
sudo ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
12.更改root用户密码, 注意语句后的;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Matrix@';
flush privileges; |
13.更改root连接权限
use mysql;
update user set host='%' where user = 'root';
flush privileges; |
14. exit; 退出mysql,现在就可以通过连接工具登录root账户进行远程连接了
如果不能连接,则需要检查防火墙状态:
# 查看防火墙的状态 > systemctl status firewalld.service
# 关闭防火墙 > systemctl stop firewalld.service
# 禁用防火墙开机自启动 > systemctl disable firewalld.service
15. 启动关闭mysql等相关命令
15.1 启动mysql
15.2关闭mysql
15.3重启mysql
16.查看mysql是否启动
![](https://img-blog.csdnimg.cn/17a6ce18927546bd9a609d514450f0f0.png)