Lamp environment to build Linux CentOS6.5 compile and install mysql5.6 specific details

This article mainly introduces the detailed explanation of Lamp environment constructionLinux CentOS6.5 compilationInstallation mysql5.6, has certain reference value. Interested friends can refer to it

Preparation before installation

Check centos through rpm command Whether mysql has been installed on the computer, and then uninstall the existing mysql version

[root@localhost src]# rpm -qa|grep mysql
mysql-libs-5.1.66-2.el6_3.i686
[root@localhost src]# rpm -e --nodeps mysql-libs-5.1.66-2.el6_3.i686

Install the dependency packages required for mysql compilation through yum

[root@localhost src]# yum install gcc gcc-c++ perl

Add the mysql user group and user, and the installation directory of mysql

[root@localhost src]# groupadd mysql
[root@localhost src]# useradd -g mysql -s /sbin/nologin -M mysql
[root@localhost src]# mkdir /usr/local/mysql
[root@localhost src]# id mysql
uid=501(mysql) gid=501(mysql) groups=501(mysql)

Authorize the installation directory of mysql

[root@localhost src]# chown -R mysql.mysql /usr/local/mysql
[root@localhost src]# ll /usr/local
drwxr-xr-x. 2 mysql mysql 4096 May 11 09:09 mysql

Start the installation

Enter after decompressing. Mysql5.6 is configured through cmake , you can directly use the default method cmake. You can directly enter the configuration, or you can specify the configuration yourself. Next, execute the configuration yourself and modify some regular mysql configuration hash # followed by comment

[root@localhost mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \  #指定安装目录
> -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \#指定mysql.sock地址
> -DDEFAULT_CHARSET=utf8 \#指定默认的字符集
> -DDEFAULT_COLLATION=utf8_general_ci \#指定默认的排序字符集
> -DWITH_INNOBASE_STORAGE_ENGINE=1 \#安装innodb存储引擎
> -DWITH_MYISAM_STORAGE_ENGINE=1 \安装myisam存储引擎
> -DWITH_ARCHIVE_STORAGE_ENGINE=1 \安装archive存储引擎
> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \安装blackhole存储引擎
> -DMYSQL_DATADIR=/usr/local/mysql/data \#mysql数据文件存放目录
> -DMYSQL_TCP_PORT=3306 \#端口
> -DENABLE_DOWNLOADS=1

After configuration, an error may occur

Prompt error: Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)

Here is a prompt that Curses cannot be found, install the library through yum

[root@localhost src]# yum -y install ncurses-devel

ThenDeleteRemove CMakeCache.txt and re-cmake

[root@localhost mysql-5.6.36]# rm -rf CMakeCache.txt

No error is reported after cmake, execute directly make&& make install

Installation data files

After the mysql installation is completed, you need to install files. You can see mysql_install_db in the scripts folder under the mysql installation directory. It is used to Install the mysql data file, specify the mysql user

[root@localhost mysql]# ls /usr/local/mysql/scripts/
mysql_install_db
[root@localhost mysql]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

Start mysql

[root@localhost mysql]# /usr/local/mysql/support-files/mysql.server start
Starting MySQL.. SUCCESS!

Log in to mysql

[root@localhost mysql]# /usr/local/mysql/bin/mysql -uroot

No password is required for the first login, you need to set the root login password through mysqladmin,

[root@localhost mysql]# /usr/local/mysql/bin/mysqladmin -uroot password '111111'

View mysqlConfiguration file

[root@localhost mysql]# /usr/local/mysql/bin/mysql --verbose --help |grep -A 1 'Default options'
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

You can see that the mysql configuration file is stored in multiple locations, and the order of reading is

/etc/my.cnf 、/etc/mysql/my.cnf 、/usr/local/mysql/etc/my.cnf 、~/.my.cnf

Then we copy the my-default.cnf configuration file in the support-files folder under the mysql installation directory to /etc/my.cnf

[root@localhost support-files]# cp my-default.cnf /etc/my.cnf

If there is direct overwriting, it is best here. Change the configuration of owner

EnvironmentVariable in /etc/my.cnf for ease of use

Put the mysql service startup under /etc/init.d/

[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld

Add the /usr/local/mysql/bin/ directory to the environment variable, vim edit vim /etc/profile to permanently add the environment variable, restart to take effect

export PATH=$PATH:/usr/local/mysql/bin

If you do not want to restart, also You can execute the script after editing vim /etc/profile

[root@localhost support-files]# export PATH=$PATH:/usr/local/mysql/bin

This method will become invalid after the terminal is closed

The above is the detailed content of Lamp environment to build Linux CentOS6.5 compile and install mysql5.6 specific details. For more information, please follow other related articles on the PHP Chinese website!