ok. i have installed mysql, apache and php 5 and they are all running. my apache and php is working well but mysql is giving me trouble. when i try to connect using mysql_connect it wont work, i even tried the GUI interface of my web development program to connect but no luck, so it aint my code. i figured it is a permission problem. im running mysql on linu FC4 and designing on windows. so i used GRANT ALL ON <db>.* TO <user>@my windows ip IDENTIFIED BY 'pass';

But sadly it still gave me the same errors(unidentified error when using the GUI and white screen when using the php code). i have now run out of options, tried tutorials but they all tell me to do what i already did. it might be something to do with permissions(still) or odbc. i really dont know. can someone pls help me?...

check if MySQL is running on tcp mode.
The port should be 3306.
Can you telnet it from windows?
At least you will know if it is a network problem of MySQL config problem.

okay i used the commen prompt and typed telnet <mysqlip> 33306 and it gave me an error, what now?

My bad, the port is actually 3306


UPS!

now that works, so whats next, i believe that my apache does not recognise mysql, becuase when i use phpinfo() it sais nothing about mysql and when i use mysql_connect it gives a white screen

You need to recompile the php with mysql comptibility.
But is really odd for quite some time now all distros packed a php with mysql and postgres.


Can you connect with a non web based app?
Like MySQLCC or something like it?