#administration #mysql

MySQL manage users

1. Removing users from the database. DROP USER 'USERNAME'@'HOSTNAME'; 2. Creating users – 3 common ways: A) The default way: CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; B) As an insert statements: INSERT INTO `mysql`.`user` (Host,User,Password) VALUES('localhost','dummy',''); FLUSH PRIVILEGES; #it is neccessary, when creating users this way C) Batch adding users. Create a file (useradd.sql for example) which contains all create users statements : CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'USERPASSWORD'; GRANT SELECT ON `DATABASE`. ...