[NTLUG:Discuss] MySQL question

[Brian Silvers]

After  you get in you need to create the database for the user and then
give user rights to the DB like

SYNTAX NOT EXACT:

GRANT SELECT,INSERT,UPDATE,DELETE,ALTER ON
databasename.*
TO [user]@[host] IDENTIFIED BY 'thepassword';

you have to be logged in as root to do this

here's a link on privileges
http://www.mysql.com/doc/G/R/GRANT.html


> what aboout

>
>> mysql -u root -p mysql
>
>
> ?
>
>
>
>
>> On Thursday 25 July 2002 01:50 pm, you wrote:
>>> mysql -u root mysql
>> That produced the following;
>> ERROR 1045: Access denied for user: 'root at localhost' (Using password:
>> NO)
>>
>> Bobby
>>
>> _______________________________________________
>> http://www.ntlug.org/mailman/listinfo/discuss
>
>
> Brian Silvers          bsilvers at x-net.com
> X-Net Web Systems      http://www.x-net.com
>
>
>
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss


Brian Silvers          bsilvers at x-net.com
X-Net Web Systems      http://www.x-net.com