安装mysql

安装mysql8

<pre class="brush:bash;toolbar:false">wget -i -c https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
yum -y install mysql80-community-release-el7-1.noarch.rpm</pre>

 或者下面一句

<pre class="brush:bash;toolbar:false">yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm</pre>
<pre class="brush:bash;toolbar:false">yum install mysql-community-server</pre>
<pre class="brush:bash;toolbar:false">#---------------------------------------
gpg --export -a 3a79bd29 > 3a79bd29.asc
rpm --import 3a79bd29.asc
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
#---------------------------------------
yum install mysql-community-server</pre>

 /etc/my.cnf 


 文件中添加如下配置：


 lower_case_table_names=1 

<pre class="brush:bash;toolbar:false">#启动mysql8
systemctl start mysqld.service
#查看mysql8运行状态
systemctl status mysqld.service
#获取密码
grep "password" /var/log/mysqld.log
mysql -uroot -p
#修改一个复杂的密码：
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的复杂密码';
#查看密码策略：
SHOW VARIABLES LIKE 'validate_password%';
#mysql8的密码策略是 validate_password.policy 
#而mysql5的时候密码策略是 validate_password_policy 修改策略为低级：
set global validate_password.policy=LOW;
set global validate_password.length = 1;
即：
###
ALTER USER 'root'@'localhost' IDENTIFIED BY '!!QQqq123';
set global validate_password.policy=LOW;
set global validate_password.length = 1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
###
#添加一个用户用来远程访问
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'；</pre>

 开放防火墙3306端口


 firewall-cmd --permanent --zone=public --add-port=3306/tcp


 如果防火墙关闭状态，可以先打开


     1>  查看防火墙状态： systemctl status firewalld


     2>开启防火墙：systemctl start firewalld


 开启防火墙以后再执行开放端口命令即可。


 刷新防火墙


 firewall-cmd --reload


 如果你用navicat客户端登录可能会报错，因为密码认证方式不支持，默认是 caching_sha2_password，可以修改 /etc/my.cnf文件改变密码认证方式为  mysql_native_password


 在my.cnf文件的[mysqld]下面加上如下配置：


 default_authentication_plugin=mysql_native_password


 更改存储路径

<pre class="brush:bash;toolbar:false">mkdir /data/mysql
chown -R mysql:mysql /data/mysql
systemctl stop mysqld
cp -Rp /var/lib/mysql/* /data/mysql
cp /etc/my.cnf /etc/my.cnf.ori</pre>

 修改my.cnf

<pre class="brush:bash;toolbar:false">[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
[client]
port=3306
socket=/data/mysql/mysql.sock</pre>

 #ln -s /data/mysql/mysql.sock /var/lib/mysql/mysql.sock

<pre class="brush:bash;toolbar:false">setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config;cat /etc/selinux/config</pre>
<pre class="brush:bash;toolbar:false">systemctl start mysqld
#进入mysql运行 以确认是否更改
select @@datadir;</pre>

添加新评论

关于博主

文章分类

最受欢迎的文章

最近回复

其它