While connected to MySQL, issue the following instruction:
GRANT ALL PRIVILEGES to 'YourChoosesUsername'@'%' ON `database`
I don't remember exactly the syntax, but I think this should work. It means,
you giving all the permissions to the user YourChoosenUsername and you are
allowing him/her to connect from any computer (even the Internet if
applicable) on just the database `database`
Thanks
Emery
----- Original Message -----
From: "ketvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 11:42
Subject: Authentication
> 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 ?
>
>
> Thanks
>
>
>
>
>
>
----------------------------------------------------------------------------
----
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
