"ketvin" <[EMAIL PROTECTED]> wrote:
> Access denied for user: '@localhost' to database 'database'
>
>
> I have a database named 'database' and i got this problem while trying to
> get it run. I am connecting that database to localhost without user and
> password, it works just fine on my previous windows box, but since lately
> when i move it onto my linux box, it starts showing me that error message.
>
> It works when i connecting the database with user "root" , my problem is
> that how can i get it to work without using user "root" , just like the old
> days on windows box.
>
> Or is there anyway to add user/password for that particular database so that
> only that single user can access to that db ?
>
Initial MySQL privileges on Windows are not the same as on your Linux box. By default
on Windows user ''@'localhost' has all privileges. On Linux only user 'root' has all
privileges, anonymous user has privileges only on the database 'test'. So, you should
give permissions to the user on the database 'database':
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mysql.com/doc/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
