1. mysql 新建用户创建用户
命令:CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;
说明:
username:你将创建的用户名
host:指定该用户在哪个主机上可以登陆,如果是本地用户可用localhost,如果想让该用户可以从任意远程主机登陆,可以使用通配符%
password:该用户的登陆密码,密码可以为空,如果为空则该用户可以不需要密码登陆服务器
例子:
CREATE USER ‘dog’@‘localhost’ IDENTIFIED BY ‘123456’;
CREATE USER ‘pig’@‘192.168.1.101_’ IDENDIFIED BY ‘123456’;
CREATE USER ‘pig’@’%’ IDENTIFIED BY ‘123456’;
CREATE USER ‘root_admin’@’%’ IDENTIFIED BY ‘Te@ch8me’;
CREATE USER ‘pig’@’%’ IDENTIFIED BY ‘’;
CREATE USER ‘pig’@’%’;
2. 用户授权
GRANT ALL PRIVILEGES ON wordpress.* TO ‘user’@‘localhost’ IDENTIFIED BY ‘123456’;
mysql>GRANT ALL PRIVILEGES ON . TO ‘user’@‘localhost’ IDENTIFIED BY ‘123456’;
授予user用户在所有数据库上的所有权限。
如果此时发现给的权限太大了,我们可以只给user用户授予某个数据库的权限,这时需要撤销刚才的授权,
mysql>EVOKE ALL PRIVILEGES ON . FROM ‘user’@‘localhost’;
mysql>GRANT ALL PRIVILEGES ON wordpress.* TO ‘user’@‘localhost’ IDENTIFIED BY ‘123456’;
还可以指定该用户只能执行 select和update命令:
mysql>GRANT SELECT, UPDATE ON wordpress.* TO ‘user’@‘localhost’ IDENTIFIED BY ‘123456’;
刷新权限:
mysql>FLUSH PRIVILEGES;
用新建的用户登录。
3.删除用户
mysql>DROP USER user@localhost;
4.索引sql
alter table table_name
add index index_name(column1
,column2
,column3
);
DROP INDEX <索引名> ON <表名>
SHOW INDEX FROM <表名> [ FROM <数据库名>]