[thelist] problem connecting to mySQL server

[Chris Blessing]

I regularly use mysql_connect() without the password function to wrap my
password.  You don't *have* to use it unless (and this is based on a long
day at work with 1/2 a memory of this password() function) you set the user
password initially using the password() function (i.e. grant all privileges
on *.* TO user at localhost         identified by password('PASSWORD');).

-Chris

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Frank
Sent: Friday, November 30, 2001 5:30 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] problem connecting to mySQL server


>I'm having trouble using the mysql_connect() function. I keep getting the
>same error:

>   Warning: Access denied for user: 'casammar at leo' (Using password: YES) in
>/home/casammar/public_html/test.php on line 34

>I am using the following information to connect:
>   mysql_connect('members.evolt.org','casammar','PASSWORD');

>Can anyone help me?


Hah! I think I know the answer to this one. Try this:

mysql_connect('members.evolt.org','casammar', Password("PASSWORD"));

You can't simply select or insert your password straight, you need to
run it though the function passowrd().

That is providing you have the correct permissions.
--

Our best destiny, as planetary cohabitants, is the development
of what has been called "species consciousness" - something over
and above nationalisms, blocs, religions, ethnicities.


Frank Marion                      Framar Studios
frank at framarstudios.com           http://www.framarstudios.com

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !