Tutorial on binary compilation and installation of MySql centos7 under Linux

# mkdir -p /mysql/data //The directory name is arbitrary (it must correspond when setting it later), but the remaining space of the partition where the directory is located cannot be less than 1g (not very clear)
# chown mysql.mysql /mysql/ -R // Set the owner and group of the directory to mysql

# yum install ncurses-devel openssl-devel gcc* -y

# cd /packet //cd to the directory where the package is stored# tar xvf mysql-5.6.22.tar.gz
# cd mysql-5.6.22
// Start compiling directly. Note: Be sure to enter the unzipped mysql package before editing. Then cmake takes a lot of parameters, some of which can be omitted #cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mysql/data -DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_SSL=bundled
// -DCMAKE_INSTALL_PREFIX=/usr/local/mysql //Specify the installation directory //-DMYSQL_DATADIR=/mysql/data //Specify the data directory, the one created above //Others are omitted. . .

 # rm -rf CMakeCache.txt 
//When a compilation error occurs, be sure to delete CMakeCache.txt and then recompile. This file will automatically generate a "ledger" to record some compilation information. . .

//The error list will be put aside for now and updated later. . .

# make -j 4 // -j 4 uses 4 cores to compile. Because the compilation takes a long time, give it a few more u
# make install

 # yum install -y perl-Data-Dumper //Will prompt to install this# /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/mysql/data/ --basedir=/usr/local/mysql
//After initialization, you can see the generated basic library and logs in the /mysql/data/ directory. // The client21.err (hostname.err) will record the logs when the mysql service is started, restarted, and shut down. If there is a problem with the startup, you can check the log # tail -50 /mysql/data/client21.err

# cp /usr/local/mysql/mysql-test/include/default_my.cnf /etc/my.cnf //This file is the configuration file for the mysql service# cat > /etc/my.cnf //Delete all the contents inside, otherwise there will be problems later. You can also add some options yourself# /usr/local/mysql/bin/mysqld_safe --user=mysql & //Start in the background. If you don't add '&', the current terminal will be useless. You can try it

 # vim /etc/profile.d/mysql.sh
   export PATH=/usr/local/mysql/bin:$PATH //Just add this line# source /etc/profile.d/mysql.sh

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# chkconfig --add mysqld //Add mysqld to the startup managed by chkconfig # chkconfig --list | grep mysqld //Check whether mysqld is started at each run level mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

# yum install -y mysql //This is the mariadb client, the experience will be better than my mysql, in fact, they are the same # mysql //Go directly and test if there is any problem