cPanel and 64-bit MySQL

cPanel will only use the 32-bit version of MySQL if your system OS is 32-bit. You cannot use 64-bit MySQL on a 32-bit OS system. You'd have to change your operating system to be 64-bit. You can check your architecture type with this command:

Code:

uname -a

If it shows i386 or i686, both are 32-bit architecture. If it shows x86_64, then the system is 64-bit.

 

Please provide the output from "uname -a" command. Sometimes, people believe that the OS is 64-bit when using i686 but that is actually 32-bit

You can ensure when you query to see the architecture type for the rpm with this command:

Code:

rpm -qav --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep -i mysql

When I do this on my 64-bit system with cPanel's MySQL, I show the following:

Code:

root@host [~]# rpm -qav --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep -i mysql
MySQL-devel-5.1.58-0.glibc23.x86_64
MySQL-shared-5.1.58-0.glibc23.x86_64
MySQL-client-5.1.58-0.glibc23.x86_64
MySQL-test-5.1.58-0.glibc23.x86_64
MySQL-server-5.1.58-0.glibc23.x86_64

Now, the only reason I can see for the wrong rpm type to be installed would be if you have /var/cpanel/sysinfo.config with the wrong architecture type listed:

Code:

grep arch /var/cpanel/sysinfo.config

If it has the wrong architecture listed, then cPanel will try to install the 32-bit rpms rather than the 64-bit rpms. If you correct that file, but do not remove the 32-bit rpms, then both the 32-bit and the 64-bit rpms will be installed for MySQL.

The correct return for a 64-bit system would be this:

Code:

root@host [~]# grep arch /var/cpanel/sysinfo.config 
rpm_arch=x86_64

If you have the wrong information in that file, you can fix that by moving the file and regenerating it:

Code:

mv /var/cpanel/sysinfo.config
/scripts/gensysinfo

If you have the wrong rpms installed, you can remove them and reinstall MySQL:

Code:

rpm -qav --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep -i mysql
rpm -e MySQL-fullrpmname
/scripts/mysqlup --force

For the fullrpmname portion, replace with the full name of each individual rpm. Of note, you will need to recompile Apache for the PHP MySQL modules once you've done this. You can do that in command line with "/scripts/easyapache" or using WHM > EasyApache (Apache Update) area.

 

I am uncertain if that is due to limiting it for 32-bit systems, since there is an error report about this message as a bug report:

MySQL Bugs: #62269: CREATE TABLE...ENGINE=innodb; Does not fail if InnoDB couldn't load, MyISAM used

This is the actual part of the error message (the rest is simply telling you details as to reasons it could be happening not stating you are on a 32-bit system):

Of note, providing this error message at the onset would have been extremely helpful. It would also be great if you can provide the MySQL version you are using:

Code:

mysql_config --version

Thanks!

Edit: I didn't see your message as I was typing mine before you had the second post on having figured out the issue. Glad you got it sorted. Going forward, again, it would be best to provide the error message itself at the beginning.