[mysql] host home cannot connect to mysql

Hey i tried everything, and i can't fix this error:/

Code:

---

Warning: mysql_connect() [function.mysql-connect]: Host 'home' is not allowed to connect to this MySQL server in D:AppServwwwsms_scriptailsconfig.php on line 27 Coudn't connect to MySQL Server

---

Quote:

---

$user1 = "root";
$pass1 = "*******";
$host1 = "localhost";
$data1 = "mydb";
mysql_connect($host1,$user1,$pass1) or die("Coudn't connect to MySQL Server");
mysql_select_db($data1) or die("Coudn't connect to MySQL Database");

---

execute this query in mysql database:

UPDATE `user` SET `Host`='%' WHERE (`Host`='localhost') AND (`User`='root')

nothing changed :$:

did it update something?

yes, it updated users table and set host to % but i still get same error

You have to reload permissions once you change the host.

Run:

FLUSH PRIVILEGES

Or just restart the mysql service.

Enjoy.

nvm fixed it

thank you for saying 'thank you' after i helped you!