How to delete or remove MySQL user

• Facebook
• Twitter
• Line

1. Step 1 – Login root
2. Step 2 – List all mysql users
   
   PHP

   SELECT User,Host FROM mysql.user;

   1	SELECT User,Host FROM mysql.user;

3. Step 3 – List grants for a mysql user
   
   PHP

   SHOW GRANTS FOR 'bloguser'@'localhost';

   1	SHOW GRANTS FOR 'bloguser'@'localhost';

4. Step 4 – Revoke all grants for a mysql user
   
   PHP

   REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';

   1	REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';

5. Step 5 – Remove/Delete the user from the user table
   
   PHP

   DROP USER 'bloguser'@'localhost';

   1	DROP USER 'bloguser'@'localhost';

A note about DROP USER sql command to delete or remove a MySQL/MariaDB user account

ที่มา : https://www.cyberciti.biz/faq/how-to-delete-remove-user-account-in-mysql-mariadb/

• Facebook
• Twitter
• Line

Related Posts

MySQL GROUP_CONCAT order by แล้วตัดมา 1 ค่า…

connect data source ผ่าน gateway error We were…