代码如下:
# vi mysqlusers.txt
create database dataname;
grant all privileges on dataname.* to usernamelocalhost identified by ‘password‘;
flush privileges;
# /usr/local/mysql/bin/mysql -u root -p password < mysqlusers.txt
蓝色斜体部分为对应的用户名和密码,添加多个用户及数
1. 首选使用root用户登录数据库
mysql -uroot -p
2. 使用mysql 数据库
USE mysql;
3. 为mysql创建用户:dev 密码为:dev12345
CREATE USER dev IDENTIFIED BY 'dev12345';
4. 查看下用户dev的权限
SELECT * FROM user WHERE user='dev' ;
SHOW GRANTS FOR dev;
5. 给用户dev在数据库名为dev_db上赋EXECUTE(执行存储过程),I
创建用户并分配权限; 代码如下: insert into mysql.user(Host,User,Password) values(“localhost”,”phplamp”,password(“1234”));//创建用户 grant all privileges on dbname.* to ‘username’’%’ identified by ‘password’;//创建用户并分配所有权限 grant select,update on phplampDB.* to phplampl