Menu
when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this
306
From the output of the command, the user is only allowed to connect to the database server from the localhost. So, we need to update the user's hosts as follows. To give a user remote access from all host on a network, use the syntax below: MariaDB [(none)]> GRANT ALL ON database_name.
SQLSTATE[HY000] [1130] Host '172.19. 0.11' is not allowed to connect to this MySQL server error occurs when the connection request is rejected by the MySQL server. By default, the MySQL server only accepts connections from local hosts and not from other hosts.
On your server run mysql from command line:
mysql -u root -p -h localhost -P 3306
Then run this command in mysql shell:
>use mysql
>GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'yourpassword';
>FLUSH PRIVILEGES;
Have a nice time.
95
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
