Database Creation Problem Via Phpmyadmin

[McC]

I'm trying to create a new database via phpMyAdmin. Until now, I've done it through the cPanel interface, but I'd like to be able to do it all in one spot -- creation and maintenance and such.

 

What I'm doing is going to phpMyAdmin. Then, on the front page, in the MySQL column, the first option is "Create New Database" with a field for a database name. Typing anything in and then hitting "Create" results in the following page:

 

>SQL-query:

CREATE DATABASE `mcc3d_test`;

MySQL said:
#1044 - Access denied for user: 'mcc3d@localhost' to database 'mcc3d_test'

 

How can the localhost be denied access? Is there a setting I missed somewhere? Thanks.

[TCH-Andy]

Hi,

 

You need to create the database in Manage mySQL (in cpanel). You also need to assign a user to the database there. You can then use PHPmyAdmin to add data into the database.

[McC]

Yeah, that's the way I've been doing it. There's no way to bypass the manage SQL step and do the management through phpMyAdmin?

[TCH-Don]

You may already know this, but this is for others.

 

You do the management in phpMyAdmin

 

You have to create the database in Manage Mysql

its very easy

type a name click add DB

create user/password

Add user to database

 

then you can use or manage in phpMyAdmin