PHP Can't connect to MySQL on the production server
- by Jairo Santos
I'm having problems with connections with MySQL through PHP script.
The MySQL user is root and I added GRANTS to root@'%' so I can connect from anywhere.
Lets assume my MySQL host as "bigboy.com.br"
The funny part is, from my local machine, on my test server, the script can connect to the MySQL server normally. But on the dedicated server where MySQL is running, the same PHP script gives me "Access denied for 'root'@'bigboy.com.br'" error.