阿里云安装mysql

阿里云安装mysql

更新yum源

yum update 

下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

安装MySQL

yum install mysql-community-server

启动MySQL

systemctl start mysqld

查看状态

 netstat -nlp

进入mysql控制台(没有密码直接进入)

mysql -uroot -p

添加远程帐户

GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY 'Test123456!' WITH GRANT OPTION;

立即生效

flush privileges;

退出客户端

exit

阿里云卸载mysql

yum卸载

yum remove mysql-community-client mysql-community-common mysql-community-libs mysql-community-libs-compat mysql-community-server mysql57-community-release
rm -rf /var/lib/mysql  
rm /etc/my.cnf  

rpm 卸载

rpm -e mysql57-community-release-el7-9.noarch
rpm -e mysql-community-server-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-compat-5.7.17-1.el7.x86_64
rpm -e mysql-community-common-5.7.17-1.el7.x86_64
rpm -e mysql-community-client-5.7.17-1.el7.x86_64
cd /var/lib/  
rm -rf mysql/  

清除余项

whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
rm -rf /usr/bin/mysql

删除配置

rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret