MySQL: How to clean MySQL from RHEL5

configurationlinuxMySQLtroubleshooting

I have installed MySQL 5.1.73 community edition through RPM. It was working fine.
I uninstalled this version by using yum remove mysql-server command.
I wanted to upgrade MySQL from 5.1.73 to 5.6.19 community edition.
Then I installed it by sudo rpm -i /u000/MySQL-server-5.6.19-1.rhel5.x86_64.rpm command.
After installation, I was able to start mysql by issuing sudo /etc/init.d/mysql start.
After this, I tried to install MySQL-shared-compat-5.6.19-1.rhel5.x86_64.rpm using RPM command. But, it is giving conflict message with mysql 5.1.73 – install of MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-4.el6.x86_64.
It is same for MySQL-client-5.6.19-1.rhel5.x86_64.rpm. Again, I got the similar conflict message.
After this, I tried to connect MySQL by issuing below command:

$ mysql -uroot -p3pkvFtaWM_PTCwJ8 
-bash: mysql: command not found
  • How can I fix this issue and run the MySQL 5.6 as normally?
  • Do I need to clean MySQL from server?

Best Answer

Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql

Delete any packages like mysql, mysql-server, mysql-client, mysql-shared, mysql-shared-compat, mysql-libs. yum remove mysql-server You do not need to remove mysql library bindings like python-mysqldb, php-mysql, etc., unless they had a dependency with some of the previous packages.

I recommend you to install the Oracle MySQL yum repositories, that will make the installing and maintenance much easier, unless you know what you are doing and want more control over your packages. An installation guide is detailed here: http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/index.html Basically, it involves creating a .repo file and yum update.

Related Question