/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 vote163 views1 answer
Mssql last day of month
SQL
27 votes149 views4 answers
Get all tables with column name sql
SQL
28 votes144 views4 answers
Show tables mysql
SQL
2 votes155 views2 answers
Postgresql search all tables for column name
SQL
0 vote157 views1 answer
Sql server roles and users
SQL
0 vote135 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote161 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote144 views2 answers
Mysql on update current_timestamp
SQL
0 vote140 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
16 votes180 views3 answers
Order by sql query
SQL

Share