/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

2 votes159 views1 answer
Mysql sysdate
SQL
0 vote163 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote163 views1 answer
How to order result of subquery in select
SQL
0 vote183 views1 answer
Psql generate id in existing database
SQL
8 votes202 views4 answers
Postgresql server restart
SQL
12 votes159 views4 answers
Install mysql ubuntu 18.04
SQL
1 vote162 views1 answer
Reutrn string after character sql
SQL
0 vote163 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote165 views1 answer
How to change owner in postgres
SQL
17 votes225 views6 answers
Get last record in sql
SQL

Share