目录

卸载自带数据库

下载安装包、解压并重命名 

启动mysql

修改 mysql 密码

创建远程连接用户

卸载自带数据库

• 卸载自带的mysql
• 卸载自带mariadb（centos7）

下载安装包、解压并重命名 

# 下载仓库
wget http://mirrors.163.com/mysql/Downloads/MySQL-5.5/MySQL-server-5.5.60-1.el7.x86_64.rpm
wget http://mirrors.163.com/mysql/Downloads/MySQL-5.5/MySQL-client-5.5.60-1.el7.x86_64.rpm
# 安装仓库
yum install -y MySQL-server-5.5.60-1.el7.x86_64.rpm
yum install -y MySQL-client-5.5.60-1.el7.x86_64.rpm

启动mysql

service mysql start

修改 mysql 密码

# 登录
mysql -uroot -p
# 修改密码
update user set password=password('root') where user='root';

创建远程连接用户

# 创建远程root用户密码root
# IDENTIFIED BY 'xxx' ----- xxx 代表密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
# 刷新权限
FLUSH PRIVILEGES;