How to use cmake to compile and install MySQL5.5.32 under CentOS6.7

cmake is a cross-platform open source meta-build system that can build, test and package software. It can be used to support a variety of local build environments, including make, Apple's Xcode and Microsoft's Visual Studio.

1. Install the cmake compilation environment

1.1 Use yum to install gcc gcc-c

[root@lenovo ~]# yum install gcc-c++ gcc -y

1.2 Unzip the camke source file and copy the cmake Place the source files into the /tmp/ folder

[root@lenovo ~]# cd /tmp[root@lenovo ~]# tar -xf cmake-2.8.8.tar.gz

1.3 Compile and install cmake

[root@lenovo ~]# cd cmake-2.8.8[root@lenovo ~]# ./configure[root@lenovo ~]# make[root@lenovo ~]# make install

The cmake compilation environment is successfully installed

2. Install MySQL5.5.32

2.1Install mysql dependency package

[root@lenovo ~]#yum install ncurses-devel -y

2.2Create mysql user and user group

[root@lenovo ~]# groupadd mysql[root@lenovo ~]# useradd -g mysql mysql

2.3Create mysql installation directory

[root@lenovo ~]# mkdir -p /usr/local/mysql/

2.4Create data storage directory

[root@lenovo ~]# mkdir -p /data/mysql/

2.5 Grant permissions to the data storage directory

[root@lenovo ~]# chown mysql.mysql -R /data/mysql/

2.6 Unzip the MySQL source code package and put the MySQL5.5.32 source file into the /tmp/ folder

[root@lenovo ~]# cd /tmp[root@lenovo ~]# tar -xf mysql-5.5.32.tar.gz

2.7 Compile and install mysql5.5.32

[root@lenovo ~]#cd mysql-5.5.32

Enter the following command

[root@lenovo ~]cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_DATADIR=/data/mysql \-DMYSQL_USER=mysql \-DMYSQL_TCP_PORT=3306[root@lenovo ~]# make[root@lenovo ~]# make install

2.8 Copy the configuration file

[root@lenovo ~]# cp support-files/my-medium.cnf /etc/my.cnf

2.9 Initialize the database

[root@lenovo ~]# chmod 755 scripts/mysql_install_db[root@lenovo ~]# scripts/mysql_install_db \--user=mysql \--basedir=/usr/local/mysql \--datadir=/data/mysql/

Note: basedir is the mysql installation path datadir is the database file storage path 2.10 configuration Environment variable

[root@lenovo ~]# vim /etc/profile

Append PATH=/usr/local/mysql/bin:$PATH to the /etc/profile file. Note: There cannot be spaces on both sides of "=". Note: If you use to modify the profile file To change PATH, you must log in again to take effect. The following method can simplify the work: If /etc/profile is modified, then after editing, execute source profile or execute point command: /etc/profile, the value of PATH will take effect immediately . The principle of this method is to execute the /etc/profile shell script again. Note that it will not work if you use sh /etc/profile, because sh is executed in a subshell process, and even if the PATH changes, it will not be reflected in the current environment. , but source is executed in the current shell process, so we can see changes in PATH.

[root@lenovo ~]# source /etc/profile

2.11 Check the current environment variables

[root@lenovo ~]# echo $PATH

Now you can find that there are more environment variables /usr/local/mysql/bin:

/usr/local/mysql/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

So far mysql has been compiled and installed successfully

3. Start the mysql database

3.1 Start the mysql service

[root@lenovo ~]# cp support-files/mysql.server /etc/init.d/mysqld[root@lenovo ~]# chmod 755 /etc/init.d/mysqld[root@lenovo ~]# /etc/init.d/mysqld start //

After the server-side switch is started, use the ps -ef |grep mysql command to check whether it is started

[root@lenovo ~]# ps -ef |grep mysql

3.2Set a password for the root user

[root@lenovo ~]# mysqladmin -u root password 'yourpassword'

3.3Enter mysql

[root@lenovo ~]# mysql -u root -p //

Enter the database

mysql>use mysql
mysql>select user,password,host from user;
mysql>update user set host = '192.168.%' where user = '127.0.0.1';
mysql>grant all privileges on *.* to root@'%' identified by "root";

Grant permission to allow remote login to connect to the database with root@ip. Common causes of remote connection failure. And set the password of the remote login user to root

mysql> flush privileges;
mysql>quit

The above is the detailed content of How to use cmake to compile and install MySQL5.5.32 under CentOS6.7. For more information, please follow other related articles on the PHP Chinese website!