Centos7.3 installation mysql5.7.18 rpm tutorial

This article mainly introduces the installation tutorial of mysql5.7.18 rpm for Alibaba Cloud Centos7.3. Friends who need it can refer to it. I hope it can help everyone.

Uninstall MariaDB

CentOS7 installs MariaDB by default instead of MySQL, and MySQL-related software packages are also removed from the yum server. Because MariaDB and MySQL may conflict, uninstall MariaDB first.

1. Before installing the new version of mysql, we need to uninstall the mariadb-lib that comes with the system

[root@iZwz94qazh62gk5ewl4ei2Z home]# rpm -qa | grep -i mariadb
mariadb- libs-5.5.52-1.el7.x86_64
[root@iZwz94qazh62gk5ewl4ei2Z home]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64

2 , Go to the official website of mysql to download the latest version of mysql rpm collection package: mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar

3, upload mysql-5.7.18-1.el6. x86_64.rpm-bundle.tar to the linux server, and decompress the tar package

[root@iZwz94qazh62gk5ewl4ei2Z home]# mkdir mysql
[root@iZwz94qazh62gk5ewl4ei2Z home]# tar -xf mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar -C mysql
[root@iZwz94qazh62gk5ewl4ei2Z home]# cd mysql
[root@iZwz94qazh62gk5ewl4ei2Z mysql]# ll
total 459492
-rw-r--r-- 1 7155 31415 23618836 Mar 20 17:40 mysql-community-client-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415  335496 Mar 20 17:40 mysql-community-common-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415  3747352 Mar 20 17:40 mysql-community-devel-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415 39086508 Mar 20 17:40 mysql-community-embedded-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415 135869292 Mar 20 17:40 mysql-community-embedded-devel-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415  2177064 Mar 20 17:40 mysql-community-libs-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415  1723180 Mar 20 17:40 mysql-community-libs-compat-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415 159060212 Mar 20 17:41 mysql-community-server-5.7.18-1.el6.x86_64.rpm
-rw-r--r-- 1 7155 31415 104881084 Mar 20 17:41 mysql-community-test-5.7.18-1.el6.x86_64.rpm

4. Use the rpm -ivh command to install

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm
warning: mysql-community-common-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...             ################################# [100%]
Updating / installing...
  1:mysql-community-common-5.7.18-1.e################################# [100%]
[root@iZwz94qazh62gk5ewl4ei2Z mysql]# rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm
warning: mysql-community-libs-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...             ################################# [100%]
Updating / installing...
  1:mysql-community-libs-5.7.18-1.el6################################# [100%]
[root@iZwz94qazh62gk5ewl4ei2Z mysql]# rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm
warning: mysql-community-client-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...             ################################# [100%]
Updating / installing...
  1:mysql-community-client-5.7.18-1.e################################# [100%]
[root@iZwz94qazh62gk5ewl4ei2Z mysql]# rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm
warning: mysql-community-server-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...             ################################# [100%]
Updating / installing...
  1:mysql-community-server-5.7.18-1.e################################# [100%]
[root@iZwz94qazh62gk5ewl4ei2Z mysql]#

The above packages have dependencies, execute There is a sequence.

Use the rpm installation method to install mysql. The installation path is as follows:

a 数据库目录
/var/lib/mysql/
b 配置文件
/usr/share/mysql(mysql.server命令及配置文件)
c 相关命令
/usr/bin(mysqladmin mysqldump等命令)
d 启动脚本
/etc/rc.d/init.d/(启动脚本文件mysql的目录)
e /etc/my.conf

5. Database initialization

In order to ensure that the database directory is the owner of the file and the mysql login user, If your Linux system is running the mysql service as root, you need to execute the following command to initialize

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# mysqld --initialize --user=mysql

If you are logged in and run as mysql, you can remove the --user option.

In addition, the --initialize option defaults to initialization in "safe" mode, which will generate a password for the root user and mark the password as expired. After logging in, you need to set a new password,

When using the --initialize-insecure command, the safe mode is not used and a password will not be generated for the root user.

The --initialize initialization used in the demonstration here will generate a root account password. The password is in the log file. The red area is the automatically generated password.

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# cat /var/log/mysqld.log
2017-06-05T14:30:52.709474Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-06-05T14:30:55.590590Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-06-05T14:30:56.000269Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-06-05T14:30:56.109868Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 960c533e-49fb-11e7-91f2-00163e089fd2.
2017-06-05T14:30:56.116186Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-06-05T14:30:56.116777Z 1 [Note] A temporary password is generated for root@localhost: :Wu?2QQutQwj

Now start the mysql database systemctl start mysqld.service (Centos7 unique startup method)

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# systemctl start mysqld.service

You can use the following two commands to stop, start and restart mysql:

Start:

Use service to start: service mysqld start
Use the mysqld script to start: /etc/inint.d/mysqld start
Use safe_mysqld to start: safe_mysqld&

Stop:

Use service to start: service mysqld stop
Use the mysqld script to start: /etc/inint.d/mysqld stop
mysqladmin shutdown

Restart:

Use service to start: service mysqld restart
Start using the mysqld script:/etc/inint.d/mysqld restart

Connect to the database

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# mysql -u root -p
Enter password :

Password input: :Wu?2QQutQwj

Modify password:

set password = password('your password');
Set remote access

grant all privileges on *.* to 'root' @'%' identified by '123456'; 
flush privileges;

Set mysql to start at boot

Add to system service:

chkconfig --add mysql

Auto start:

chkconfig mysql on

Query list:

chkconfig

Note: There is no automatic startup when neither is turned off.

Related recommendations:

How to change the password in MySQL5.7.18

About MySQL5.7.18 master-slave replication setup Detailed explanation of one master and one slave example

Share the installation and configuration tutorial of mysql5.7.18 under centos6.4 (picture and text)

The above is the detailed content of Centos7.3 installation mysql5.7.18 rpm tutorial. For more information, please follow other related articles on the PHP Chinese website!