为了利用yum安装MySQL数据库,您需要执行以下步骤:
1.首先,您需要安装MySQL的yum存储库。您可以通过以下命令下载并安装MySQL存储库:
(1)wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
(2)sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm
2.安装MySQL服务器:
sudo yum install mysql-server
3.启动MySQL服务并设置开机自启:
(1)sudo systemctl start mysqld
(2)sudo systemctl enable mysqld
4.检查MySQL服务是否正在运行:
sudo systemctl status mysqld
5.使用以下命令登录MySQL:
mysql -u root -p
6.创建一个新的MySQL用户并授予所有权限:
(1)CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
(2)GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION;
(3)FLUSH PRIVILEGES;
7.退出MySQL:
exit;