下载地址:mysql官网下载
rpm -qa|grep mariadb
如果有存在则
xxxx
yum remove -y xxxx
rm -rf /var/lib/mysql
rm -rf /etc/my.cnf
rm -rf /usr/share/mysql
yum remove mysql mysql-server mysql-libs mysql-common
上传之前下载好的安装包
yum localinstall mysql80-community-release-el7-5.noarch.rpm -y
yum search mysql-community-server
yum install mysql-community-server
启动mysql
systemctl start mysqld
查看mysql状态
systemctl status mysqld
重启
systemctl restart mysqld.service
开机自启动
systemctl enable mysqld.service
设置可以远程连接
密码在 /var/log/mysql.log 中 root@ xxxxxx xxxxx则是初始化密码
mysql -u root -p
输入默认密码
对密码安全策略设置
set global validate_password.policy=0;
set global validate_password.length=0;
老版本是
(
set global validate_password_policy=0;
)
use mysql;
update user set host='%' where user='root';
#不限制连接仅为localhost
alter user 'root'@'%' IDENTIFIED BY '123456@';
#这个是为了避免远程连接工具例如navicat连接的时候mysql8自动设置了加密而连接不上
alter user 'root'@'%' identified with mysql_native_password by '123456@';
# 关闭防火墙或者 开启3306的访问端口否则远程访问不通
赋予任何主机访问数据的权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
FLUSH PRIVILEGES
如果想myuser用户使用mypassword密码从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;