MySQL create user error

Discussion in 'Free Hosting' started by manohoo, Jan 13, 2010.

Thread Status:
Not open for further replies.
  1. manohoo

    manohoo New Member

    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?
  2. vishal

    vishal -::-X10 Guru-::- Community Support

    Use Cpanel and not phpmyadmin to create database.This is found in cpanel ,Mysql Wizard
    Last edited: Jan 13, 2010
  3. galaxyAbstractor

    galaxyAbstractor Community Advocate Community Support

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

    manohoo New Member

    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?
    Last edited: Jan 13, 2010
  5. Skizzerz

    Skizzerz Free Hosting Guru Contributors

    you need to use cPanel in order to create new MySQL users or new MySQL databases -- you cannot do either from phpmyadmin
    Last edited: Jan 13, 2010
  6. manohoo

    manohoo New Member

    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
  7. papichulo_carioco

    papichulo_carioco Community Advocate Community Support

    To create a database and its corresponding user, you should use MySQL Databases, PhpMyAdmin not ;)
Thread Status:
Not open for further replies.

Share This Page