Mysql Permission

[NotoriousZach 0]

Hell I just registered and setup a new account. It says I do not have permission to create a MYSQL database. Why is this? and How can I be able to create a database. Thanks, Zach

[mizako 0]

Hell I just registered and setup a new account.  It says I do not have permission to create a MYSQL database.  Why is this?  and How can I be able to create a database. Thanks, Zach

56004[/snapback]

You should give a user permisions to create databases. To grant or revoke permisions in mysql take a look to the mysql manual. Here is the link:

Mysql manual grant-revoke

[NotoriousZach 0]

I will try it but im not sure how it will work. I dont have permission to even make a Database so i doubt i will have permission to create users. Hopefully it will work, thanks for your input.

[bjrn 0]

You are trying to make a new DB under "MySQL Databases" in your cPanel, right? And not in some PHP script of your own or in the phpMyAdmin section?I know trying to create new DBs in phpMyAdmin here on Trap can (will?) give you an access denied error.So if you are trying to use some home made PHP script or trying to do it in phpMyAdmin: don't, use "MySQL Databases" instead.

[NotoriousZach 0]

Oh ok ill give that a try, i was messing with PHPMYADMIN

[NotoriousZach 0]

Yeh i was making the mistake of using PHPmyadmin, thanks I got everything working great.