Centos7安装Mysql

Centos7安装Mysql

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

ls /etc/yum.repos.d/

yum repolist all | grep mysql

yum install mysql-server

rpm -qa | grep mysql

systemctl start mysql

systemctl restart mysql

systemctl stop mysql

systemctl enable mysql

mysql -u root

mysql> use mysql;

mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';

mysql> flush privileges;

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";

mysql>show grants for root@'%';

firewall-cmd --add-port=3306/tcp --permanent

firewall-cmd --reload

亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>