No option to downgrade mysql version

[kre8web]

Im in Tweak settings and under the SQL section there is no option to change mysql version. The only options are...

SQL
When displaying disk usage in cPanel/WHM include Postgresql and MySQL® disk usage. [Requires MySQL® 5+] (SQL disk usage is only updated every four hours)
Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)

Where do i find the option to change mysql versions?

Thankyou in advance

NVM, i see it, it has its own Mysql upgrade section

 

[cPanelDon]

Im in Tweak settings and under the SQL section there is no option to change mysql version. The only options are...

SQL
When displaying disk usage in cPanel/WHM include Postgresql and MySQL® disk usage. [Requires MySQL® 5+] (SQL disk usage is only updated every four hours)
Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)

Where do i find the option to change mysql versions?

Thankyou in advance

Upgrading to a new MySQL major version (e.g., from 4.0 to 4.1 to 5.0 to 5.1) is now moved into a new MySQL Upgrade tool and is accessible via the following menu path:
WHM: Main >> Software >> MySQL Upgrade

I recommend reviewing the official cPanel Release Notes for cPanel 11.25 that details further information about the new MySQL Upgrade tool as well as other new features, fixes, and enhancements.

 

[forlinuxsupport]

downgrade

You can downgrade mysql or change version by doing this :

vi /var/cpanel/cpanel.config

Change the line
mysql-version=

to 4.0 or 4.1 or 5.0

Now run :
/scripts/mysqlup --force

Now re-run apache build (easyapache) - so it can build php-mysql connector
/scripts/easyapache

 

[cPanelDon]

You can downgrade mysql or change version by doing this :
vi /var/cpanel/cpanel.config

Change the line
mysql-version=
to 4.0 or 4.1 or 5.0

Now run :
/scripts/mysqlup --force

Now re-run apache build (easyapache) - so it can build php-mysql connector
/scripts/easyapache

The method described would be performed at one's own risk. A manual downgrade is not recommended and can incur significant risk when attempted on an existing system. A full backup of the MySQL data directory is advised, and for a proper downgrade one should consider using mysqldump to create an SQL dump before downgrading.

Please ensure to thoroughly read the official MySQL documentation regarding downgrades:
MySQL :: MySQL 5.1 Reference Manual :: 2.4.2 Downgrading MySQL
MySQL :: MySQL 5.0 Reference Manual :: 2.18.2 Downgrading MySQL
MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 2.11.2 Downgrading MySQL