mysql8.0 项目部署

mysql8.0

结果集横向显示&翻页

pager less -S
PAGER set to 'less -S'

创建utf8 数据库

CREATE DATABASE IF NOT EXISTS laravel DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

 

创建本地用户

CREATE USER 'laravel'@'localhost' IDENTIFIED WITH mysql_native_password BY 'aoyun2008';

创建远程用户

CREATE USER 'laravel'@'%' IDENTIFIED WITH mysql_native_password BY 'aoyun2008';

赋予本地指定数据库所有权限

GRANT ALL PRIVILEGES ON laravel.* TO 'laravel'@'localhost';

赋予远程指定数据库所有权限

GRANT ALL PRIVILEGES ON laravel.* TO 'laravel'@'%';

修改本地加密规则

ALTER USER 'laravel'@'localhost' IDENTIFIED BY 'aoyun2008' PASSWORD EXPIRE NEVER;

修改远程加密规则

ALTER USER 'laravel'@'%' IDENTIFIED BY 'aoyun2008' PASSWORD EXPIRE NEVER;

修改本地密码

ALTER USER 'laravel'@'localhost' IDENTIFIED WITH mysql_native_password BY 'aoyun2008'; 

修改远程密码

ALTER USER 'laravel'@'%' IDENTIFIED WITH mysql_native_password BY 'aoyun2008'; 

删除本地用户

drop user 'laravel'@localhost; 

删除远程用户

drop user 'laravel'@'%';

删除数据库

DROP DATABASE 'laravel';

刷新权限

FLUSH PRIVILEGES;