/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 vote201 views1 answer
PGSQL dynamic table name
SQL
5 votes213 views1 answer
Oracle create table comment
SQL
5 votes185 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote211 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote148 views1 answer
Plsql trigger insert update
SQL
0 vote193 views4 answers
How to connect form to database
SQL
0 vote192 views1 answer
Postgresql print sessions using the database
SQL
0 vote208 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote154 views1 answer
Expose db in virtualbox
SQL
13 votes198 views3 answers
Change data type postgresql
SQL

Share