PDA

View Full Version : mysql server


Phoenix
11-07-2004, 04:51 PM
i'm making my computer into an sql/php server so that i can test code w/o an internet connection. I can't seem to get a user/password login. i tried root//root but it still won't connect.

If anyone has any help to offer on this matter i would be very thankful.

here's my login code just in case it's the problem

$host = 'localhost';
$user = 'root';
$password = 'root';

$dbcon = @mysql_connect($host,$user,$password);

iDxMan
11-07-2004, 11:03 PM
Try it without a password. There is no default password for root last time I checked.

Also check to see that MySQL is setup to listen to port 3306. If not then, you need to specify the socket.

-r

stuka
11-08-2004, 11:06 AM
Phoenix: the simplest way to test that is to get to a command prompt on the MySQL server box, and try to connect using the command line client mysql -U root if that fails, then there probably IS a password - if it succeeds, there's not.