centos7安装mysql-5.6.43二进制包

[root@localhost ~]# find / -name mysql
/usr/lib64/mysql
/usr/share/mysql
[root@localhost ~]# rm -rf /usr/lib64/mysql /usr/share/mysql
[root@localhost ~]#

[root@localhost ~]# ls
anaconda-ks.cfg mysql-5.6.-linux-glibc2.-x86_64.tar.gz
[root@localhost ~]# tar -zxf mysql-5.6.-linux-glibc2.-x86_64.tar.gz
[root@localhost ~]# ls
anaconda-ks.cfg mysql-5.6.-linux-glibc2.-x86_64.tar.gz
mysql-5.6.-linux-glibc2.-x86_64

[root@localhost ~]# mv mysql-5.6.-linux-glibc2.-x86_64 /usr/mysql-5.6.
[root@localhost ~]#
[root@localhost ~]# ls
anaconda-ks.cfg mysql-5.6.-linux-glibc2.-x86_64.tar.gz
[root@localhost ~]#
[root@localhost ~]# ls /usr/
bin etc games include lib lib64 libexec local mysql-5.6. sbin share src tmp

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd mysql -g mysql
[root@localhost ~]# groups mysql
mysql : mysql

[root@localhost ~]# cd /usr/mysql-5.6./
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]# ls
bin COPYING data docs include lib man mysql-test README scripts share sql-bench support-files
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]# pwd
/usr/mysql-5.6.
[root@localhost mysql-5.6.]# chown -R mysql:mysql /usr/mysql-5.6.
[root@localhost mysql-5.6.]# ll
total
drwxr-xr-x. mysql mysql May : bin
-rw-r--r--. mysql mysql Dec : COPYING
drwxr-xr-x. mysql mysql May : data
drwxr-xr-x. mysql mysql May : docs
drwxr-xr-x. mysql mysql May : include
drwxr-xr-x. mysql mysql May : lib
drwxr-xr-x. mysql mysql May : man
drwxr-xr-x. mysql mysql May : mysql-test
-rw-r--r--. mysql mysql Dec : README
drwxr-xr-x. mysql mysql May : scripts
drwxr-xr-x. mysql mysql May : share
drwxr-xr-x. mysql mysql May : sql-bench
drwxr-xr-x. mysql mysql May : support-files

Installed:
perl-devel.x86_64 :5.16.-.el7_6Dependency Installed:
gdbm-devel.x86_64 :1.10-.el7 libdb-devel.x86_64 :5.3.-.el7 perl-ExtUtils-Install.noarch :1.58-.el7_6 perl-ExtUtils-MakeMaker.noarch :6.68-.el7
perl-ExtUtils-Manifest.noarch :1.61-.el7 perl-ExtUtils-ParseXS.noarch :3.18-.el7 pyparsing.noarch :1.5.-.el7 systemtap-sdt-devel.x86_64 :3.3-.el7Updated:
perl.x86_64 :5.16.-.el7_6Dependency Updated:
libdb.x86_64 :5.3.-.el7 libdb-utils.x86_64 :5.3.-.el7 perl-libs.x86_64 :5.16.-.el7_6Complete!

