mysql adds and removes users and permissions assignments
- 2020-06-03 08:36:16
- OfStack
1. New users
mysql>insert into mysql.user(Host,User,Password) values("localhost","lionbule",password("hello1234"));
mysql>flush privileges;
2. Change the user password
mysql>update mysql.user set password=password('new password') where User="lionbule" and Host="localhost";
mysql>flush privileges;
3. Delete users
mysql>DELETE FROM user WHERE User="lionbule" and Host="localhost";
mysql>flush privileges;
4. Assignment of authority
4.1. grant usage
grant permissions on database.* to username @' login host 'identified by' password '
Jurisdiction:
Commonly used to summarize , ALL/ALTER/CREATE/DROP/SELECT/UPDATE/DELETE
Database:
*.* All tables representing all libraries
test.* said test All the tables in the library
test.test_table said test The library test_table table
User name:
mysql Account name
Login host:
Allowed to login mysql server The client ip
'%' All said ip
'localhost' Says the native
'192.168.10.2' specific IP
Password:
The login password for the account
4.2 example
mysql>grant all on test.* to lionbule@'%' identified by 'hello1234';
mysql>flush privileges;
User lionbule with a new password of 'hello234' has all permissions on the test library and does not restrict the access of lionbule users to IP.
4.3 Matters needing Attention
grant will cover part of the user's information, just like insert and update.
Reference:
http://dev.mysql.com/doc/refman/5.6/en/grant.html