[wellylug] mysql help
Lyndsay Mountfort
lyndsaym at paradise.net.nz
Wed Mar 17 19:00:30 NZDT 2004
Sam Sargeant wrote:
>On Wed, Mar 17, 2004 at 05:28:05PM +1300, Jamie Baddeley wrote:
>
>
>>can someone tell me a set of cli command that I can be sure will set a
>>given user a given password? I just want to allow localhost (i.e apached
>>and mysql are on the same machine)
>>
>>
>
>$ mysql
>
>
>
>>GRANT ALL on yourdatabase.* TO username at localhost IDENTIFIED BY 'password';
>>
>>
>
>Sam.
>
And you might like to confirm that the database login is all OK by testing it in a mysql console:
That way you can be sure where any remaining problems are, in the database permissions, or in the php code or setup.
Lyndsay
More information about the wellylug
mailing list