MySQL installation in Linux redhat6.5

Source: Internet
Author: User

MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently part of Oracle's product portfolio. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBMS (relational database Management system) application software for WEB applications.
MySQL is a relational database management system, where relational databases store data in different tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility.
The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software has adopted a dual licensing policy, divided into community and commercial version, due to its small size, fast, low total cost of ownership, especially the open source, the development of the general small and medium-sized web site to choose MySQL as the site database.
Let's start the installation now.
1: Get this installation package by sharing files
Unzip the installation package to the/OPT directory


2: Use Yum to install GCC, gcc-c++, make, CMake, Ncurses-devel, bison, libaio-devel these environments

3: Create a MySQL user to disable shell login
Create a MySQL directory in/usr/local/
Configure the installation to the directory/opt/mysql-5.5.24 directory

4: Compiling and compiling the installation

5: Set the owner of the/usr/local/mysql to MySQL
Edit the profile setting in the ETC directory to define the environment variable (function: can call the command in MySQL)
Execute source/etc/profile to make the configuration take effect immediately


6: Copy/opt/mysql-5.5.24/support-files directory my-medium.cnf save to/etc named My.cnf
Copy the My.server in the/opt/mysql-5.5.24/support-files directory to/etc/init.d named Mysqld
To set permissions for a/etc/init.d/mysql file
Add mysqld service and turn on 3 5 boot

Then initialize the database

7: Establish a soft connection
Edit the path in the Mysqld


8: Open mysqld Service
View 3306 of Ports

9: Edit MY.CNF
Edit path makes Mysql.sock soft connection effective


10: Restart Service View the Mysql.sock soft connection in the/home/mysql directory is in effect

11: Fight Show Database

MySQL installation in Linux redhat6.5

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.