centos7安装mysql(yum)
centos7安装mysql(yum)1.下载mysql的repo源 $ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm(如果没有wget插件下载 yum install wget)2.安装mysql-community-release-el7-5.noarch.rpm
centos7安装mysql(yum)
1.下载mysql的repo源
$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm(如果没有wget插件下载 yum install wget)
2.安装mysql-community-release-el7-5.noarch.rpm包
$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
(获取两个mysql的yum repo源:/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo。)
3安装mysql
sudo yum install mysql-server
4.重置mysql密码
$ mysql -u root
5.修改权限
sudo chown -R root:root /var/lib/mysql
6.重启服务
service mysqld restart
7.重置登陆密码
mysql -u root
mysql > use mysql;
mysql > update user set password=password('123456') where user='root';
mysql > exit;
8开放root用户远程权限
grant all privileges on *.* to 'root' @'%' identified by '123456';
flush privileges;
9退出mysql设置防火墙端口
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
service iptables save
更多推荐
所有评论(0)