Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL can't create users or DB's

Discussion in 'Database Discussion' started by Bob_Paul, Jan 16, 2013.

  1. Bob_Paul

    Bob_Paul Registered

    Jan 9, 2013
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    Hi, hoping someone can help - For some reason out of the blue, none of my accounts can create users or databases in MySQL.

    With an existing account, which does have databases associated, when I go into phpmyadmin, they're there, but in the cPanel screen, it just says 'There are no databases associated with your account.' Even after creating a new database and it saying 'Added the Database admin_asdfasdfasdf.' - once refreshed, it's disappeared - and it's not in /var/lib/mysql/databasename either.

    I've tried updating mysql, but currently on 5.1.66, and this is my .err file - whilst there's some warnings, I don't think it's anything there?

    Any help is appreciated.....

    130117 08:59:52 mysqld_safe mysqld from pid file /var/lib/mysql/ ended
    130117 09:00:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130117 9:00:07 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    130117 9:00:07 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
    130117 9:00:07 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
    130117 9:00:07 [Note] Plugin 'FEDERATED' is disabled.
    130117 9:00:07 InnoDB: Initializing buffer pool, size = 8.0M
    130117 9:00:07 InnoDB: Completed initialization of buffer pool
    130117 9:00:07 InnoDB: Started; log sequence number 0 14463156
    130117 9:00:07 [Note] Event Scheduler: Loaded 0 events
    130117 9:00:07 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.66-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice