There is NO reference for the database you wanna access in the user table.
It is just a reference to the places from where you can access the Mysql
database and the corresponding user.
There are a lot of ways to do your task. You could even have used the host
table for this.
As such I can tell ya two of them.
Login to the mysql database as root
give - as root
# mysql mysql
then do one of the following
1. grant all on xxx to norton
OR
2. make an entry in the table db corresponding to that particular user
giving him rights for the database xxx
This should do the task for you.
VaibhaV
> hi all,
>
> I can access mysql databases by going thru root. But when I try to
> access mysql it says 'ERROR 1044: Access denied for user
> :'norton@localhost' for database xxx'
>
> What will be the problem? I tried to append the username to the 'user'
> table on the mysql db. But I can't get rid of that error message? Can
> anyone help me out how to set the access rights on mysql ?
>
----------------------------------------------
An alpha version of a web based tool to manage
your subscription with this mailing list is at
http://lists.linux-india.org/cgi-bin/mj_wwwusr
