[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