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>