mengatasi error 1130: Host is not allowed to connect to this MySQL server ~ Tutorial Opensource and Linux

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.