Hello All,
I'm new to FreeBSD and started to use it before 2 months.
I'm running FreeBSD using Virtual Machine software... and I faced a problem and couldn't solve it and also didn't find any accurate solution for it.
The problem is that I'm unable to connect remotely to MySQL database, while the same code connects fine in the same network.
I was able to connect remotely to my server via FTP, SSH and some online games, but couldn't connect with my PHP code.
Should I use my IP or the Dynamic DNS?
I tried the following commands with no errors but didn't work too:
Some articles asked to modify the file "my.cnf" but I didn't find it anywhere in my FreeBSD, so do I need to use this file too?
I'm using FreeBSD 7.2-Release, MySQL-5.0.90 and also connecting to my server using DynamicDNS.
So is it possible to connect from my website to MySQL database on my server?
Thanks in advance
I'm new to FreeBSD and started to use it before 2 months.
I'm running FreeBSD using Virtual Machine software... and I faced a problem and couldn't solve it and also didn't find any accurate solution for it.
The problem is that I'm unable to connect remotely to MySQL database, while the same code connects fine in the same network.
I was able to connect remotely to my server via FTP, SSH and some online games, but couldn't connect with my PHP code.
Should I use my IP or the Dynamic DNS?
I tried the following commands with no errors but didn't work too:
Code:
mysql> GRANT ALL ON *.* TO root@"%" IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;
mysql> GRANT ALL ON *.* TO root@'sub.mydomain.com' IDENTIFIED BY 'MyPassword';
Some articles asked to modify the file "my.cnf" but I didn't find it anywhere in my FreeBSD, so do I need to use this file too?
I'm using FreeBSD 7.2-Release, MySQL-5.0.90 and also connecting to my server using DynamicDNS.
So is it possible to connect from my website to MySQL database on my server?
Thanks in advance