Graphic tutorial for installing MySQL5.6 in Linux environment

How to install mysql under Linux: first set up the Linux environment; then install the dependency package and cmake compilation tool; then upload the MySQL source code package, decompress, compile and install; finally grant permissions to the MySQL user.

Recommended related mysql video tutorials: "mysql introductory video tutorial"

1. First set up In the Linux environment, I am using redhat enterprise 6.5, and it is recommended that the disk be divided into logical volumes to facilitate later expansion.

2. After the environment is set up, we have to prepare the MySQL installation file. Until now, mysql is still free and open source and can be downloaded directly from the official website. You can visit the official website to download by yourself,

##The URL is: https://www .mysql.com/downloads/. Of course, before downloading, you need to register an Oracle account first, and then select the community free version to download.

3. Install dependency packages and cmake compilation tool

yum install -y cmake ncurses-devel

4. Compile and install MySQL

Upload the MySQL source package, decompress it, compile and install

Create User

useradd -s /usr/sbin/nologin mysql

Create database storage directory

mkdir /data

Unzip

tar -zxf mysql-5.6.36.tar.gz

cd ./mysql-5.6.36

Compile

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS=all
-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 -DMYSQL_USER=mysql

Parameter description:

-DCMAKE_INSTALL_PREFIX 数据文件存放目录
-DMYSQL_UNIX_ADDR  sock文件路径
-DDEFAULT_CHARSET  默认字符集
-DDEFAULT_COLLATION 默认字符校对
-DWITH_EXTRA_CHARSETS 扩展字符支持 默认all
-DWITH_storage_STORAGE_ENGINE 存储引擎的支持,默认支持MyISAM,MERGE,MEMORY,CVS存储引擎
-DENABLED_LOCAL_INFILE=1 启用加载本地数据
-DMYSQL_DATADIR  数据存放目录
-DMYSQL_USER    mysql运行用户

Installation:

make && make install

Grant permissions to the MySQL user

chown -R mysql:mysql /usr/local/mysql/

chown -R mysql:mysql /data

Create configuration file:

cp support-files/my-default.cnf /etc/my.cnf

Set environment variables:

echo'export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile
source!$

Create MySQL service startup script

cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld

Modify the MySQL installation directory and data directory in the startup script

vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/data

Add boot startup

chkconfig mysqld on

Initialize the database

/usr/local/mysql/scripts/mysql_install_db--defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data--user=mysql

Initialize the security configuration

mysql_secure_installation

Set the root password, and generally select yes for other options

5. At this step, the database has been installed and you can Execute script to start and stop database

service mysqld restart

The above is the detailed content of Graphic tutorial for installing MySQL5.6 in Linux environment. For more information, please follow other related articles on the PHP Chinese website!