MySQL can't create users or DB's

Bob_Paul

Registered
Jan 9, 2013
3
0
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)