启动命令
systemctl start mysqld
状态查看命令
systemctl status mysqld
查看临时密码:
cat /var/log/mysqld.log | grep -i password
进入Mysql:
mysql -u root -p
Enter password:
修改密码:
alter user 'root'@'localhost' IDENTIFIED by 'PASSWORD';
查看数据库命令
show databases;
创建数据库
create database test;
选中数据库
use test
查看tables
show tables
删除tables
dop table tablename
创建用户
CREATE USER 'user'@'localhost' IDENTIFIED BY 'PASSWORD2';