登录MySQL

mysql -uroot -p

8.0+安装教程

1. 执行以下命令，下载并安装MySQL

wget http://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm
yum -y install mysql80-community-release-el7-6.noarch.rpm
yum -y install mysql-community-server

2. 启动MySQL数据库

systemctl start mysqld.service

3. 查看MySQL初始密码

grep "password" /var/log/mysqld.log

4. 登录数据库

mysql -uroot -p

5. 修改密码安全策略

// 临时修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_12root';

set global validate_password.policy=0;
set global validate_password.length=1;

6. 修改MySQL默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '666666';

7. 授予root用户远程管理权限

CREATE USER 'root'@'%' IDENTIFIED BY '666666';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

或者

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '666666';

创建数据库

CREATE DATABASE newbee_mall_plus_db;