手把手教你 linux下安装mysql

1.安装

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm rpm -ivh mysql57-community-release-el7-9.noarch.rpm yum install mysql-server

 

2.启动 MySQL：

systemctl start mysqld

 

 

3.运行

systemctl status mysqld

source /etc/profile

配置文件执行

mysqld --defaults-file=/etc/my.cnf --user=root

4. 修改默认密码

 

1，停止mysql服务

systemctl stop mysqld.service

 

2，修改配置文件无密码登录

vi /etc/my.cnf

在最尾部加上

skip-grant-tables

保存

 

3，启动mysql

systemctl start mysqld.service

 

4，登录musql

mysql -u root

此处注意不要加-p

 

5,修改密码，mysql5.7用此语法

use mysql ;

 

update mysql.user set authentication_string=password('Bkschool.123#') where user='root' ;

 

update user set password=PASSWORD(''Bkschool.123#') where User='root';

 

GRANT ALL PRIVILEGES ON *.* TO 'bukexuetang'@'%' IDENTIFIED BY 'bukexuetang1234' WITH GRANT OPTION;

 

6,回到第二步骤去掉加上的

skip-grant-tables

 

7.刷新权限 

mysql> FLUSH PRIVILEGES;

 

8.退出mysql

mysql> quit

 

9.重启mysql

/etc/init.d/mysqld restart

 

10.使用root用户重新登录mysql

mysql -uroot -p 

Enter password: <输入新设的密码newpassword>