/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
St_buffer mysql
SQL
0 vote253 views2 answers
T SQl Checking Your Username
SQL
11 votes259 views5 answers
How to install sqlite3 python
SQL
2 votes262 views6 answers
In operator in sql
SQL
0 vote248 views1 answer
Flask sqlalchemy update row
SQL
0 vote240 views1 answer
How to reset AI in sql
SQL
0 vote239 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote262 views1 answer
Report in database
SQL
0 vote293 views1 answer
Mysql convert charset
SQL
0 vote250 views1 answer
Assign value to var in SQL
SQL

Share