Running Multiple MySQL versions
By bob | August 29, 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 new version is tested it will load the default configuration’s in /etc/my.cnf.
To resolve this you can replace every instance of ” cnf ” inside the source folder to ” conf ” by using this following command.
find ./ -type f | xargs perl -pi -w -e 's/cnf/conf/g;'
1) The default user generally is “mysql”. Add another user and group for example mysqlt for the new version of MySQL.
2) A typical ./configure command…
./configure --prefix=/usr/local/mysql --enable-local-infile
--with-tcp-port=4444 --with-mysqld-user=mysqlt
--with-base_dir=/usr/local/mysql --with-log=/usr/local/mysql/mysqld.log
--with-pid_file=/usr/local/mysql/mysqld.pid
-with-unix-socket-path=/tmp/mysqlt.sock --localstatedir=/var/lib/mysqlt
The new values you will use for your new MySQL server are:
Port number : 4444
mysql user : mysqlt
base_dir : /usr/local/mysql
data directory : /var/lib/mysqlt
log file : /usr/local/mysql/mysqld.log
3) Compile and Install
make && make install
4) Create your new MySQL config file.
cp support-files/my-medium.conf /etc/my.conf
cd /usr/local/mysql bin/mysql_install_db --user=mysqlt ( this will install all the needed databases ) bin/mysqld_safe --user=mysqlt &
TO SET A PASSWORD FOR THE MySQL root USER
/usr/local/mysql/bin/mysqladmin -u root -h hostname password 'new-password' /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
5) To start the service
cd /usr/local/mysql ./share/mysql/mysql.server start
6) To test
#telnet localhost 4444 and you should see this Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. + 4.0.26-logIE^*THL
You’ve done, now you can copy mysql.server >> rc.d to start it when the server is rebooted.
Warning: Never use two servers that update data in the same databases.
Topics: mysql server | 1 Comment »
Change Password for SQL Server User
By bob | August 29, 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 password. This approach provides the flexibility to change the password at the most appropriate time for the application.
sp_password [ [ @old = ] ‘old_password’ , ]
{ [ @new =] ‘new_password’ }
[ , [ @loginame = ] ‘login’ ]
The Office Microsoft Documentation for sp_password
Here is a simple example that changes the current password from
“currentPassword” to “newPassword”;
sp_password ‘currentPassword’, ‘newPassword’
However make sure to use a strong password, “newPassword” is just an example. For a quick test to confirm that the new password is working, close Query Analyzer and then re-connect with the new password. That is all there is to it, except for changing your connections string.
It is obvious, but still critical to remember to change the password in your connection string if this SQL User name is used in your code. Once the password has been changed and tested with Query Analyzer, update the connection string with the new password and test that everything still works correctly, and you’re done.
Topics: Web Hosting | No Comments »
Web 2.0 Green WP Theme from Micfo
By bob | August 2, 2008
Supporting green hosting initiative Micfo.com web hosting Company released elegant wordpress theme-”Web 2.0 Green Web theme” with orange and white highlights-originally designed by Corry Miller who has given a very clean & cool look! You can Preview & Download free for your blog.
Source: http://www.micfo.com/forums
Topics: Blogging | No Comments »
Web Hosting-Customer service and support
By bob | July 29, 2008
While choosing a web hosting service the major consideration should be given to find a providers that offers excellent customer service and support. You must give top priority to choose the host providers that offers 24 hours a day, 7 days a week technical support that fielded with highly experience and knowledgeable staff, so that you can get solve any problem within a reasonable amount of time. You may also opt to test how responsive their customer support is by sending mail or by dropping a ticket to the web hosting provider. In most cases, any response in less than 24 hours is considered acceptable and if you get response after one day, it is a sign of poor customer service.
Additionally, a hosting provider with excellent support should also provide multiple support channels, such as toll-free phone support, 24/7 email support, live chat, online knowledgebase, web hosting tutorials and FAQ.
Also it is important to know about their stability like how long has the web hosting provider in business and the number of customers they have. Since the large curstomer base is also good indication of the quality of their hosting products as well as the stability of the company. Also price should not be a major deciding factor while choosing a reliable hosting service.
Furthermore it is important to make sure that the web hosting service that you choose is able to meet your website hosting requirements, like guarantee for uptime since your website should always accessible with agreeable speed, and they should provide scalability consistent to your growth with excellent customer supports.
Topics: Hosting Tutorials | No Comments »
Disk space & Bandwidth requirement
By bob | July 17, 2008
Disk space & Bandwidth requirement Overview.
Bandwidth is defined as the capability to transfer data from one point to another in a fixed amount of time. The greater the bandwidth speed you have, the more data you can send over your Broadband Internet connection which is often refers to a data rate measured in bits/s. Depending on your web hosting requirement
While choosing host providers depending on your requirement you will need disk space and bandwidth. If you plan to publish a website that does not have a lot of contents then the disk space requirement may not be a huge concern to you. In most cases, a disk space with 200MB to 500MB should be enough to meet your hosting requirement in general. However if you wish to host a website with massive amount of graphic pictures, video files, mp3 then you should think about a web hosting plan that provide huge disk space, for example, 500 MB to 1,000 MB.
Likewise, the bandwidth requirement will depend on your site traffic judgment and evaluation too. Obviously, a website that anticipates attracting high traffic will consume the monthly bandwidth greater. In such case you will need to find a website hosting service that offer huge bandwidth with 50 GB to 100 GB per month. Depending upon your website requirement, choosing a website hosting service that provide sufficient amount of disk space and bandwidth is key consideration to avoid any future problem and put off yourself paying extra costs while you overuse it in future.
Topics: Hosting Tutorials | 1 Comment »