cannot connect to mysql database

PAD_LOCK · 08-29-2006, 09:46 PM

Hello guys, Im new to ubuntu 6.06 and im having difficulty connecting to mysql database.

Access denied for user ''@'localhost' to database 'database_name'

Im using PHP Script

THANKS GUYs!

infestator · 08-30-2006, 01:48 AM

Code:

''@'localhost' to database 'database_name'
^                          ^
here should be username    here should be your database's name

you missing username and (it seems so) database_name.
in php you can use mysql_connect first, then mysql_select_db to select database:

Code:

<?php
$mysql_link = mysql_connect ('localhost', 'infestator', 'sample_password');
mysql_select_db ('infestator_db');
?>

smallville · 08-30-2006, 04:25 AM

if you are using a different workstation in connecting to mysql try replacing 'localhost' with the mysql server's ip address.

Also check the user's rights and password.

PAD_LOCK · 08-31-2006, 02:43 AM

PHP is installed in another computer which is our main server while my database MySQL is installed in my computer. Im using my IP address as my localhost.

smallville · 09-01-2006, 02:37 AM

then try connecting using ip_add

like

mysql_connect('192.168.1.69', 'username', 'password') or die(mysql_error());

xhi · 09-01-2006, 02:03 PM

> Im using my IP address as my localhost.

localhost is 127.0.0.1 not the ip address you are looking for. use smallville's example or something like it (add your ip to the hosts on the server and use the name you specify there, or declare a var to hold your ip, etc,etc,etc.)