Graphic tutorial for installing MySQL5.6 in Linux environment-Linux Operation and Maintenance-php.cn

Graphic tutorial for installing MySQL5.6 in Linux environment

黄舟

Release： 2020-09-04 14:49:01

Original

50964 people have browsed it

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.

Graphic tutorial for installing MySQL5.6 in Linux environment

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

Copy after login

4. Compile and install MySQL

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

Create User

useradd -s /usr/sbin/nologin mysql

Copy after login

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

Copy after login

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运行用户

Copy after login

Installation:

make && make install

Grant permissions to the MySQL user

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

chown -R mysql:mysql /data

Copy after login

Create configuration file:

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

Copy after login

Set environment variables:

echo&#39;export PATH=/usr/local/mysql/bin:$PATH&#39; >>/etc/profile
source!$

Copy after login

Create MySQL service startup script

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

Copy after login

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

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

Copy after login

Add boot startup

chkconfig mysqld on

Copy after login

Initialize the database

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

Copy after login

Initialize the security configuration

mysql_secure_installation

Copy after login

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

Copy after login

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!