mysql安装学习记录

linux yum

安装

# 下载并安装MySQL官方的 Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm‘
# yum安装
yum -y install mysql57-community-release-el7-10.noarch.rpm
# 安装MySQL服务器。
yum -y install mysql-community-server

配置

# 启动MySQL
systemctl start  mysqld.service
# 查看MySQL运行状态
systemctl status mysqld.service
# 找出此时root用户的密码
 grep "password" /var/log/mysqld.log
# 进入数据库：
mysql -uroot -p
# MySQL默认必须修改密码之后才能操作数据库
use mysql;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '[new password]';

# 更改密码
update user set authentication_string=password("[yourpassword]") where user="root";
flush privileges;
exit;

#卸载自动更新
yum -y remove mysql57-community-release-el7-10.noarch

远程连接配置

# 改表法
use mysql;
　　mysql>update user set host = '%' where user = 'root';
　　mysql>select host, user from user;
　　
# 授权法
# 你想myuser使用mypassword（密码）从任何主机连接到mysql服务器的话,效果与该表一样　　
　　mysql>GRANT ALL PRIVILEGES ON *.* TO '[myuser]'@