yum makecache
// 查看系统信息
uname -a
whereis mysql
find / -name 'mysql*'
在mysql的官网找到安装源,yum方式(MySQL :: Download MySQL Yum Repository)找到对应版本信息
点击Download可以获取到下载链接
方式一:可以把RPM包下载上传到ECS服务器/root目录下安装
方式二:复制链接可以单独访问资源版本(Index of /232905)
安装:
wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
如果wget不可用,先使用yum安装wget
yum -y install wget
然后执行
rpm -ivh mysql80-community-release-el7-7.noarch.rpm
安装:
yum -y install mysql mysql-server mysql-devel
或
yum -y install mysql-server
常用命令:
// 重新加载
systemctl daemon-reload
// 启动
systemctl start mysqld.service
// 重启
systemctl restart mysqld.service
// 停止
systemctl stop mysqld.service
// 查看启动状态
systemctl status mysqld.service
// 开启开机启动
systemctl enable mysqld.service
// 禁止开机启动
systemctl disable mysqld.service
启动并查看mysql状态:
systemctl start mysqld.service
systemctl status mysqld.service
查看临时密码
cat /var/log/mysqld.log
或者
grep 'temporary password' /var/log/mysqld.log
临时密码:TJe)#fj(y0,-
使用临时密码登录mysql
mysql -u root -p
登录成功后重置密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Your.password';
授权远程连接并刷新权限:
RANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
flush privileges;
use mysql;
select Host, User from user;
update user set Host='%' where User='root';
show databases;
flush privileges;