I have been getting MySQL problems since day one on my Cobalt RAQ4i server from RackShack. It installs fine, and everything is setup, but for some reason when I try to install scripts such as Vbulletin I get errors on certain tables saying things like

"Warning: Supplied argument is not a valid MySQL result resource in /home/sites/home/web/phpmyadmin/lib.inc.php on line 507"

Its almost like this MySQL is not stable, or its just not working properly, we have reinstalled it about 3 times now...

What is the best MYSQL version for RAQ4 server? Any suggestions or help?

I installed the latest (3.23) linux RPMS from mysql.com. We have not had any problems, but we do not use PHP just C++ and PERL interfaces.

The error you mention seems more like a PHP error. Also, you may want to check permissions -- perhaps your script is trying to do something that it does not have permissions to do.

When troubleshooting, I usually toggle my scripts to run as the mysql root and switch it back to the script user when I am finished.

This is where I got my mysql. I installed the server, client, and development libraries.

http://www.mysql.com/downloads/mysql-3.23.html

Can you get into MySQL from the command line at all?

This is done with this command:
mysql -uroot -p