使用yum安装
yum install http://repo.mysql.com//mysql57-community-release-el6-8.noarch.rpm
yum install mysql-server
启动服务
service mysqld start
修改初始密码
初始密码查看方式：
cat /var/log/mysqld.log|grep "temporary password"
第一次必须修改密码：
SET PASSWORD=PASSWORD('Root1234@');
创建用户
create user 'username'@'10.%' identified by 'Luck@123';
删除用户
DELETE FROM mysql.user WHERE User="username";
授权
GRANT ALL ON $databaseName.* TO 'username'@'10.%';
创建数据库
CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
删除表中数据，（重置自增）
TRUNCATE tablename;
刷新权限
flush privileges
网友评论