Centos7 安装 MySQL

just_like_fire923

已于 2023-01-07 20:05:30 修改

阅读量71

点赞数

文章标签： mysql linux 数据库

于 2023-01-05 08:59:34 首次发布

本文链接：https://blog.csdn.net/just_like_fire/article/details/128557327

版权

清除原有的mariadb：

rpm -qa | grep mariadb
rpm -e --nodeps 上步查询到的文件

下载安装：

# mysql 5.6

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-server -y

----------------------------------------------------------------------
# mysql 5.7

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install mysql-server -y

文件授权:

chown -R root:root /var/lib/mysql
chown root /var/lib/mysql/

mysql 中文乱码处理:

 编辑 /etc/my.cnf

[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

重启service mysqld restart

修改mysql 登录密码开放远程登录权限:

# mysql5.6 直接登录没有密码
use mysql;
update user set password=password('你的密码') where user='root';

# mysql5.7 登录
grep "password" /var/log/mysqld.log #查看临时密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码'; #必须8位以上大小写字母和数字


# 修改远程登录
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "你的密码";
flush privileges;
exit;