/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

1 vote178 views2 answers
Mysql show views
SQL
1 vote204 views1 answer
Replace all numbers in mysql
SQL
0 vote174 views2 answers
Add new column after in sql
SQL
0 vote181 views1 answer
Case when with count and combining similar values in sql
SQL
4 votes187 views1 answer
Mysql biginteger size
SQL
0 vote187 views1 answer
Show size of all tables postgres
SQL
2 votes198 views1 answer
Node and mysql like
SQL
0 vote188 views1 answer
Search mysql database for column
SQL
0 vote189 views1 answer
Mysql Selected All Duplicate Rows
SQL
3 votes197 views2 answers
How to start mysql in terminal
SQL

Share