mysql database to add users and assign permissions specific implementation
- 2020-06-07 05:26:51
- OfStack
Create users and assign permissions;
insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));// Create a user
grant all privileges on dbname.* to 'username'@'%' identified by 'password';// Create the user and assign all permissions
grant select,update on phplampDB.* to phplamp@localhost identified by '1234';// Create users and assign permissions
update mysql.user set password=password(' The new password ') where User="phplamp" and Host="localhost";// Change user password
-- Deletes user-specified permissions
revoke insert,update,delete,select ON *.* from 'xbb'@'localhost' IDENTIFIED BY '123';