centos7.3安装mysql5.5
时间: 2023-10-20 14:05:49 浏览: 48
1. 安装MySQL 5.5的Yum Repository
```
sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
```
2. 安装MySQL 5.5
```
sudo yum install mysql-server
```
3. 启动MySQL服务
```
sudo systemctl start mysqld
```
4. 设置MySQL服务开机自启动
```
sudo systemctl enable mysqld
```
5. 查看MySQL服务状态
```
sudo systemctl status mysqld
```
6. 修改MySQL root密码
```
sudo mysql_secure_installation
```
7. 登录MySQL
```
mysql -u root -p
```
8. 创建新用户并授权
```
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
```
9. 退出MySQL
```
exit
```
注:上述命令中的“newuser”和“password”需要替换为你自己的用户名和密码。
相关问题
centos7.3安装mysql5.1
1. 下载MySQL5.1的安装包,可以从MySQL官网下载,也可以使用yum安装:
```
yum install mysql-server
```
2. 安装MySQL,运行以下命令:
```
rpm -ivh MySQL-server-5.1.73-1.glibc23.x86_64.rpm
rpm -ivh MySQL-client-5.1.73-1.glibc23.x86_64.rpm
```
3. 配置MySQL,运行以下命令:
```
chkconfig --levels 235 mysqld on
service mysqld start
```
4. 设置MySQL的root用户密码,运行以下命令:
```
mysql_secure_installation
```
5. 登录MySQL,运行以下命令:
```
mysql -u root -p
```
6. 创建新用户,并授权:
```
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
```
7. 退出MySQL:
```
exit
```
以上是CentOS 7.3安装MySQL5.1的简单步骤,具体操作可以根据实际情况进行调整。
centos7安装mysql5.5
1. 添加mysql官方yum源
```bash
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
```
2. 安装MySQL
```bash
sudo yum install mysql-community-server
```
3. 启动MySQL
```bash
sudo systemctl start mysqld
```
4. 查看MySQL是否启动成功
```bash
sudo systemctl status mysqld
```
5. 设置MySQL开机自启动
```bash
sudo systemctl enable mysqld
```
6. 修改root密码
```bash
sudo grep 'temporary password' /var/log/mysqld.log
sudo mysql_secure_installation
```
7. 登录MySQL
```bash
mysql -uroot -p
```
8. 修改字符集
```sql
ALTER DATABASE `mysql` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
ALTER TABLE `user` CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
```
9. 创建新用户
```sql
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![text/plain](https://img-home.csdnimg.cn/images/20210720083646.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)