Shulou(Shulou.com)06/01 Report--

1. Download Mysql

Download by yourself on the official website (binary package).

2. Decompression

Cd / opt

Mkdir mysql

Cd mysql

Tar zxvf / path/mysql-5.6.

Ln-s / opt/mysql/mysql-5. / usr/local/mysql

3. Create a user

Groupadd mysql useradd-g mysql-s / sbin/nologin-d / usr/local/mysql/-M mysql

4. Environmental variables

Echo $PATH

Echo PATH=$PATH:/usr/local/mysql/bin > > / etc/profile

Source / etc/profile

= start up =

5. Create the necessary directories

/ data/mysql/mysql3306/

Data

Tmp

Logs

Mkdir-p / data/mysql/mysql3306/ {data,tmp,logs}

6. Permissions

Chown-R mysql:mysql / data/mysql/mysql3306/

Chown-R mysql:mysql / opt/mysql

7. Create a configuration file

Socket = / tmp/mysql3306.sock

Innodb_data_file_path = ibdata1:100M:autoextend

8. Initialize

Cd / usr/local/mysql

. / scripts/mysql_install_db-- defaults-file=/etc/my.cnf

Saw ok twice.

9. Start

/ etc/init.d/mysql start or service mysql start

/ usr/local/mysql/bin/mysqld_safe-defaults-file=/etc/my.cnf &

/ usr/local/mysql/bi

N/mysqld-- defualts-file=/etc/my.cnf &

10. Safety reinforcement

Delete from mysql.user where username localhost'or hostworthy root.'

Truncate table mysql.db

Drop database test

A check whether the process exists

Ps aux | grep mysqld

B check whether the port is listening correctly

Netstat-nalp | grep mysqld

Ss-lnpt | grep mysqld

C check the error log for any anomalies

Vim shift+g

Tail

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.