/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 vote248 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote242 views1 answer
Create database like
SQL
0 vote226 views1 answer
Declarative base sqlalchemy
SQL
0 vote238 views1 answer
Mysql readable output
SQL
31 votes242 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote235 views1 answer
Template MySQL Zabbix agent
SQL
0 vote223 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote225 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote240 views1 answer
Mysql conf.d exampel
SQL
0 vote366 views1 answer
Sql developer export connections
SQL

Share