MySQL Forums
Forum List  »  General

create database by an user other than root
Posted by: Khan Mannan
Date: February 03, 2010 12:16PM


I created one new user 'TestUser' and gave all the privileges to this user using 'root'. But, when i do login using 'TestUser' and try to create a new database 'TesTDB', i am getting this error:

"Access denied for user 'TestUser'@'%' to database 'TestDB'"

How to grant 'TestUser', so it would be able to CREATE DATABASE?

Thanks. /Khan.

Options: ReplyQuote

Written By
create database by an user other than root
February 03, 2010 12:16PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.