sudo yum install mysql-community-{server,client,common,libs}-*
// 启动
sudo service mysqld startstopstatusrestart
// 查找临时密码
sudo grep 'temporary password' /var/log/mysqld.log
// 登录mysql
mysql -uroot -p
// 修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '******';
// 创建用户
create user 'cmp'@'%' identified by '******';
// 授权(需指定库)
grant ALL on *.* to 'cmp'@'%';
// 退出
exit;
下载地址:https://downloads.mysql.com/archives/community/
选择对应的版本和操作系统,下载
安装文档:https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
sudo yum install mysql-community-{server,client,common,libs}-*
// 启动
sudo service mysqld startstopstatusrestart
// 查找临时密码
sudo grep 'temporary password' /var/log/mysqld.log
// 登录mysql
mysql -uroot -p
// 修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '******';
// 创建用户
create user 'cmp'@'%' identified by '******';
// 授权(需指定库)
grant ALL on *.* to 'cmp'@'%';
// 退出
exit;
// 设置开机启动
2021-10-11 14:42systemctl enable mysqld.service
// 打开对外端口
sudo firewall-cmd --permanent --add-port=6379/tcp
sudo firewall-cmd --reload
您好,推荐您体验一下该实验:
https://developer.aliyun.com/adc/scenario/2e99ebec78674c4a91a3a3c8ed582fa7?spm=a2c6h.13858375.0.0.31305b9035cBYg
里面包含了:
2021-10-11 15:301. MySQL安装
2. MySQL日常运维管理
3. 基本SQL语句的使用