/SQL/Host is not allowed to connect to this mysql server

Host is not allowed to connect to this mysql server

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Source: stackoverflow.com

Host '' is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON *.* TO root@my_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

Source: confluence.atlassian.com

Similar codes

0 vote225 views2 answers
What is rownum in oracle
SQL
0 vote206 views1 answer
Mysql shell set time_zone
SQL
7 votes211 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote203 views1 answer
How to group by month using sql server
SQL
0 vote203 views1 answer
Get cpu details sql
SQL
0 vote274 views1 answer
How to add auto increment primary key
SQL
25 votes193 views3 answers
How to use a database to see tables mysql
SQL
0 vote225 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote190 views1 answer
Access refused mysql xampp server
SQL
0 vote208 views1 answer
How to increase the width of the screen in oracle
SQL