You need to create a root password and other users.

insert into mysql.user set
Host='localhost',
User='<whatever userid you want>',
Password=PASSWORD('<whatever password you want>'),
Select_priv='Y',
Insert_priv='Y',
Update_priv='Y',
Delete_priv='Y',
Create_priv='Y',
Drop_priv='Y',
Reload_priv='Y',
Shutdown_priv='Y',
Process_priv='Y',
File_priv='Y',
Grant_priv='Y',
References_priv='Y',
Index_priv='Y',
Alter_priv='Y',
Show_db_priv='Y',
Super_priv='Y',
Create_tmp_table_priv='Y',
Lock_tables_priv='Y',
Execute_priv='Y',
Repl_slave_priv='Y',
Repl_client_priv='Y',
Create_view_priv='Y',
Show_view_priv='Y',
Create_routine_priv='Y',
Alter_routine_priv='Y',
Create_user_priv='Y',
ssl_type='',
ssl_cipher='',
x509_issuer='',
x509_subject='';
flush privileges;

Adjust all privileges accordingly.

Is you MySQL properly installed ???
Can you login to mysql client as root from your localhost ???


----- Original Message -----
From: "David Blomstrom" <david_blomstrom@yahoo.com>
To: mysql@lists.mysql.com
Sent: Friday, March 23, 2007 11:42:28 AM (GMT-0500) Auto-Detected
Subject: Need Database Connection Sans Password

How would you write a database connection for a database on which you haven't yet established a username or password? None of the following work:

$link = mysql_connect ("localhost" , "root" , "") or die(mysql_error());

mysql_select_db ("test", $link) or die(mysql_error());



$link = mysql_connect ("localhost" , "root") or die(mysql_error());

mysql_select_db ("test", $link) or die(mysql_error());



$link = mysql_connect ("localhost") or die(mysql_error());

mysql_select_db ("test", $link) or die(mysql_error());


Thanks.






__________________________________________________ __________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail