MySQL create user error

[manohoo]

I can create a new user by using cpanel's MySQL Database, I don't get any errors.

But... the user is not actually created. PHPadmin shows "No privileges" in red font right below "Create Database".

PHPMyAdmin' SQL window command returns this error when attempting to create a new user:
Error

SQL query:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'whatever'
MySQL said:
#1227 - Access denied; you need the CREATE USER privilege for this operation

Can anyone ehlp me?

 

[vishal]

Use Cpanel and not phpmyadmin to create database.This is found in cpanel ,Mysql Wizard

 

[galaxyAbstractor]

When you assign a user you create in cPanel to a database, do you choose "All privileges"?

 

[manohoo]

Thanks for the replies. I followed your advice, no success.

I find it odd that there's no table 'user' in the info schema:

* CHARACTER_SETS
* CLIENT_STATISTICS
* COLLATIONS
* COLLATION_CHARACTER_SET_APPLICABILITY
* COLUMNS
* COLUMN_PRIVILEGES
* INDEX_STATISTICS
* INNODB_BUFFER_POOL_CONTENT
* INNODB_IO_PATTERN
* INNODB_RSEG
* KEY_COLUMN_USAGE
* PROCESSLIST
* PROFILING
* ROUTINES
* SCHEMATA
* SCHEMA_PRIVILEGES
* STATISTICS
* TABLES
* TABLE_CONSTRAINTS
* TABLE_PRIVILEGES
* TABLE_STATISTICS
* TRIGGERS
* USER_PRIVILEGES
* USER_STATISTICS
* VIEWS
Any suggestions?

 

[Skizzerz]

you need to use cPanel in order to create new MySQL users or new MySQL databases -- you cannot do either from phpmyadmin

 

[manohoo]

Thanks, I know what I was doing wrong.

I added the user, but I failed to add the user to the database! I was trying to do that in PHPMyAdmin, but as you guys said, it can't be done there.

Thanks for your help

 

[papichulo_carioco]

To create a database and its corresponding user, you should use MySQL Databases, PhpMyAdmin not