Shulou(Shulou.com)05/31 Report--

This article mainly introduces the OEL7.6 source code installation MYSQL5.7 example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

First of all, download the installation package https://dev.mysql.com/downloads/mysql/5.7.html#downloads on the official website

Then upload and extract to the / usr/local directory

[root@localhost db] # tar-xf mysql-5.7.26-linux-glibc2.12-x86_64.tar [root@localhost db] # tar-xzf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz [root@localhost db] # mv mysql-5.7.26-linux-glibc2.12-x86_64 / usr/local/mysql [root@localhost db] #

Then create mysql users and groups and data directories

[root@localhost db] # mv mysql-5.7.26-linux-glibc2.12-x86_64 / usr/local/mysql [root@localhost db] # groupadd mysql [root@localhost db] # useradd mysql- g mysql [root@localhost db] # cd / usr/local/mysql [root@localhost mysql] # mkdir data [root@localhost mysql] # chown mysql:-R / usr/local/mysql/ [root@localhost mysql] #

Then initialize the data and record the temporary password

[root@localhost mysql] # bin/mysqld-initialize-user=mysql-datadir / usr/local/mysql/data2019-07-26T01:34:24.479757Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-- explicit_defaults_for_timestamp server option (see documentation for more details). 2019-07-26T01:34:24.682695Z 0 [Warning] InnoDB: New log files created, LSN=457902019-07-26T01:34:24.717419Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2019-07-26T01:34:24.723157Z 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: 8009a802-af45-11e9-839c-000c29984aae.2019-07-26T01:34:24.723996Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2019-07-26T01:34:24.724629Z 1 [Note] A temporary password is generated for root@localhost: ucZ5w5ZkSq;1 [root@localhost mysql] #

Then modify the datadir in the / etc/my.cnf configuration file to / usr/local/mysql/data

[root@localhost mysql] # cat / etc/ my.cnf [mysqld] datadir=/usr/local/mysql/ data [root @ localhost mysql] #

Then add mysql to the init.d directory and start mysql

[root@localhost mysql] # cp support-files/mysql.server / etc/init.d/mysqld [root@localhost mysql] # / etc/init.d/mysqld startStarting MySQL.Logging to'/ usr/local/mysql/data/localhost.localdomain.err'. SUCCESS! [root@localhost mysql] # ps-ef | grep mysqlroot 12957 10 09:37 pts/0 00:00:00 / bin/sh / usr/local/mysql/bin/mysqld_safe-- datadir=/usr/local/mysql/data-- pid-file=/usr/local/mysql/data/localhost.localdomain.pidmysql 13057 12957 4 09:37 pts/0 00:00:00 / usr/local/mysql/bin/mysqld-basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data-- plugin -dir=/usr/local/mysql/lib/plugin-user=mysql-log-error=localhost.localdomain.err-pid-file=/usr/local/mysql/data/localhost.localdomain.pidroot 13092 10198 0 09:37 pts/0 00:00:00 grep-color=auto mysql [root@localhost mysql] #

Finally, mysql/bin joins path, logs in to the database and resets the password

[root@localhost bin] #. / mysql-u root-pEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 2Server version: 5.7.26Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'C'to clear the current input statement.mysql > set password=password ('mysql'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql > exitBye [root@localhost bin] #. / mysql-u root-pEnter password: ERROR 1045 (28000): Access denied for user' root'@'localhost' (using password: YES) [root@localhost bin] #. / mysql-u root-pEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 4Server version: 5.7.26 MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > show databases +-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.01 sec) mysql > Thank you for reading this article carefully I hope the article "sample Analysis of OEL7.6 Source installation MYSQL5.7" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.