/SQL/Mysql remove user privileges

Mysql remove user privileges

Mysql delete user if exists

DROP USER IF EXISTS 'user'@'127.0.0.1' ;

3

Source: stackoverflow.com

Revokeprivileges mysql

REVOKE ALL ON dbname.* FROM 'username'@'localhost';

2

Mysql remove user privileges

REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'host';
OR 
DROP USER 'username'@'host';

1

Similar codes

7 votes214 views1 answer
Append column sql
SQL
5 votes217 views1 answer
Oracle ora-00054 causes
SQL
12 votes240 views6 answers
How to install sqlite3 in python
SQL
0 vote220 views1 answer
No suitable driver found for sqlite
SQL
1 vote237 views1 answer
How to put value in variable mysql
SQL
6 votes228 views2 answers
Mysql first day of month
SQL
0 vote240 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote241 views3 answers
How to run sql query
SQL
2 votes231 views1 answer
Apex execute batch job
SQL
4 votes236 views1 answer
Mysql copy table with new name
SQL

Share