mysql 安装

  1. mysql安装
 sudo yum update

sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

yum install mysql-server

  1. mysql启动
 sudo systemctl restart mysqld
USE mysql;
SELECT user, host, authentication_string FROM user;
 ALTER USER 'username'@'host' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
  1. mysql远程主机授权
CREATE USER 'root'@'%|ip' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%|ip' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容