WebHosting Blog

Archive for August 29th, 2008

Running Multiple MySQL versions

Friday, August 29th, 2008

If you would like to run multiple versions of MYSQL on same server without making any changes to the existing system you should follow the below steps
First download the source the tar file from mysql.com.
$> tar xfz mysql.tar.gz
$> cd mysql.XX

Important **
“/etc/my.cnf ” is the default file that is used by a mysql server. When the […]

Change Password for SQL Server User

Friday, August 29th, 2008

Using Query Analyzer it is easy to coordinate with the database server while you would like to change the password, to change the SQL Server User name password,  just connect to the database with Query Analyzer using the SQL Server Username that is being updated and the current password. Then run “sp_password” to change the […]