Cloud server Centos7.3 installation mysql5.7.18 rpm installation steps-Mysql Tutorial-php.cn

Cloud server Centos7.3 installation mysql5.7.18 rpm installation steps

巴扎黑

Release： 2017-06-23 15:04:58

Original

1579 people have browsed it

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

Copy after login

2. Go to the official website of mysql to download the rpm set of the latest version of mysql 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 Unzip 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

Copy after login

4. Use the rpm -ivh command to install

[root@iZwz94qazh62gk5ewl4ei2Z mysql]# -community-common-.-.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key /:mysql-community-common-.-.e################################# [-community-libs-.-.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key /:mysql-community-libs-.-.el6################################# [-community-client-.-.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key /:mysql-community-client-.-.e################################# [-community-server-.-.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key /:mysql-community-server-.-.e################################# [

Copy after login

The above packages have dependencies and must be executed in order.

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

a Database directory
/var/lib/mysql/
b Configuration file
/usr/share /mysql(mysql.server command and configuration file)
c Related commands
/usr/bin(mysqladmin mysqldump and other commands)
d Startup script
/etc/rc.d/init.d/ (Directory of startup script file mysql)

e /etc/my.conf

5. Database initialization

In order to ensure that the database directory is logged in with the owner of the file being mysql 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

Copy after login

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.log2017-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=457902017-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

Copy after login

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

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

Copy after login

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

Start:

使用 service 启动：service mysqld start
使用 mysqld 脚本启动：/etc/inint.d/mysqld start
使用 safe_mysqld 启动：safe_mysqld&

Copy after login

Stop:

使用 service 启动：service mysqld stop
使用 mysqld 脚本启动：/etc/inint.d/mysqld stop
mysqladmin shutdown

Copy after login

Restart:

使用 service 启动：service mysqld restart
使用 mysqld 脚本启动：/etc/inint.d/mysqld restart

Copy after login

Connect to database

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

Copy after login

Password input: :Wu?2QQutQwj

Change password:

set password = password('你的密码');

Copy after login

Set up remote access

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

Copy after login

Set mysql to start at boot

加入到系统服务：
chkconfig --add mysqld
自动启动：
chkconfig mysqld on
查询列表：
chkconfig

说明：都没关闭（off）时是没有自动启动。

Copy after login

flush privileges;

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