[RESOLVED] debugging

Toadums

Not finding anything in google...

So how exactly do you debug php code...when ever I try I get an error on this line:

mysql_connect("mysql.pdem.info",$username,$password) or die ("Unable to connect to server");

is there a trick or something I should know??

thansk!

dagon

mysql_connect("mysql.pdem.info",$username,$password) or die ("Unable to connect to server why?=". mysql_error());

how about that, it will then tell you what the error mysql is returning

Toadums

thanks, I tried that, but it is still doing this error. this is what happens.

When I open the page on line off my server, it all works fine (except the error i am trying to debug)..

but when I run it in a debugger, on the mysql_connect line i get an error like this:

warning: mysql_connect()[<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'toadums'@'S01060019d146b3a4.gv.shawcable.net' (using password:YES)

its like it cannot access the sql server (phpMyAdmin) when i dont open the php file on the server...

Does this make sense??

Randy_Jackson

I think you need to check the database permissions of the user on the server. It looks as if the user you set up is only able to connect from the server itself, and not remotely.

If you have SSH and MySQL command line access, you can grant the correct remote access like so:

Grant [permissions list] on [database list] to 'toadums'@'% identified by '[password]';

The % sign will allow access to the database from all domains.

Hope this helps.

Toadums

Randy Jackson;10920813 wrote:
It looks as if the user you set up is only able to connect from the server itself, and not remotely.
Grant [permissions list] on [database list] to 'toadums'@'% identified by '[password]';

I had a feeling that it was just not letting me connect remotely...cool! works now. couldnt get that syntax to work with my server...but i went to the control panel thing and just had to add:

%24.68.40.114
%broncos.dreamhost.com

to my permissions 😃

Thanks!!!