Home » Forums » DBManager General
 
MySQL user permissions (1416 previews)
MySQL user permissions Posted in 08th, 11/2005 01:51 by b3booner
I have several MySQL databases and I want to create an account that allows read only access (select only) to these databases (and any future databases that get added).

I created a readonly table before - but have since added some databases - and am unable to connect. I get this error (from VBScript):

Access denied for user 'readonly'@'%'

I have attempted to change this in DBTools without any success.
Billy Boone /
Re: MySQL user permissions Posted in 08th, 11/2005 03:35 by support
Hi,

To fix this you need to grant the select privileges to this table to the user being used to connect to the server. Follow the steps:

- Select the users item in the Workspace and select the Objects View
- Select the user you want to change the privileges
- right click to open the context menu and select privileges
- follow the instructions in the dialog (more info available in the DBManager manual)

That's it.

Best Regards,

Support / DBTools Software
Re: MySQL user permissions Posted in 08th, 11/2005 03:53 by b3booner
When I right click on the user - I get an error:

User [readonly@localhost] doesn't exist in mysql.user system table.
Billy Boone /
Re: MySQL user permissions Posted in 08th, 11/2005 05:51 by support
Hi Billy,

The user you are using to connect to the server doesn't have privilege to GRANT or REVOKE this privileges or to change privileges.
In this case you will need to use the user root (if mysql) or an user with privileges enough to change these settings.


Hope that helps,

Support / DBTools Software
Re: MySQL user permissions Posted in 09th, 11/2005 10:02 by b3booner
DBTools is running on the same machine as the MySQL installation and I'm connecting as root.
Billy Boone /
MySQL user permissions (1416 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General