Tag Archives: mysql

Centos: recover MySQL users access after upgrade to MySQL-5.5

I had one of my customers asking me for the MySQL server version upgrade (OS provided MySQL 5.1.73 to something above MySQL 5.5) for one of his dedicated servers. Neither of us expected any problems from that, but we’ve ran into some that we had to resolve quickly because of production web sites running on the same server.
For more modern software versions I usually use excellent IUS reposity which in combination with EPEL repository serves about 87% of my needs in 3rd party packages and updates.
Read more »

Share Button

sysadmin: cPanel installation script detected MySQL and failed

While trying to install cPanel control panel on just reimaged server I’ve got an interesting error, I’ve never seen before:

Read more »

Share Button

Centos: How to run multiple mysql instances on a single server

centos_iconmysql There are plenty instruction on how to run multiple mysql instances on a single server on various blogs. Most of them are based on the original mysql rpm package produced by Oracle (nowdays). In my opinion this could be unnecessary overhead when you have OS provided mysql server package and all you need to configure another instance is to slightly modify bundled configuration and init.d script.
Read more »

Share Button

Centos: cPanel update demands to upgrade MySQL

cpblocked-btn I’ve hit cpanel update “blocker” the other day going from version 11.38 to 11.40.

cPanel update demands to upgrade MySQL and would not take no for an answer – why?
MySQL version 5.1 hits end-of-life on December 2013 and even though Red Hat mysql 5.0 is different from vanilla version and has to be supported until the end of Centos 5 support, cPanel wants to cover all bases and we really don’t have a choice in the situation.
Now, what we should to to continue?
Read more »

Share Button

Wordpress: how to trim your wp_options table

wpautoload
In my line of work I am exposed to various Wordpress installations – different plug-in sets, different themes, various amount of content – so, I have my fair share of troubleshooting Wordpress performance issues related to almost anything.
Read more »

Share Button

phpMyAdmin import.php Missing parameter problem solved

Very annoying phpMyadmin error. As you can see it points to the item in the phpMyAdmin FAQ page where there are list of possible causes which could lead to this kind of error. Let me give you a tip.
Read more »

Share Button

Mysql weekly/monthly backup: reliability in simplicity

mysqlI’ve been asked many times to put together mysql database backup with weekly/monthly rotation.
I’m pretty sure there are plenty of such scripts out there on the web.
I am going to add mine so that somebody can compare and choose.
Read more »

Share Button