/SQL/Mysql delete user if exists

Mysql delete user if exists

Mysql delete user if exists

DROP USER IF EXISTS 'user'@'127.0.0.1' ;

3

Source: stackoverflow.com

Mysql remove user privileges

REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'host';
OR 
DROP USER 'username'@'host';

1

Similar codes

1 vote178 views3 answers
Sql server get week dates from week number
SQL
3 votes190 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote193 views1 answer
Is not sql
SQL
0 vote171 views1 answer
Dump multiple tables mysql
SQL
0 vote245 views1 answer
Two inner joins sql
SQL
0 vote295 views1 answer
How to show current database in mysql
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
0 vote209 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote195 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote191 views1 answer
Adding generated time in row mysql workbench
SQL

Share