linux安装mysql命令
时间: 2023-04-18 10:00:58 浏览: 97
在Linux上安装MySQL的命令如下:
1. 更新系统软件包列表:
sudo apt-get update
2. 安装MySQL服务器:
sudo apt-get install mysql-server
3. 安装MySQL客户端:
sudo apt-get install mysql-client
4. 启动MySQL服务:
sudo service mysql start
5. 设置MySQL root用户密码:
sudo mysql_secure_installation
6. 登录MySQL:
mysql -u root -p
7. 创建新用户:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
8. 授权新用户:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
9. 刷新权限:
FLUSH PRIVILEGES;
以上就是在Linux上安装MySQL的命令。
相关问题
linux mysql命令安装
在Linux上安装MySQL的命令如下:
1. 下载MySQL的repo源:wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm (如果没有wget命令,请先执行yum -y install wget)
2. 安装mysql-community-release-el7-5.noarch.rpm包:rpm -ivh mysql-community-release-el7-5.noarch.rpm
3. 安装mysql-server:yum install -y mysql-server
4. 启动MySQL:service mysqld start
5. 设置开机自启动:chkconfig mysqld on
6. 安装mysql-connector-java:yum install -y mysql-connector-java
7. 初始化密码(设置root密码):mysql_secure_installation
完成上述步骤后,MySQL就成功安装在Linux系统上了。
linux安装mysql5.7命令
1. 下载MySQL 5.7安装包:
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
2. 安装MySQL 5.7:
sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
3. 安装MySQL 5.7服务:
sudo yum install mysql-server
4. 启动MySQL服务:
sudo systemctl start mysqld
5. 设置MySQL服务开机自启:
sudo systemctl enable mysqld
6. 查看MySQL服务状态:
sudo systemctl status mysqld
7. 登录MySQL:
mysql -u root -p
8. 修改MySQL root用户密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
9. 退出MySQL:
exit