MySQL Database source code package compiled under the CentOS system

Source: Internet
Author: User
Tags mysql login

First step: Configure the network environment, download the CMake software package (mysql5.5 is compiled by CMake later)
wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz

Step Two: Press-unpack Package CMake
Tar-zxvf/data/cmake-2.8.5.tar.gz

Enter cmake-2.8.5

Step Three: Install the package gcc-c++

Yum-y Install gcc-c++

Fourth step: Execute the./configure to compile the CMake
./configure

Make && make install


Fifth step: Create the MySQL installation directory and the database storage directory
Mkdir-p/data/mysql//install MySQL

Mkdir-p/DATA/MYSQL/MYSQLDB//Storage database

Sixth step: Create MySQL users and user groups

Groupadd MySQL

Useradd-r-G MySQL MySQL

Seventh Step: Install MySQL
TAR-ZXVF mysql-5.6.24.tar.gz

cd/mysql-5.6.24

Eighth Step: Install the package Ncurses-devel

Yum-y Install Ncurses-devel

Nineth step: compiling MySQL files
CMake. \
-dcmake_install_prefix=/data/mysql \
-DMYSQL_DATADIR=/DATA/MYSQL/MYSQLDB \
-ddefault_charset=utf8 \
-DDEFAULT_COLLATION=UTF8_GENERAL_CI \
-dmysql_tcp_port=3306 \
-dextra_charsets=all \
-denable_downloads=1 \
-denabled_local_infile=1

Note: To rerun the configuration, you need to delete the CMakeCache.txt file
cd/data/cmake-2.8.5
Make clean
Rm-rf/etc/my.cnf
RM-RF CMakeCache.txt


Make && make install (This step takes 10 minutes)

Tenth step: Configure the MySQL service
[Email protected] ~]# chown-r mysql:mysql/data/mysql
[Email protected] ~]# chown-r mysql:mysql/data/mysql/mysqldb

11th Step: Copy support-files/my-default.cnf to/ETC/MY.CNF (note: Overwrite if/etc/my.cnf file exists)
CP SUPPORT-FILES/MY-DEFAULT.CNF/ETC/MY.CNF

12th step: Initializing MySQL Database
Cd/data/mysql
scripts/mysql_install_db--user=mysql--datadir=/data/mysql/mysqldb


13th step: Copy the MySQL service startup script and join the path path
Cd/data/mysql

CP Support-files/mysql.server/etc/init.d/mysqld

Vim/etc/profile

Path=/data/mysql/bin:/data/mysql/lib: $PATH
Export PATH

Source/etc/profile

14th Step: Modify the location of the MySQL database
Vim/etc/my.cnf
DataDir =/data/mysql/mysqldb

15th step: Start the MySQL server and join the boot

Service mysqld Start

Chkconfig--level mysqld on

16th Step: Check if the MySQL server is started

NETSTAT-TUNLP | grep 3306

17th step: Test MySQL Login
Mysql-u root-p
The password is empty and if it can be logged on, the installation is successful.

18th Step: Modify the MySQL user root password

mysqladmin-u password ' 123456 '


19th: If the following wrong solution occurs
Mysqladmin:connect to server at ' localhost ' failed
Error: ' Access denied for user ' root ' @ ' localhost ' (using Password:yes) '

Workaround:

#> Service mysqld Stop
#>mysqld_safe--skip-grant-tables &
Enter Mysql-uroot-p return Enter
>use MySQL;
> Update user Set Password=password ("NewPassword") where user= "root";
Change Password to NewPassword
> Flush Privileges; Update permissions
> Quit quitting

Operation has been completed, if there is a problem, please contact me in time!

This article is from the "Sky of Lavender" blog, be sure to keep this source http://youlei.blog.51cto.com/2669714/1652957

MySQL Database source code package compiled under the CentOS system

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.