[root@localhost ~]# cd /usr/mysql-5.6./
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]# ls
bin COPYING data docs include lib man mysql-test README scripts share sql-bench support-files
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]#
[root@localhost mysql-5.6.]# cd scripts/
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ls
mysql_install_db
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ll
total
-rwxr-xr-x. mysql mysql Dec : mysql_install_db
[root@localhost scripts]#
[root@localhost scripts]#
[root@localhost scripts]# ./mysql_install_db --basedir=/usr/mysql-5.6./ --datadir=/usr/mysql-5.6./data/ --user=mysql
Installing MySQL system tables...-- :: [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
-- :: [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
-- :: [Note] /usr/mysql-5.6.//bin/mysqld (mysqld 5.6.43) starting as process 7286 ...
-- :: [Note] InnoDB: Using atomics to ref count buffer pool pages
-- :: [Note] InnoDB: The InnoDB memory heap is disabled
-- :: [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
-- :: [Note] InnoDB: Memory barrier is not used
-- :: [Note] InnoDB: Compressed tables use zlib 1.2.
-- :: [Note] InnoDB: Using Linux native AIO
-- :: [Note] InnoDB: Using CPU crc32 instructions
-- :: [Note] InnoDB: Initializing buffer pool, size = 128.0M
-- :: [Note] InnoDB: Completed initialization of buffer pool
-- :: [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
-- :: [Note] InnoDB: Setting file ./ibdata1 size to MB
-- :: [Note] InnoDB: Database physically writes the file full: wait...
-- :: [Note] InnoDB: Setting log file ./ib_logfile101 size to MB
-- :: [Note] InnoDB: Setting log file ./ib_logfile1 size to MB
-- :: [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
-- :: [Warning] InnoDB: New log files created, LSN=
-- :: [Note] InnoDB: Doublewrite buffer not found: creating new
-- :: [Note] InnoDB: Doublewrite buffer created
-- :: [Note] InnoDB: rollback segment(s) are active.
-- :: [Warning] InnoDB: Creating foreign key constraint system tables.
-- :: [Note] InnoDB: Foreign key constraint system tables created
-- :: [Note] InnoDB: Creating tablespace and datafile system tables.
-- :: [Note] InnoDB: Tablespace and datafile system tables created.
-- :: [Note] InnoDB: Waiting for purge to start
-- :: [Note] InnoDB: 5.6. started; log sequence number
-- :: [Note] Binlog end
-- :: [Note] InnoDB: FTS optimize thread exiting.
-- :: [Note] InnoDB: Starting shutdown...
-- :: [Note] InnoDB: Shutdown completed; log sequence number
OKFilling help tables...-- :: [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
-- :: [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
-- :: [Note] /usr/mysql-5.6.//bin/mysqld (mysqld 5.6.43) starting as process 7327 ...
-- :: [Note] InnoDB: Using atomics to ref count buffer pool pages
-- :: [Note] InnoDB: The InnoDB memory heap is disabled
-- :: [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
-- :: [Note] InnoDB: Memory barrier is not used
-- :: [Note] InnoDB: Compressed tables use zlib 1.2.
-- :: [Note] InnoDB: Using Linux native AIO
-- :: [Note] InnoDB: Using CPU crc32 instructions
-- :: [Note] InnoDB: Initializing buffer pool, size = 128.0M
-- :: [Note] InnoDB: Completed initialization of buffer pool
-- :: [Note] InnoDB: Highest supported file format is Barracuda.
-- :: [Note] InnoDB: rollback segment(s) are active.
-- :: [Note] InnoDB: Waiting for purge to start
-- :: [Note] InnoDB: 5.6. started; log sequence number
-- :: [Note] Binlog end
-- :: [Note] InnoDB: FTS optimize thread exiting.
-- :: [Note] InnoDB: Starting shutdown...
-- :: [Note] InnoDB: Shutdown completed; log sequence number
OKTo start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands: /usr/mysql-5.6.//bin/mysqladmin -u root password 'new-password'
/usr/mysql-5.6.//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'Alternatively you can run: /usr/mysql-5.6.//bin/mysql_secure_installationwhich will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.See the manual for more instructions.You can start the MySQL daemon with: cd . ; /usr/mysql-5.6.//bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.plPlease report any problems at http://bugs.mysql.com/The latest information about MySQL is available on the web at http://www.mysql.comSupport MySQL by buying support/licenses at http://shop.mysql.comNew default config file was created as /usr/mysql-5.6.//my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settingsWARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

[root@localhost scripts]# cd ../support-files/
[root@localhost support-files]#
[root@localhost support-files]# ls
binary-configure magic my-default.cnf mysqld_multi.server mysql-log-rotate mysql.server
[root@localhost support-files]#
[root@localhost support-files]# cp my-default.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? yes
[root@localhost support-files]#

[root@localhost support-files]# pwd
/usr/mysql-5.6./support-files
[root@localhost support-files]# ls
binary-configure magic my-default.cnf mysqld_multi.server mysql-log-rotate mysql.server
[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld
[root@localhost support-files]#

[root@localhost support-files]# cd /etc/init.d/
[root@localhost init.d]#
[root@localhost init.d]# ls
functions mysqld netconsole network README
[root@localhost init.d]#
[root@localhost init.d]# chmod -R mysqld
[root@localhost init.d]#
[root@localhost init.d]# ll
total
-rw-r--r--. root root Sep functions
-rwxr-xr-x. root root May : mysqld
-rwxr-xr-x. root root Sep netconsole
-rwxr-xr-x. root root Sep network
-rw-r--r--. root root Nov README

#mysql
export MYSQL_HOME=/usr/mysql-5.6.
#PATH
export PATH=$MYSQL_HOME/bin:$PATH

[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/usr/mysql-5.6.43/data/localhost.localdomain.err'.
................... SUCCESS!

[root@localhost data]# cd /usr/mysql-5.6./data/
[root@localhost data]#
[root@localhost data]#
[root@localhost data]# ls
auto.cnf ibdata1 ib_logfile0 ib_logfile1 localhost.localdomain.err localhost.localdomain.pid mysql performance_schema test
[root@localhost data]#
[root@localhost data]# cat localhost.localdomain.err
2019-05-24 20:37:02 7566 [Note] Plugin 'FEDERATED' is disabled.
-- :: [Note] InnoDB: Using atomics to ref count buffer pool pages
-- :: [Note] InnoDB: The InnoDB memory heap is disabled
-- :: [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
-- :: [Note] InnoDB: Memory barrier is not used
-- :: [Note] InnoDB: Compressed tables use zlib 1.2.
-- :: [Note] InnoDB: Using Linux native AIO
-- :: [Note] InnoDB: Using CPU crc32 instructions
-- :: [Note] InnoDB: Initializing buffer pool, size = 128.0M
-- :: [Note] InnoDB: Completed initialization of buffer pool
-- :: [Note] InnoDB: Highest supported file format is Barracuda.
-- :: [Note] InnoDB: rollback segment(s) are active.
-- :: [Note] InnoDB: Waiting for purge to start
-- :: [Note] InnoDB: 5.6. started; log sequence number
-- :: [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: a27e1f65-7e20-11e9--000c294cff47.
-- :: [Note] Server hostname (bind-address): '*'; port:
-- :: [Note] IPv6 is available.
-- :: [Note] - '::' resolves to '::';
-- :: [Note] Server socket created on IP: '::'.
-- :: [Note] Event Scheduler: Loaded events
-- :: [Note] /usr/mysql-5.6./bin/mysqld: ready for connections.
Version: '5.6.43' socket: '/tmp/mysql.sock' port: MySQL Community Server (GPL)

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.[mysqld]
federated
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at % of total RAM for dedicated server, else %.
# innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2Msql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[root@localhost ~]# /etc/init.d/mysqld stop
Shutting down MySQL.. SUCCESS!
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# /etc/init.d/mysqld start
Starting MySQL... SUCCESS!
[root@localhost ~]#
[root@localhost ~]# ps -aux | grep mysqld
root 0.0 0.0 pts/ S : : /bin/sh /usr/mysql-5.6./bin/mysqld_safe --datadir=/usr/mysql-5.6./data --pid-file=/usr/mysql-5.6./data/localhost.localdomain.pid
mysql 9.6 24.2 pts/ Sl : : /usr/mysql-5.6./bin/mysqld --basedir=/usr/mysql-5.6. --datadir=/usr/mysql-5.6./data --plugin-dir=/usr/mysql-5.6./lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/usr/mysql-5.6./data/localhost.localdomain.pid
root 0.0 0.0 pts/ S+ : : grep --color=auto mysqld

[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is
Server version: 5.6. MySQL Community Server (GPL)Copyright (c) , , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> select user,host,password from mysql.user;
+------+-----------------------+----------+
| user | host | password |
+------+-----------------------+----------+
| root | localhost | |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | :: | |
| | localhost | |
| | localhost.localdomain | |
+------+-----------------------+----------+
rows in set (0.00 sec)

mysql> update mysql.user set password=password('') where user='root' and host='localhost';
Query OK, row affected (0.04 sec)
Rows matched: Changed: Warnings: mysql> flush privileges;
Query OK, rows affected (0.00 sec)mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | :: | |
| | localhost | |
| | localhost.localdomain | |
+------+-----------------------+-------------------------------------------+
rows in set (0.00 sec)mysql> grant all privileges on *.* to root@'%' identified by '';
Query OK, rows affected (0.00 sec)mysql> flush privileges;
Query OK, rows affected (0.00 sec)mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | :: | |
| | localhost | |
| | localhost.localdomain | |
| root | % | *032197AE5731D4664921A6CCAC7CFCE6A0698693 |
+------+-----------------------+-------------------------------------------+
rows in set (0.00 sec)