The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL can't create users or DB's

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

  1. Bob_Paul

    Bob_Paul Registered

    Joined:
    Jan 9, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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/hosting.domain.com.pid 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)
     
Loading...

Share This Page