Here are some easy ways to help you fix the problem of reinstalling mysql cpanel.

You will probably reinstall MySQL on the cPanel server following our method below

First of all, you need to know the SQL RPMs generated on your server. For this inconvenience use the following command

rpm -qa | grep -i mysql

Then remove the required MySQL RPMs on the server using the using yummy command. All of this can be done with the following commands: yum.

 yum Lift MySQL55-shared-5.5.37-2.cp1136.x86_64 

reinstall mysql cpanel

 yum remove MySQL55-devel-5.5.37-2.cp1136.x86_64 
 yum remove MySQL55-client-5.5.37-2.cp1136.x86_64 

Then delete all mysql pid files with the following command

 rm / var / lib / mysql / * -f.pid 

Finally, you want to install a cPanel compatible Rpm, mysql, this can be done with a single real command. See Command term below,

 / scripts / check_cpanel_rpms Will --fix 

mysql will now be reinstalled.

When you need help troubleshooting problems with your server. Feel free to contact us, just write to supor [at] iserversupport.com

iServerSupport2020-11-27T15: 37: 58 + 00: 00

You can reinstall MySQL on the control panel server by following the method requirements below

First of all, in theWe need to know the SQL RPM packages that were installed on your hosting server. To do this, run the watch command

rpm -qa | grep MySQL

Then -i gets the required MySQL RPMs as the server uses the yum command. You can do this by calling yum watch commands.

 yum remove MySQL55-shared-5.5.37-2.cp1136.x86_64 
 yum remove MySQL55-devel-5.5.37-2.cp1136.x86_64 
 yum remove MySQL55-client-5.5.37-2.cp1136.x86_64 

After that, manually delete most of the mysql pid records using the following command:

 rm -f /var/lib/mysql/*.pid 

At work, you need to install a MySQL RPM compatible with your control panel, this can be done with a single command. See Command below,

 / scripts / check_cpanel_rpms --fix 

When you need help fixing something on your server. Feel free to contact us, just send an email to support [at] iserversupport.com

There are times when families have to completely reinstall MySQL or MariaDB, either because a particular package is damaged or has problems, or when in our client problem you installed almost all non-standardservice and actually get it Messages like:

We expected the market to drop to 5.6; however, the method is currently in version 5.5. from /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm, line 839. Production of information received from the system.

The file /usr/share/man/man1/mysql_config.1.gz from the installation associated with MySQL55-devel-5.5.52-1.cp1156.x86_64 conflicts with the MariaDB -devel-5.5 file package. 53-1.el6.x86_64

Error code W: 8

Unfortunately, reinstalling your own database packages is not an easy task and can easily turn into a nightmare, and sometimes even total disaster! So make sure the public does nearly all full account backups before you expect a new database with few users or tables in the worst case scenario. I recommend making backups from the WHM bridge interface, and also dumping the file directly from the mysql storage directory, which is in the following location:

 cd / var / lib / mysql / 

reinstall mysql cpanel

Once the person is sure you have a backup plan, if something goes wrong, you can goContinue with the rest of the steps to remove all MySQL / MariaDB packages and reinstall them using WHM.

Remove MySQL MariaDB / RPM

First of all, you want to know which MySQL MariaDB / RPMs are installed on your remote machine. For this problem, the following command -qa:

rpm | grep -i mysql

Then remove the required MySQL / MariaDB RPMs on the server using the yummy command. Below is a simple example. Remember to refer to the list above and call “yum repulse x”, where x is the series of each line returned above.

 yum Remove MySQL55-shared-5.5.37-2.cp1136.x86_64yum remove MySQL55-devel-5.5.37-2.cp1136.x86_64yum Remove MySQL55-client-5.5.37-2.cp1136.x86_64 

Then delete the mysql pid file and run the following command:

 rm / var / lib / mysql / * -f.pid 

New Installation Of MySQL / MariaDB-RPM

Finally, you need to install the WHM / cPanel compatible database RPMs with just one command:

 / scripts / check_cpanel_rpms --fix 

MySQL MariaDB is now reinstalled frequently based on the database version defined in WHM / p>

Missing Databases?

If you find that the databases are currently missing , you need to extract the backups from the / var / lib / mysql / directory, this should restore everything if you need to get back to normal, but if it crashes after that, you need both accounts restored from the backups. only one. This approach offers the shortest time depending on the problems encountered, i.e. if it works, it will be just as fast, you can restore the directory backup manually, so there is no wasted time, if there is nothing to play, then obviously the most time consuming is restore backups from account to hand, backup plan!

When you need all our help in solving a problem with your server. Just give us a call.

Do you need help? Maybe we are here for you!

We have an extremely friendly service – come to our live chat and let us know what you need, we work on an hourly basis and can usually provide you with the right to start working in a large percentage of cases. “Request support on click”Or contact our live chat.

Get help

We have a very friendly service – plus come to our chat and let most of us know what you need. We do our best for hourly rates, and we can also make you a non-binding offer and in most cases get started immediately. Request Click-Support also uses our online chat. Some

do you need help? We are here for you!

We need a very friendly service – come and chat with us so we can easily find out what you need, we work on an hourly basis, you can also provide a solid offer and in most cases get started immediately. “Request support on click” or use our live chat.

Get help

We have a very friendly solution – talk to us and then tell us about your needs. We work on an hourly basis, we can also make you a pleasant, non-binding offer and in most cases we proceedto work immediately. “Just click on support” or use our live chat.

Posted by Dean Williams. Professional PHP web developer with experience in OpenCart web development, wordpress web development, custom systems as well as an experienced Linux server administrator.