You wrote, "Is you MySQL properly installed ???"
Apparently. I just finished reinstalling MAMP (Apache, PHP & MySQL for Mac),
and I was able to copy a database I had created earlier into the MySQL folder.
"Can you login to mysql client as root from your localhost ???"
I'm not sure what you mean, but I can manipulate my databases using phpMyAdmin.
"You need to create a root password and other users."
OK, can I go into phpMyAdmin, click (Databases)...which displays no particular
database at all...then click the little SQL tab on the left and paste the code
you gave me in the SQL window? And that will create a username and password
that will work for every local database I create, right?
Thanks.
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.
----- Original Message -----
From: "David Blomstrom" <[EMAIL PROTECTED]>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
____________________________________________________________________________________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121
