Tutorial for Centos7 to install Mysql5.7.19 under Linux (picture)-Mysql Tutorial-php.cn

Tutorial for Centos7 to install Mysql5.7.19 under Linux (picture)

黄舟

Release： 2017-09-02 13:37:56

Original

1814 people have browsed it

This article mainly introduces the detailed tutorial of installing Mysql5.7.19 on Centos7 under Linux. Friends in need can refer to it

1. Download mysql

2. Select the source code package and click to download the general version

You can download it directly without logging in

3. Unzip and compile

tar -zxvf mysql-5.7.19.tar.gz
cd mysql-5.7.19.tar.gz

Copy after login

Create data directory

mkdir -p / data/mysql

Compile with cmake first. If you don’t have this command, you need to install yum first

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/  #这个是编译安装之后的mysql目录所在地，可自行更改
-DMYSQL_DATADIR=/data/mysql/    #这个指向数据目录
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock
-DSYSCONFDIR=/usr/local/mysql-5.7/conf/
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DMYSQL_TCP_PORT=3306
-DENABLED_LOCAL_INFILE=1
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DMYSQL_USER=mysql
-DWITH_SSL=system
-DWITH_ZLIB=system -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost #从MySQL 5.7.5开始Boost库是必需安装的

Copy after login

After compilation

make && make install A long wait....The installation will be completed after that

After the installation is completed, there will be a directory mysql under the path /usr/local/. This directory is the path where I compiled and installed the settings-

DCMAKE_INSTALL_PREFIX=/usr/local/mysql/

Copy after login

Generally for security reasons, we will create a mysql user and mysql group and execute the following commands

#添加用户组
groupadd mysql
#添加用户mysql 到用户组mysql
useradd
-g mysql mysql

Copy after login

Give mysql permissions

chown -R mysql:mysql mysql
#添加用户组
groupadd mysql
#添加用户mysql 到用户组mysql
useradd -g mysql mysql

Copy after login

Give mysql permission

chown -R mysql:mysql mysql

Copy after login

4. Next configure the startup direction and set the boot startup

Configuration

/ect/my.cnf, if there is no my.cnf, you can create and add it yourself, for reference only

[client]
ort = 3306
ocket = /tmp/mysql.sock
default-character-set = utf8mb4
[mysqld]
ort = 3306
ocket = /tmp/mysql.sock
asedir = /usr/local/mysql
datadir = /data/mysql
id-file = /data/mysql/mysql.pid
user = mysql
ind-address = 0.0.0.0
erver-id = 1
init-connect = &#39;SET NAMES utf8mb4&#39;
character-set-server = utf8mb4
#skip-name-resolve
#skip-networking
ack_log = 300
max_connections = 1000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
inlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
ort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
ft_min_word_len = 4
log_bin = mysql-bi
inlog_format = mixed
expire_logs_days = 30
log_error = /data/mysql/mysql-error.log
low_query_log = 1
long_query_time = 1
low_query_log_file = /data/mysql/mysql-slow.log
erformance_schema = 0
explicit_defaults_for_timestam
#lower_case_table_names = 1
kip-external-locking
default_storage_engine = InnoDB
#default-storage-engine = MyISAM
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
ulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
interactive_timeout = 28800
wait_timeout = 28800
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 8M
ort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

Copy after login

Next, execute the initialization database statement:

Note

mysql_install_db is no longer recommended. It is recommended to change to mysqld –initialize to complete the instance initialization.

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

Copy after login

This step is very important. If you start the database directly without initialization, an error will be reported

ERROR! The server quit without updating PID file (/data/mysql/ mysql.pid).

If the initialization fails or the following error is reported, you need to clear your /data/mysql directory first. Because there is data under the mysql directory, the initialization execution is aborted.

2017-08-29T13:39:47.241469Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.2017-08-29T13:39:47.241536Z 0 [ERROR] Aborting

Clear and then re-initialize

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

Copy after login

Now you can start mysql

ervice mysqld start

Copy after login

/usr/local/mysql/bin/mysql -uroot -

Copy after login

Because initialization

--initialize-insecure does not have a password by default, so you can directly confirm the password without entering it;

If an error is reported when logging in

ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/tmp/mysql.sock&#39; (2)

Copy after login

Check whether you have successfully started the database or not.

ps -ef | grep mysql Check whether the process is started

An empty password is not safe, so we still need to set a password. \"root\" in the following command is to set the password area. My password is set to root, which can be modified by yourself

[root@localhost local]# /usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@&#39;127.0.0.1&#39; identified by \"root\" with grant option;"[root@localhost local]# /usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@&#39;localhost&#39; identified by \"root\" with grant option;"

Copy after login

Next, log in again and test if the password change is successful, it’s done!

Summarize

The above is the detailed content of Tutorial for Centos7 to install Mysql5.7.19 under Linux (picture). For more information, please follow other related articles on the PHP Chinese website!