Linux安装MySQL

Linux CentOS7 minimal 安装MySQL

1. 卸载

1. 卸载原有程序

yum remove mysql mysql-server mysql-libs compat-mysql51

1. 查看是否还有MySQL

rpm –qa|grep -i mysql

1. 查看残留目录

whereis mysql

1. 删除MySQL目录

rm –rf /usr/lib64/mysql

1. 删除相关文件

rm –rf /usr/my.cnf

rm -rf /root/.mysql_sercret

1. 关键

rm -rf /var/lib/mysql

2. 安装

1. 先安装依赖包

yum install -y perl-Module-Install.noarch

yum-y install autoconf

1. 创建用户和组

groupadd mysql

useradd -r -g mysql mysql

1. RPM的方式安装

yum localinstall mysql-community-release-el6-5.noarch.rpm

yum install mysql-server

1. 启动MySQL

service mysqld start

1. 给root用户设置密码

/usr/bin/mysqladmin -u root password 'root'

1. 连接MySQL

mysql -u root -p root

1. 关闭防火墙

systemctl stop iptables

1. 授权远程连接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

1. 测试