How to install Mysql


How to install Mysql Via RPM :

Please check the following link and get RPM

http://httpupdate.cpanel.net/mysqlinstall/

in above list (not rpm) click on the version for which you want to install mysql
than click on the operation system
than on the version of operating system
here you should download RPM for
devel….development
server….
client….
Shared….and
Bench….

Download them on your server and install them (all with one command )

rpm –Uvh *rpm


How to Upgrade Mysql On Cpanel:

When a Client ask to update the Mysql than check these things
I )
Whether he is on VPS (go to billing and check)
II )
Whether he is on Cpanel or not … for this go to /usr/local…. Here must be cpanel

Go to WHM and change the MySql version (tweak settings > mysql) and than in shell run /scripts/mysqlup
Than you have to run /scripts/easyapache.
When you update the mysql than you will have to recompile the php because whenever you run the php it is using the mysql libraries, so when you update the mysql it is essential for php to update …. So easyapache recompile the php and it also update the apache server.
/scripts/easyapache

Check the version of php with this command

Php –v
Now check the file
Usr/local/apache/conf/httpd.conf
And see whether the lines are commented or not
If commented …. It means that php is running as a cgi scripts
If not commented…it means that php is running as a apache module

LoadModule php4_module libexec/libphp4.so -- as apache module
#LoadModule php4_module libexec/libphp4.so --as cgi module

There is difference in ownership when it is running as a cgi script or running as a apache module.


Downgrade mysql on Cpanel:

If a client ask you to downgrade mysql to some earlier version, than it must be kept in mind that the databases may not work for some earlier version, for this you have to take the dump of mysql in such a way which should be compatible to earlier version, for this you can use the following command.,

mysqldump -u root -p --create-options --compatible=mysql40 db_name > db_name.sql

where 40 is 4.0 , you can change this value with some for which you want to create a dump.
Better to ask the client to perform this step himself,
as this is end user task. But it is essential to warn him with this problem before moving any further.


Upgrade/install mysql on directadmin

http://www.howtoforge.com/lighttpd_mysql_php_debian_etch



How to upgrade Mysql on Interworx

some times there may be some dependencies on the server, you have to resolve those dependencies.

rpm -ihv http://mirror.steadfast.net/misc/iworx/php52/cos5/i386/iworx-php-release-5.2-1.steadfast.noarch.rpm
yum remove php-pdo
yum update php
service httpd restart

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL Optimization / Repair Information

How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and...

How can I monitor what my MySQL server is doing?

A handy little Linux application called mytop fits this just perfectly. This is a near-time...

How do I backup MySQL in Linux?

1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are...

How to reset a mySQL password?

If you have lost your root user password for MySQL, you can reset it with the following...

Repairing MySQL tables that will not open

This should be handled on a case by case basis, but if you are using the default MySQL table type...