MySQL Forums
Forum List  »  General

Advanced Search
New Topic

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

Hi,

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
create database by an user other than root
Khan Mannan
February 03, 2010 12:16PM
Re: create database by an user other than root
Devart Team
February 04, 2010 01:23AM


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.