Tuesday, June 5, 2012

How to install and configure MySQL Database

Linux supports a number of different solutions for installing MySQL.
1. Install MySQL using RPM Package
2. Install MySQL using Native package manager
3. Install MySQL using Generic Binaries

If you are new to MySQL then i would recommend using RPM, otherwise install manually using Generic Binaries. The recommended way installing MySQL on PRM-based(RPM VsNative) Linux distribution is using RPM package.

Install MySQL using RPM PackageUse below command to see all files in an RPM package
$ rpm -qpl MySQL-server-VERSION.linux2.6.x86_64.rpm

Run the below command to install
$ rpm -i MySQL-server-VERSION.linux2.6.x86_64.rpm

The RPM installation creates a login account named mysql.

By default the RPM places the data under /var/lib/mysql directory and creates the appropriate entries in /etc/ini.d to start the server automatically at boot time.

MySQL Installation Layout for Linux RPM
/usr/bin - Client programs and scripts
/usr/sbin - The mysqld server
/var/lib/mysql - Log files, databases
/usr/share/info - Manual in Info format
/usr/share/man - Unix manual pages
/usr/include/mysql - Include (header) files
/usr/lib/mysql - Libraries
/usr/share/mysql - Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench – Benchmarks

Install My SQL using Native package managerThe native package installation will automatically take care of downloading and installing the software. Also it will take care of dependencies for MySQL Installation.

Use yum command to install MySQL.
# yum install mysql mysql-server mysql-libs mysql-server

An init script will be installed into /etc/init.d/mysqld, this script is used to stop and start the server. A configuration file will be created under /etc/mysql/my.cnf

Use below commands to Stop and Start MySQL service
# service mysql start
# service mysql stop

If you want to start MySQL server automatically during the boot run below command.
# chkconfig --levels 235 mysqld on

Here are some popular MySQL Download links

Download MySQL Community Serverhttp://dev.mysql.com/downloads/mysql/
Download MySQL Clusterhttp://dev.mysql.com/downloads/cluster/
Download MySQL Workbench GUI Toolhttp://dev.mysql.com/downloads/workbench/5.2.html
Download MySQL Proxyhttp://dev.mysql.com/downloads/mysql-proxy/
Download MySQL Connectorshttp://dev.mysql.com/downloads/connector/

Regards
Satishbabu Gunukulahttp://www.oracleracexpert.com/

9 comments:

  1. Search 1000s of job offers and find the best suitable position. Jobs near me from direct employers no agencies or jobs direct from top recruitment agencies & recruitment consultants. Send your job application to apply for a job with one click.

    if you want more just look here "skillsrecruitment"

    ReplyDelete
  2. Looking for a job? Browse thousands of direct job offers and find the best suitable position on Jobboss.co.uk. Job search for all jobs near me. Just apply for a job vacancy with one click.

    if you want more just look here "jobboss"

    ReplyDelete
  3. eVisa India (electronic India Visa, which has the same privileges as Indian Visa) is valid only on the following designated Airports and Seaports for entering India. In other words, not all airports and seaports allow entry into India on eVisa India. As a passenger the onus is on you to make sure that your itinerary allows use of this electronic India Visa. If you are entering India form a land border, for instance, then this electronic India Visa (eVisa India) is not suitable for your journey.

    if you want more just look here "india visa online"

    ReplyDelete
  4. Easily accessible by communication devices, both smartphones and computers. Access anywhere, anytime There are casino games to choose from, including fish shooting games, table games such as online slots, Pussy888, roulette or card games such as baccarat (baccarat) and many other games with special promotions, free credit. And so on

    if you want more just look here "pussy888"

    ReplyDelete
  5. We don't publish fake deals or offers that don't work. We only publish real, working coupon codes. We are honest and authentic and shoppers love us for it.

    if you want more just look here "function of beauty coupon"

    ReplyDelete
  6. Natural Crystal Pens, Manifestation Tools, Affirmation, and Law of Attraction driven products.

    if you want more just look here "crystals"

    ReplyDelete
  7. What are the best sugar daddy websites for sugar babies finding a sugar daddy? What are the best sugar daddy sites for helping to get a sugar daddy free of charge? If you have asked questions like these, then you have come to the right place. Because these are two of the questions that lots of sugar babies often ask when they are looking for sugar daddies, and we answer them both and more.

    sugarguide

    ReplyDelete
  8. The secret law of attraction dates back 5,000 years ago and it a natural law. It is not magic, but like magic and prays it is placing an intention to God or Universe to let them know what you want or need. It is a very powerful tool to change your life. You can bring yourself into perfect alignment with what you want or need. With the power of affirmations, visualization, and prays you to improve your life. Law of Attraction techniques

    ReplyDelete
  9. Thanks for sharing this with us. Keep up the good work. Also, check this out for AWS Architect Training

    ReplyDelete