How to upgrade/downgrade MySQL version in cPanel server


You can easily change the major version of MySQL running on your server through WHM, keeping in mind that the actual version will be dependent on what cPanel has released in their repository.

WHM >> Software >> MySQL Upgrade >> Select between "MySQL 5.1" or "MySQL 5.5"

To change the MySQL version below 5.1, edit the file /var/cpanel/cpanel.config and look for this line:

mysql-version=5.1

Then change the version number to the major version that you want to downgrade to. For instance, 4.0, 4.1 or 5.0.

Then save the file and run the following script:

# /scripts/mysqlup --force

Now re-run apache build (easyapache) script 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:

http://dev.mysql.com/doc/refman/5.1/en/downgrading.html
http://dev.mysql.com/doc/refman/5.0/en/downgrading.html
http://dev.mysql.com/doc/refman/4.1/en/downgrading.html

Cheers :)

Comments

  1. Anonymous4/19/2022 1:28 pm

    How To Upgrade/Downgrade Mysql Version In Cpanel Server >>>>> Download Now

    >>>>> Download Full

    How To Upgrade/Downgrade Mysql Version In Cpanel Server >>>>> Download LINK

    >>>>> Download Now

    How To Upgrade/Downgrade Mysql Version In Cpanel Server >>>>> Download Full

    >>>>> Download LINK xt

    ReplyDelete
  2. complisApulc-goKansas City4/24/2022 7:15 pm

    complisApulc-goKansas City Alexis Thomas https://wakelet.com/wake/z-jZzB7qcPIhBdTjFmsyq
    xinpytingscob

    ReplyDelete
  3. UplicinQbi_n-19858/26/2022 4:48 pm

    Ydiuverygru1985 Jessica Wright MorphVOX Pro
    AVG PC TuneUp
    Avid Pro Tools
    workpulinthumb

    ReplyDelete
  4. subclaXloma12/01/2022 10:01 am

    valvemuba Thomas Newman Download
    there
    maesuncopa

    ReplyDelete

Post a Comment

Popular posts from this blog

SVN: File remains in conflict

This error occurs when you didn't update the SVN and try to commit changes or, someone has made changes to this file that are conflicting with your changes. There are two ways to handle this situation. Either, you can revert back the changes you want to commit and then, update the SVN and after that make the changes again and commit. The other way is, you need to resolve the conflicted files one by one. You can keep all the conflicted files in a folder and resolved it at once. >> Revert the changes steps: svn revert . -R svn up >> Resolve the conflicted files: svn resolved <file_name>
Read more

12 tweakings for WHM/cPanel to speed up WordPress

   1. Turning Mailman off – WHM >> Server Configuration >>  Tweak Settings and turning it off    2. Number of minutes between mail server queue runs (default is 60) – Setting it 120    3. Default catch-all/default address behavior for new accounts” to fail    4. Boxtrapper Spam Trap and SpamAssassin Spam Box delivery – off    5. Analog Stats – off    6. Conserve Memory at the expense of using more cpu/diskio – turn on    7. WHM >> Service Configuration >> FTP Server Configuration – Check ‘no’ to ‘allow anonymous logins and ‘no’ to ‘anonymous uploads’    8. WHM >> cPanel >> Manage Plugins – install spamdconf – then go to ‘Setup Spamd Startup Configuration’ – select option 2 ‘Maximum Children” to 2′    9. Run your cron jobs at off peak hours.   10. Install e Accelerator PHP accelerator (Recompile Apache with eAccelerator)   11. ...
Read more

HowTo: Enable extended logging for exim

When troubleshooting mail or attempting to discover the source of spam originating from your server, it is often useful to enable extended Exim logging. You can enable extended logging for exim though your shell prompt as well as through WHM interface. I am giving the steps for both ways one by one: 1. Through shell prompt: 1. Open exim.conf 2) Find this: hostlist auth_relay_hosts = * 3) After hostlist auth_relay_hosts = * add the following: log_selector = +address_rewrite +all_parents +arguments +connection_reject +delay_delivery +delivery_size +dnslist_defer +incoming_interface +incoming_port +lost_incoming_connection +queue_run +received_sender +received_recipients +retry_defer +sender_on_delivery +size_reject +skip_delivery +smtp_confirmation +smtp_connection +smtp_protocol_error +smtp_syntax_error +subject +tls_cipher +tls_peerdn 4) The final result should look like this hostlist auth_relay_hosts = * log_selector = +address_rewrite +all_parents +arguments +connecti...
Read more