/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 vote126 views1 answer
Sqlite3 now
SQL
0 vote136 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote126 views1 answer
What is initial catalog in sql connection string
SQL
0 vote145 views1 answer
Check if has alpha characters sql
SQL
1 vote146 views1 answer
Sql server get users
SQL
0 vote137 views1 answer
Mysql to get column name in database
SQL
10 votes137 views2 answers
Oracle alter sequence nextval
SQL
42 votes206 views6 answers
Sql query duplicate rows
SQL
0 vote134 views1 answer
Tsql cmd exec script from file
SQL
0 vote126 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL

Share