Windows 8 kullanmaya başladınız ve mevcut Vsphere Client’ınız ile bu hatayı alıyorsanız aşağıdaki versiyon numaralı kurulum paketi işinizi görecektir.
VMware-viclient-all-5.0.0-913577.exe
Windows 8 kullanmaya başladınız ve mevcut Vsphere Client’ınız ile bu hatayı alıyorsanız aşağıdaki versiyon numaralı kurulum paketi işinizi görecektir.
VMware-viclient-all-5.0.0-913577.exe
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '...' WITH GRANT OPTION
İstemci, MYSQL sunucuda bulunan veritabanına bağlanmak istediğinde aşağıdaki uyarıyı alır. “ERROR 1130: Host is not allowed to connect to this MySQL server”
$ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host '192.168.1.4' is not allowed to connect to this MySQL server
You can also validate this by doing telnet to 3306 mysql port as shown below, which will also give the same “host is not allowed to connect to this mysql server” error message as shown below.
$ telnet 192.168.1.8 3306 host 192.168.1.4 is not allowed to connect to this mysql server
If you want to allow a specific client ip-address (for example: 192.168.1.4) to access the mysql database running on a server, you should execute the following command on the server that is running the mysql database.
$ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES;
Also, update firewall rules to make sure port# 3306 is open on the server that is running the mysql database.
After the above changes, when you try to connect to the mysql database from a remote client, you’ll not get the “Host is not allowed to connect to this MySQL server” error message anymore.
How to grant remote access to MySQL for a whole subnet?
$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@’192.168.1.4′ IDENTIFIED BY ‘your-root-password’;
mysql> FLUSH PRIVILEGES;
GRANT ALL ON *.* to root@’192.168.1.%’ IDENTIFIED BY ‘your-root-password’;
mysql> GRANT ALL ON *.* to root@’192.168.1.%’ IDENTIFIED BY ‘your-root-password’;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '...' WITH GRANT OPTION
HP DL585G2 sunucunuz var ve Server 2008 R2 kuruyorsunuz .HP Smart Start ile kurmanıza rağmen network adapter ları tanımıyorsa Bios Firmware Upgrade yapmanız gerekiyor.