Rapid deployment of MySQL5.6.35 database practices in 3 minutes

Rapid deployment of MySQL5.6.35 database practices in 3 minutes

1. Download software

Wget-q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

2. Unzip the mobile

Tar XF mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz mkdir-p/APPLICATIONMV mysql-5.6.35-linux-glibc2.5-x86_64/ application/mysql-5.6.35cd/application/mysql-5.6.35/

3. Initialize the database

CP support-files/my-default.cnf/etc/my.cnf./scripts/mysql_install_db--basedir=/application/mysql-5.6.35/-- datadir=/application/mysql-5.6.35/data/--user=mysqlsed-i ' s#/usr/local/mysql#/application/mysql-5.6.35#g '/ Application/mysql-5.6.35//bin/mysqld_safe

4. Start Login

/application/mysql-5.6.35//bin/mysqld_safe &lsof-i: 3306path= "/application/mysql-5.6.35/bin/: $PATH"

5. Login Test

[[email protected] mysql-5.6.35]# mysqlwelcome to the mysql monitor.   Commands end with ; or \g.Your MySQL connection id is  2server version: 5.6.35 mysql community server  (GPL) Copyright  (c)  2000 ,  2016, 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> select version (); +-----------+| version ()  |+-----------+|  5.6.35    |+-----------+1 row in set  (0.00 sec) mysql>  create database oldboy; query ok, 1 row affected  (0.00 sec) mysql> create database  Oldgirl; query ok, 1 row affected  (0.00 sec) mysql> show databases like   ' old% '; +-----------------+| database  (old%)  |+-----------------+| oldboy           | |  oldgirl         |+-----------------+2 rows in  set  (0.00 SEC)

6. Configure security Policy:

[Email protected] mysql-5.6.35]# mysql_secure_installation

This article is from the "Old Boys Linux Training" blog, make sure to keep this source http://oldboy.blog.51cto.com/2561410/1893734

Rapid deployment of MySQL5.6.35 database practices in 3 minutes