You are here:

Knowledgebase

Did you know that we are one of the cheapest domain registrars in the UK Find out more...

Portal Home > Knowledgebase > Databases > How do I grant permissions to a mysql standalone user?


How do I grant permissions to a mysql standalone user?




MySQL standalone users provide additional security in certain advanced applications of database use by restricting the permissions of a certain user to operate on the database. By default a standalone user has no permissions - they must all be granted specifically. 

Do note that standalone users are not required for normal use - when MySQL databases are created, a user will full permissions is created with them. 

Assuming that you have already created the MySQL database and the standalone user, you then need to login as the original database user (ie, click the 'Now' button under 'Manage' for the databse) and then run the following SQL command: 

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `webXX-dbname`.* TO 'n-webXX-user'@'%' WITH GRANT OPTION; 

Replacing webXX-dbname with the original database name, and n-webXX-user with the standalone username

If there are any other privileges that you need granted on a database, that you don't have access to, please get in touch with our support team with your request.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Language:

Testimonials

Fantastic support from polite staff - 10 stars!