本文介绍了MySQL中如何创建用户、分配权限以及进行简单的数据库操作。包括创建不同权限级别的用户、授予特定数据库上的所有权限以及设置全局查询权限等。
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';
CREATE USER user01@'%' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON db01.* TO user01;
GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';
DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb;
USE userdb;
CREATE TABLE user(
id int(11)NOT NULL AUTO_INCREMENT,
userName varchar(20) DEFAULT NULL,
userPwd varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');
grant all on 数据库.* to 用户名@'主机' IDENTIFIED by 'password'
CREATE USER user01@'%' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON db01.* TO user01;
GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';
DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb;
USE userdb;
CREATE TABLE user(
id int(11)NOT NULL AUTO_INCREMENT,
userName varchar(20) DEFAULT NULL,
userPwd varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');
grant all on 数据库.* to 用户名@'主机' IDENTIFIED by 'password'
扫一扫
1800
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
