Method One:
Execute the command:
The SQL code
mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passwordsql' WITH GRANT OPTION;
Description:
Enter this command and press Enter to allow all to use the root user and enter "123456" password of the
host to log in to the the mysql Server
If the '%', then replaced with an IP address, then only that the IP address of the host in order to root
the connect to the MYSQL Based Server.
Method two:
Execute the command:
The SQL code
mysql -u root -p
mysql> use mysql;
mysql> the update user set host = '%' where user = 'root';
Description:
Change the "mysql" database "user" table "host" "localhost" value to "%"
This address is
Terima kasih telah membaca artikel tentang mengatasi error 1130: Host is not allowed to connect to this MySQL server di blog Tutorial Opensource and Linux jika anda ingin menyebar luaskan artikel ini di mohon untuk mencantumkan link sebagai Sumbernya, dan bila artikel ini bermanfaat silakan bookmark halaman ini di web browser anda, dengan cara menekan Ctrl + D pada tombol keyboard anda.