/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 vote193 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote207 views1 answer
Oracle search in date columns
SQL
0 vote212 views1 answer
How to get one year old query from plan cache
SQL
0 vote199 views1 answer
Différence entre deux dates sql oracle
SQL
15 votes407 views2 answers
How to sort names in alphabetical order in sql
SQL
3 votes194 views4 answers
Stop MySQL
SQL
0 vote240 views1 answer
Select the date 30 days less that the todays date sql request
SQL
8 votes239 views2 answers
Sqlsrv default port
SQL
0 vote191 views1 answer
Parsing float to int in mysql
SQL
2 votes202 views2 answers
Function in sql
SQL

Share