I have had serious issues with Mysql for a few weeks.

It all started after an OS reload and a fresh install of Cpanel. I am sure you all must know by now that lately there have been bad mirrors during the install, resulting in incomplete installations. This DID initially happen to me.

After steps were taken to remove the bad mirrors and force Cpanel to locate new ones, I still had Mysql issues. The first one was the issue with the .sock that seems to be so popular. That issue was solved rather quickly.

Now, here's where the funky stuff comes in.

During Cpanel backups, I see this error over and over again:

Grabbing mysql dbs...DBD::mysql::st execute failed: Character set '#83' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file at /usr/local/cpanel/Cpanel/Mysql.pm line 685.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 686.
DBD::mysql::st execute failed: Character set '#83' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file at /usr/local/cpanel/Cpanel/Mysql.pm line 693.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 694.
Done

This "character set" error is also preventing an install of SiteZen Site Builder from completing.

We tried removing mysql and then and recompiling from RPM's and the problem persists. In fact, now I have even more serious problems. When users access phpmyadmin, they can see, and modify, ALL other users databases.

This is a very serious issue and so far I have not found anyone who can fix these problems. I had my former admin try, as well as the admin company I now use.

I am desperate now.

Does anybody know what causes these errors and how to fix them? Can anybody recommend someone I can hire to deal with it?

Looks to me that this is not a problem with the mySQL server but with the CPAN libraries to access a mysql server (i.e. DBD::mysql). Try upgrading this package or reinstalling it. See: http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm

What version of mySQL are you running? What version of DBD::mysql library?

PS: Also post your my.cnf file -- is it the same you used before? As far as users having access to all databases, check the mysql table and see if mysql isn't started with something like --skip-grant-tables. Does it required a password when you try to connect to mysql as root?

The version of MYSQL is 4.0.22 . It was downgraded from 4.1.7 after we had so many problems but that has not seemed to help much either.

To be honest, I am not well versed on how mysql interacts with anything, which is why I hired a management company. But this has been an ongoing issue and I can't fiddle faddle with it anymore. It needs to be fixed correctly.

This is the my.cnf file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
#log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

But this has been an ongoing issue and I can't fiddle faddle with it anymore. It needs to be fixed correctly.

Then probably your best bet is to find someone who can do this for you. There are several folks with good reputation on this board, but I don't know which ones "specialize" in mySQL and can upgrade the CPAN libraries for you.

Suggestions anyone?

Regarding users having access to all databases -- you have not answered if mySQL requires a password when you try to connect to mysql as root (I assume you have a root password set!). And for other users?

Sorry, that's all I can tell you :(.

I don't know about the password right now. It was, of course, set to null after the removal and re-install and when I tried to change the password so that it actually had one, it returned a "failed" error.

I stopped messing around with it after that. I do know that users require a password.

Originally posted by luki
Then probably your best bet is to find someone who can do this for you. There are several folks with good reputation on this board, but I don't know which ones "specialize" in mySQL and can upgrade the CPAN libraries for you.

Suggestions anyone?

Regarding users having access to all databases -- you have not answered if mySQL requires a password when you try to connect to mysql as root (I assume you have a root password set!). And for other users?

Sorry, that's all I can tell you :(.

I had Steve work on it. I knew he would be able to fix it, and he did.

Steve rocks! :)