Rapid deployment of MySQL Databases in Linux

Rapid deployment of MySQL Databases in Linux
1. Download the corresponding software version

: Http://mirrors.sohu.com/mysql/MySQL-5.6/

[root@localhost ~]# wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/sql-5.6.36-linux-glibc2.5-x86_64.tar.gz 

Ii. decompress and configure users and permissions

[root@localhost ~]# mkdir -pv  /Data/apps[root@localhost ~]# tar xf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz -C /Data/apps/[root@localhost ~]# cd /Data/apps/[root@localhost apps]# mv mysql-5.6.36-linux-glibc2.5-x86_64/ mysql-5.6.36[root@localhost ~]# useradd -s /sbin/nologin -M mysql[root@localhost ~]# chown -R mysql.mysql  /Data/apps/mysql-5.6.36[root@localhost ~]# cd /Data/apps/mysql-5.6.36

3. initialize the database

[Root @ localhost mysql-5.6.36] # cp support-files/my-default.cnf/etc/my. cnf [root @ localhost mysql-5.6.36] #. /scripts/mysql_install_db -- basedir =/Data/apps/mysql-5.6.36/-- datadir =/Data/apps/mysql-5.6.36/data/-- user = mysql [root @ localhost mysql-5.6.36] # cp support- files/mysql. server/etc/init. d/mysqld [root @ localhost mysql-5.6.36] # chmod + x/etc/init. d/mysqld [root @ localhost mysql-5.6.36] # sed-I's #/usr/local/mysql #/Data/apps/mysql-5.6.36 # G'/etc/init. d/mysqld # Main last do not '/' [root @ localhost mysql-5.6.36] # service mysqld startStarting MySQL. logging to '/Data/apps/mysql-5.6.36/data/localhost. localdomain. err '... [OK] [root @ localhost mysql-5.6.36] # netstat-tnlpActive Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0.0.0.0: 22 0.0.0.0: * LISTEN 947/sshd tcp 0: 22: * LISTEN 947/sshd tcp 0 0: 3306

4. Configure MySQL Environment Variables

[Root @ localhost mysql-5.6.36] # echo "export PATH =/Data/apps/mysql-5.6.36/bin: $ PATH">/etc/profile. d/mysql. sh
[Root @ localhost mysql-5.6.36] #./etc/profile. d/mysql. sh

V. Test Logon

root@localhost mysql-5.6.36]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.36 MySQL Community Server (GPL)Copyright (c) 2000, 2017, 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.36    |+-----------+1 row in set (0.05 sec)mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || test               |+--------------------+4 rows in set (0.15 sec)

6. Configure Security Policies (recommended)

[Root @ localhost mysql-5.6.36] # mysql_secure_installation NOTE: running all parts of this script is recommended for all MySQL servers in production use! Please read each step carefully! In order to log into MySQL to secure it, we'll need the currentpassword for the root user. if you 've just installed MySQL, andyou haven' t set the root password yet, the password will be blank, so you shoshould just press enter here. enter current password for root (enter for none) :....................................... ........................ omitted