/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

0 vote252 views1 answer
Mysql select last 15 minutes
SQL
1 vote254 views1 answer
Show table columns
SQL
0 vote262 views1 answer
Sql change date format
SQL
0 vote263 views1 answer
Complete date is 1 year or not sql server
SQL
9 votes260 views1 answer
Oracle get table schema
SQL
0 vote259 views1 answer
Add column in sql server ubuntu
SQL
0 vote440 views1 answer
Multiple row join
SQL
1 vote220 views1 answer
Oracle character set
SQL
0 vote284 views2 answers
How to take recent row without limit in mysql
SQL
0 vote266 views1 answer
Hibernate xml property MySQL url, username and password
SQL

Share