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

First, visit the official website of oracle to download the following http://dev.mysql.com/downloads files: MySQL-server-5.6.20-1.el6.x86_64.rpm

MySQL-devel-5.6.20-1.el6.x86_64.rpm

MySQL-client-5.6.20-1.el6.x86_64.rpm then performs the installation using the root account in Linux:

[root@Hadoop mysql] # rpm-ivh MySQL-server-5.6.20-1.el6.x86_64.rpm

Preparing... # [100%]

File / usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64

File / usr/bin/my_print_defaults from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-5.1.66-2.el6_3.x86_64

Conflicts appears in file / usr/share/man/man1/my_print_defaults.1.gz from install of MySQL-server-5.6.20-1.el6.x86_64 conflicts with file from package mysql-5.1.66-2.el6_3.x86_64, and the solution is as follows: [root@Hadoop mysql] # yum-y remove mysql-libs-5.1.66*

Loaded plugins: refresh-packagekit, security

Setting up Remove Process

Resolving Dependencies

-> Running transaction check

-> Package mysql-libs.x86_64 0vl 5.1.66-2.el6_3 will be erased

-> Processing Dependency: libmysqlclient.so.16 () (64bit) for package: mysql-devel-5.1.66-2.el6_3.x86_64

-> Processing Dependency: libmysqlclient.so.16 () (64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64

-> Processing Dependency: libmysqlclient.so.16 () (64bit) for package: mysql-5.1.66-2.el6_3.x86_64

-> Processing Dependency: libmysqlclient.so.16 (libmysqlclient_16) (64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64

-> Processing Dependency: libmysqlclient.so.16 (libmysqlclient_16) (64bit) for package: mysql-5.1.66-2.el6_3.x86_64

-> Processing Dependency: libmysqlclient_r.so.16 () (64bit) for package: mysql-devel-5.1.66-2.el6_3.x86_64

-> Processing Dependency: libmysqlclient_r.so.16 () (64bit) for package: mysql-5.1.66-2.el6_3.x86_64

-> Processing Dependency: libmysqlclient_r.so.16 (libmysqlclient_16) (64bit) for package: mysql-5.1.66-2.el6_3.x86_64

-- > Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-2.2.el6_1.x86_64

-- > Processing Dependency: mysql-libs = 5.1.66-2.el6_3 for package: mysql-5.1.66-2.el6_3.x86_64

-> Running transaction check

-> Package mysql.x86_64 0vl 5.1.66-2.el6_3 will be erased

-> Package mysql-devel.x86_64 0vl 5.1.66-2.el6_3 will be erased

-> Package postfix.x86_64 2 2.6.6-2.2.el6_1 will be erased

Processing Dependency: / usr/sbin/sendmail for package: cronie-1.4.4-7.el6.x86_64

Processing Dependency: / usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.0.1.el6.x86_64

-> Running transaction check

-> Package cronie.x86_64 0RU 1.4.4-7.el6 will be erased

-- > Processing Dependency: cronie = 1.4.4-7.el6 for package: cronie-anacron-1.4.4-7.el6.x86_64

-> Package redhat-lsb-core.x86_64 0RO 4.0-7.0.1.el6 will be erased

-- > Processing Dependency: redhat-lsb-core (x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.0.1.el6.x86_64

-- > Processing Dependency: redhat-lsb-core (x86-64) = 4.0-7.0.1.el6 for package: redhat-lsb-4.0-7.0.1.el6.x86_64

-- > Processing Dependency: redhat-lsb-core (x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.0.1.el6.x86_64

-> Running transaction check

-> Package cronie-anacron.x86_64 0RU 1.4.4-7.el6 will be erased

-> Package redhat-lsb.x86_64 0RO 4.0-7.0.1.el6 will be erased

-- > Processing Dependency: redhat-lsb (x86-64) = 4.0-7.0.1.el6 for package: redhat-lsb-compat-4.0-7.0.1.el6.x86_64

-> Package redhat-lsb-graphics.x86_64 0RO 4.0-7.0.1.el6 will be erased

-> Package redhat-lsb-printing.x86_64 0RO 4.0-7.0.1.el6 will be erased

-> Running transaction check

-> Package redhat-lsb-compat.x86_64 0RO 4.0-7.0.1.el6 will be erased

Processing Dependency: / etc/cron.d for package: crontabs-1.10-33.el6.noarch

Processing Dependency: / etc/cron.d for package: sysstat-9.0.4-20.el6.x86_64

-> Restarting Dependency Resolution with new changes.

-> Running transaction check

-> Package crontabs.noarch 0RU 1.10-33.el6 will be erased

-> Package sysstat.x86_64 0RU 9.0.4-20.el6 will be erased

-> Finished Dependency Resolution

Dependencies Resolved

=

Package Arch Version Repository Size

=

Removing:

Mysql-libs x86 million 64 5.1.66-2.el6_3 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 4.0m

Removing for dependencies:

Cronie x8634 1.4.4-7.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 166k

Cronie-anacron x8634 1.4.4-7.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 43k

Crontabs noarch 1.10-33.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 2.4k

Mysql x8631 64 5.1.66-2.el6_3 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 2.4m

Mysql-devel x8631 64 5.1.66-2.el6_3 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 387k

Postfix x86x 64 2anaconda-OracleLinuxServer-201302251503.x86_64/6.4 2.6.6-2.2.el6_1 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 9.7m

Redhat-lsb x86 percent 64 4.0-7.0.1.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 0.0

Redhat-lsb-compat x86 percent 64 4.0-7.0.1.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 0.0

Redhat-lsb-core x86 hours 64 4.0-7.0.1.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 22k

Redhat-lsb-graphics x86 percent 64 4.0-7.0.1.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 0.0

Redhat-lsb-printing x86 percent 64 4.0-7.0.1.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 0.0

Sysstat x8631 64 9.0.4-20.el6 @ anaconda-OracleLinuxServer-201302251503.x86_64/6.4 807k

Transaction Summary

=

Remove 13 Package (s)

Installed size: 17 M

Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Erasing: redhat-lsb-compat-4.0-7.0.1.el6.x86_64 1 Compact 13

Erasing: redhat-lsb-4.0-7.0.1.el6.x86_64 2 Compact 13

Erasing: mysql-devel-5.1.66-2.el6_3.x86_64 3Comp13

Erasing: redhat-lsb-graphics-4.0-7.0.1.el6.x86_64 4Universe 13

Erasing: redhat-lsb-printing-4.0-7.0.1.el6.x86_64 5Universe 13

Erasing: redhat-lsb-core-4.0-7.0.1.el6.x86_64 6Compact 13

Erasing: mysql-5.1.66-2.el6_3.x86_64 7 Compact 13

/ var/tmp/rpm-tmp.aSJ8EY: line 1: lsb_release: command not found

Erasing: sysstat-9.0.4-20.el6.x86_64 8Compact 13

Erasing: crontabs-1.10-33.el6.noarch 9 Compact 13

Erasing: cronie-anacron-1.4.4-7.el6.x86_64 10 Compact 13

Erasing: cronie-1.4.4-7.el6.x86_64 11 Compact 13

Erasing: 2:postfix-2.6.6-2.2.el6_1.x86_64 12 Universe 13

Erasing: mysql-libs-5.1.66-2.el6_3.x86_64 13 Compact 13

Verifying: mysql-devel-5.1.66-2.el6_3.x86_64 1 Compact 13

Verifying: redhat-lsb-printing-4.0-7.0.1.el6.x86_64 2 Compact 13

Verifying: 2:postfix-2.6.6-2.2.el6_1.x86_64 3Comp13

Verifying: redhat-lsb-4.0-7.0.1.el6.x86_64 4Universe 13

Verifying: redhat-lsb-core-4.0-7.0.1.el6.x86_64 5Universe 13

Verifying: mysql-5.1.66-2.el6_3.x86_64 6Compact 13

Verifying: cronie-anacron-1.4.4-7.el6.x86_64 7 Compact 13

Verifying: redhat-lsb-compat-4.0-7.0.1.el6.x86_64 8Compact 13

Verifying: crontabs-1.10-33.el6.noarch 9 Compact 13

Verifying: sysstat-9.0.4-20.el6.x86_64 10 Compact 13

Verifying: mysql-libs-5.1.66-2.el6_3.x86_64 11 Compact 13

Verifying: cronie-1.4.4-7.el6.x86_64 12 Universe 13

Verifying: redhat-lsb-graphics-4.0-7.0.1.el6.x86_64 13 Compact 13

Removed:

Mysql-libs.x86_64 0RO 5.1.66-2.el6_3

Dependency Removed:

Cronie.x86_64 0vl 1.4.4-7.el6 cronie-anacron.x86_64 0vl 1.4.4-7.el6 crontabs.noarch 0vl 1.10-33.el6

Mysql.x86_64 0VOR 5.1.66-2.el6_3 mysql-devel.x86_64 0RU 5.1.66-2.el6_3 postfix.x86_64 2RO 2.6.6-2.2.el6_1

Redhat-lsb.x86_64 0Rom 4.0-7.0.1.el6 redhat-lsb-compat.x86_64 0RU 4.0-7.0.1.el6 redhat-lsb-core.x86_64 0RU 4.0-7.0.1.el6

Redhat-lsb-graphics.x86_64 0Rom 4.0-7.0.1.el6 redhat-lsb-printing.x86_64 0RU 4.0-7.0.1.el6 sysstat.x86_64 0RU 9.0.4-20.el6

Complete! The virtual machine I use here is two network cards, one host-only and one NAT. After adding NAT, we can use yum to resolve conflicts.

Then continue to install [root@Hadoop mysql] # rpm-ivh MySQL-server-5.6.20-1.el6.x86_64.rpm

Preparing... # [100%]

1:MySQL-server # # [100%]

2016-05-30 11:07:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-explicit_defaults_for_timestamp server option (see documentation for more details).

2016-05-30 11:07:08 2893 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-05-30 11:07:08 2893 [Note] InnoDB: The InnoDB memory heap is disabled

2016-05-30 11:07:08 2893 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-05-30 11:07:08 2893 [Note] InnoDB: Memory barrier is not used

2016-05-30 11:07:08 2893 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-05-30 11:07:08 2893 [Note] InnoDB: Using Linux native AIO

2016-05-30 11:07:08 2893 [Note] InnoDB: Using CPU crc32 instructions

2016-05-30 11:07:08 2893 [Note] InnoDB: Initializing buffer pool, size = 128.0m

2016-05-30 11:07:08 2893 [Note] InnoDB: Completed initialization of buffer pool

2016-05-30 11:07:08 2893 [Note] InnoDB: The first specified data file. / ibdata1 did not exist: a new database to be created!

2016-05-30 11:07:08 2893 [Note] InnoDB: Setting file. / ibdata1 size to 12 MB

2016-05-30 11:07:08 2893 [Note] InnoDB: Database physically writes the file full: wait...

2016-05-30 11:07:08 2893 [Note] InnoDB: Setting logfile. / ib_logfile101 size to 48 MB

2016-05-30 11:07:10 2893 [Note] InnoDB: Setting logfile. / ib_logfile1 size to 48 MB

2016-05-30 11:07:11 2893 [Note] InnoDB: Renaming logfile. / ib_logfile101 to. / ib_logfile0

2016-05-30 11:07:11 2893 [Warning] InnoDB: New log files created, LSN=45781

2016-05-30 11:07:11 2893 [Note] InnoDB: Doublewrite buffer not found: creating new

2016-05-30 11:07:11 2893 [Note] InnoDB: Doublewrite buffer created

2016-05-30 11:07:11 2893 [Note] InnoDB: 128rollback segment (s) are active.

2016-05-30 11:07:11 2893 [Warning] InnoDB: Creating foreign key constraint system tables.

2016-05-30 11:07:11 2893 [Note] InnoDB: Foreign key constraint system tables created

2016-05-30 11:07:11 2893 [Note] InnoDB: Creating tablespace and datafile system tables.

2016-05-30 11:07:11 2893 [Note] InnoDB: Tablespace and datafile system tables created.

2016-05-30 11:07:11 2893 [Note] InnoDB: Waiting for purge to start

2016-05-30 11:07:11 2893 [Note] InnoDB: 5.6.20 started; log sequence number 0

A random root password has been set. You will find it in'/ root/.mysql_secret'.

2016-05-30 11:07:12 2893 [Note] Binlog end

2016-05-30 11:07:12 2893 [Note] InnoDB: FTS optimize thread exiting.

2016-05-30 11:07:12 2893 [Note] InnoDB: Starting shutdown...

2016-05-30 11:07:13 2893 [Note] InnoDB: Shutdown completed; log sequence number 1625977

2016-05-30 11:07:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-explicit_defaults_for_timestamp server option (see documentation for more details).

2016-05-30 11:07:13 2915 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-05-30 11:07:13 2915 [Note] InnoDB: The InnoDB memory heap is disabled

2016-05-30 11:07:13 2915 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-05-30 11:07:13 2915 [Note] InnoDB: Memory barrier is not used

2016-05-30 11:07:13 2915 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-05-30 11:07:13 2915 [Note] InnoDB: Using Linux native AIO

2016-05-30 11:07:13 2915 [Note] InnoDB: Using CPU crc32 instructions

2016-05-30 11:07:13 2915 [Note] InnoDB: Initializing buffer pool, size = 128.0m

2016-05-30 11:07:13 2915 [Note] InnoDB: Completed initialization of buffer pool

2016-05-30 11:07:13 2915 [Note] InnoDB: Highest supported file format is Barracuda.

2016-05-30 11:07:13 2915 [Note] InnoDB: 128rollback segment (s) are active.

2016-05-30 11:07:13 2915 [Note] InnoDB: Waiting for purge to start

2016-05-30 11:07:13 2915 [Note] InnoDB: 5.6.20 started; log sequence number 1625977

2016-05-30 11:07:14 2915 [Note] Binlog end

2016-05-30 11:07:14 2915 [Note] InnoDB: FTS optimize thread exiting.

2016-05-30 11:07:14 2915 [Note] InnoDB: Starting shutdown...

2016-05-30 11:07:15 2915 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER!

You will find that password in'/ root/.mysql_secret'.

You must change that password on your first connect

No other statement but 'SET PASSWORD' will be accepted.

See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

/ usr/bin/mysql_secure_installation

Which will also give you the option of removing the test database.

This is strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

Http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as / usr/my.cnf and

Will be used by default by the server when you start it.

You may edit this file to change server settings [root@Hadoop mysql] # rpm-ivh MySQL-client-5.6.20-1.el6.x86_64.rpm

Preparing... # [100%]

1:MySQL-client # [100%] [root@Hadoop mysql] # rpm-ivh MySQL-devel-5.6.20-1.el6.x86_64.rpm

Preparing... # [100%]

1:MySQL-devel # [100%] start mysql service [root@Hadoop mysql] # service mysql start after installation

Starting MySQL. SUCCESS! Check the random password of root [root@Hadoop ~] # cat / root/.mysql_secret

# The random password set for the root user at Mon May 30 11:07:12 2016 (local time): log in to mysql with wSerJnbKa2UxlRqR

[root@Hadoop bin] # mysql-u root-pwSerJnbKa2UxlRqR

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 5

Server version: 5.6.20

Copyright (c) 2000, 2014, 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 > change password

Mysql > UPDATE user SET Password=PASSWORD ('root') where USER='root'

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

Mysql > FLUSH PRIVILEGES

Query OK, 0 rows affected (0.00 sec) set remote login method 1:

Mysql > use mysql

Mysql > update user set host ='% 'where user =' root'

Mysql > select host,user from user

+-+ +

| | host | user |

+-+ +

| |% | root |

| | 127.0.0.1 | root |

| |:: 1 | root |

| | hadoop | root |

+-+ +

4 rows in set (0.00 sec) method 2:

After GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' youpassword' WITH GRANT OPTIO, you can try to log in remotely, and sure enough, it is a success.

C:\ Users\ lnwxzyp > mysql-uroot-proot-h292.168.56.101

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.6.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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 > during the installation process, due to no refresh permission after changing the password, and restarting mysql, the following error occurred during login

[root@Hadoop bin] # mysql-uroot-p

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) in this case, you need to set the skip verification table

[root@Hadoop bin] # mysqld_safe-- skip-grant-tables

160530 14:28:31 mysqld_safe Logging to'/ var/lib/mysql/Hadoop.err'.

160530 14:28:32 mysqld_safe A mysqld process already exists and then you can log in in mysql-u root mysql mode, and open another terminal [root@Hadoop ~] # mysql-u root mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with-A

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 2

Server version: 5.6.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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 > UPDATE user SET Password=PASSWORD ('root') where USER='root'

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

Mysql > FLUSH PRIVILEGES

Query OK, 0 rows affected (0.00 sec)

Mysql > quit

Bye

[root@Hadoop] # and then restart mysql and then it will be normal.

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.