**服务器上部署mysql**
- 检查是否有安装mysql服务`
rpm -qa|grep -i mysql`
- 安装则去除
rpm -ev --nodeps mariadb-libs-5.5.65-1.el7.x86_64
yum -y remove mariadb-libs
``
3. 下载相应的安装包下载地址https://downloads.mysql.com/archives/community/ 4. 安装
tar xvf MySQL-5.6.32-1.el7.x86_64.rpm-bundle.tar`
依次执行下面命令
rpm -ivh MySQL-devel-5.6.32-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.32-1.el7.x86_64.rpm
rpm -ivh MySQL-server-5.6.32-1.el7.x86_64.rpm
- 启动服务
service mysql start
- 允许管理员远程登录
select user, host from user; #查看用户信息
update user set password=password('abc123456') where user = root; #修改管理员密码
update user set host='%' where user='root' and host='127.0.0.1'; #允许管理员远程登录
flush privileges; #刷新权限