MySQL 5.7.19 (tar.gz) installation graphic tutorial under Linux

The first tutorial for installing MySQL-5.7.19 version under Linux. If you already know how to install it, please see the next article to install multiple MySQL-5.7.19 under Linux

Environment: CentOS 6.5

1. Download

2. Skip login

3. Upload and unzip to the directory ../usr/local/mysql-5.7.19-3307

4. Add the system mysql group and mysql user:

Execute the command:

groupadd mysqlosf and useradd -r -g mysqlosf mysqlosf 

5. Authorize the current directory to group user mysqlosf

chown -R mysqlosf:mysqlosf . 

Execute the two commands in the red box and find that neither works. Observe the error reason, which means that the path cannot be found. The reason here is that the default selection is to install to usr/lcoal/mysql

Because we may install multiple databases in a system, one master and multiple slaves or multiple masters and multiple slaves. I also have a mysql here, so I will not use its default path and port 3306 when installing it. I choose the custom path usr/, then we find that there will be problems with the new version of mysql.

Then I checked the mysqld executable file, and unfortunately, I saw a mysql.server under support-files. There was a red box inside it that said it was very good, so we understand that it is the default configuration file, and the red box is the description:

If you installed mysql in some other path other than usr/local/mysql, then you have to do the following things Run this script in the directory where mysql is installed, create a /etc/my.cnf file with the following information

[mysqld] 
basedir=<path-to-mysql-installation-directory>

Add the above content to any other configuration file such as ~/.my.ini

And copy my_print_defaults to /usr/bin and add this path to the base path of the installation directory. If you want to affect other variables you should make some changes in etc/my.cnf or other configuration information.

If you change the base directory, you must also change the datadir directory, as these will be overwritten by the default configuration files set.

But by the same logic, I found a hateful thing. If you install this now, then do you install mysql in the same way? Do you install it in etc/my.cnf? You can find that what he wants to express here is that if you only need to install one mysql, then just follow the instructions above, but now we want to install multiple, then this is definitely not possible, but the configuration file must be

6. You need to create the my.cnf configuration file in the mysql-5.7.19-3307 directory as shown below:

7. Then start initializing mysql on port 3307:

Then the prompt information is as shown below:

2017-07-20T03:34:58.140832Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-07-20T03:35:00.213126Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-07-20T03:35:00.482183Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-07-20T03:35:00.554451Z 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: 68e5e3b4-6cfc-11e7-a9af-00163e30bbf6.
2017-07-20T03:35:00.557933Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-07-20T03:35:00.562343Z 1 [Note] A temporary password is generated for root@localhost:

hgPcBW?Xf86b (temporary database password for new version database to enhance security)
------------

8. Generate keys:

bin/mysql_ssl_rsa_setup --defaults-file=/usr/local/mysql-5.7.19-3307/my.cnf

Generating a 2048 bit RSA private key
........................................................................................+++
................................................................+++
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
............................+++
....+++
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
...........................................................................................+++
......................................................................................+++
writing new private key to 'client-key.pem'
-----

9. Make up for the previous directory. Haha, I didn't create it before and don't know what the impact is.

mkdir mysql-files
chmod 750 mysql-files
chown -R root . 
chown -R mysqlosf data mysql-files

10. Start MySQL background

bin/mysqld_safe --user=mysqlosf &

[1] 28106
[root@iZ2ze2jvzepskyobjmavtiZ mysql-5.7.19-3307]# 2017-07-20T04:01:40.623159Z mysqld_safe Logging to '/alidata/log/mysql/error.log'.
2017-07-20T04:01:40.679386Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.7.19-3307/data
2017-07-20T04:01:40.868828Z mysqld_safe mysqld from pid file /usr/local/mysql-5.7.19-3307/data/iZ2ze2jvzepskyobjmavtiZ.pid ended 

11. Next command is optional

shell> cp support-files/mysql.server /etc/init.d/mysql.server

12-Start logging into MySQL to perform related operations

bin/mysql -uroot -p

Enter the password: the one prompted when initializing the port

But it was rejected and I found that there was a problem with msyqld_safe when starting the above sql. . . . ended

That is to say, it did not start, check it out: (It didn't start, haha, so if you encounter a problem, continue to solve it)

There is no error when logging in with the root user, but it remains in this state without success

Check the status and it is started, but I found a problem. The two sockets are the same, but they are not the same port. It can also exist. Let's try again.

If it succeeds, it should be the mysqlosf that I just used that failed to assign permissions. . . Oh my god

13. After logging into MySQL, you are required to change the password immediately, otherwise you will not be able to perform any operations. Execute the following command to change the password of 'root'@'localhost' :

SET PASSWORD = PASSWORD('root');
 ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; 
flush privileges;

14. In order to log in remotely, add a 'root'@'%' account:

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option; 

15. Local test connection

According to the above method, continue to unzip and install mysql-5.7.19-linux-glibc2.5-x86_64.tar.gz, and configure it to port 3308,3309, then you can install multiple mysql.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.