Shulou(Shulou.com)06/01 Report--

Operands:

Online and test all MySQL Plus databases

Create users: create user 'testname'@'%' identified by' 123456permissions; view the permissions of testname users show grants for testname;testname user authorizations: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX,ALTER,SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *. * TO 'testnam'@'%'

# create a user and authorize

GRANT ALL PRIVILEGES ON *. * TO 'testname'@'%'IDENTIFIED BY' 123456' WITH GRANT OPTION;testname users original permissions: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX,ALTER,SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER View user authorization: select * from mysql.user where User='testname' and Host='%'\ G Modify the user's authorization permission: update mysql.user set Grant_priv='Y' where User='testname' and Host='%';flush privileges; recovery permission: CREATE,DROP,ALTERrevoke CREATE,DROP,ALTER on *. * from testname@'%' Online license testname1:GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *. * TO 'testname1'@'%'

Mysqladmin-u testname1-h2.1.1.1 password C123456 "c123456"

Change the password:

Set password = password 'C123456'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.