Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Upgrading to MySQL 5.7.9 MySQL 5.6.23     - Three strategies to teach you to release the device memory (Linux)

- Tune in high resolution to 1280x800 in Fedora 14 (Linux)

- Ubuntu uses under KVM + Qemu virtual machine build (Linux)

- Oracle GoldenGate encryption (Database)

- Linux vi command list (Linux)

- Nginx version information hidden or modified (Server)

- sudoers file parsing (Linux)

- Boot-Repair Tool - repair of frequent start-up problems (Linux)

- MySQL binary packages install for RedHat Linux Enterprise 6.4 (Database)

- MySQL partition summary (Database)

- Teach you how to protect the security of Linux desktop (Linux)

- Use Redis as time-series database: why and how (Database)

- Ubuntu and derived versions of the user how to install G Mic 1.5.8.5 (Linux)

- Linux Apache server configure to protect system security (Linux)

- Use Bosh deploy CloudFoundry problems encountered on OpenStack (Server)

- MySQL high availability cluster fragmentation of deployment uses Fabric (Database)

- HBase Application Development Review and Summary of Series (Database)

- Five strokes to find out the IP address you want to know (Linux)

- Android Studio simple setup (Linux)

- Android timer use (Programming)

 
         
  Upgrading to MySQL 5.7.9 MySQL 5.6.23
     
  Add Date : 2018-11-21      
         
       
         
  MySQL 5.7.9 New Features

A, Security

1.1 user table mysql.user field does not allow the plugin is empty, the default value is mysql_native_password, instead mysql_old_password, no longer support the old password format;

1.2 increase in expired password mechanism, expired need to modify the password, or may be disabled, or to enter the sandbox mode;

1.3 Use mysqld --initialize initialized by default automatically generates a random password, and do not create additional accounts except root @ localhost outside, nor create test library;

Changed after mysqld --initialize, if there is already data files in datadir points to the destination directory, there will be similar tips:

2015-11-20T17: 03:. 38.200709Z 0 [ERROR] --initialize specified but the data directory has files in it Aborting.

2015-11-20T17: 03: 38.200807Z 0 [ERROR] Aborting

Therefore, we need to make sure that under datadir target directory is empty, to avoid misuse destroy existing data.

B. Upgrade

2.1. Decompression tar -zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz

2.2. The 5.7.9 version in the default directory

mv mysql-5.7.9-linux-glibc2.5-x86_64 / usr / local / mysql

Close mysql5.6.23 database service mysql stop

2.3 modify the data path /etc/my.cnf, the existing database mysql5.6.23 has run the business data in /mnt/sda4/mysql5.6.23/data

datadir = /mnt/sda4/mysql5.6.23/data

2.4 Starting service mysql start

2.5. Try to insert the data and check to see if normal

[Root @ sam tt] # / usr / local / mysql / bin / mysql -uroot -h127.0.0.1 test -e "select * from dsp_monitors where time = '2015-11-19 14:03:00';"

+ ---- + ---------- + ---------- + ----------- + ---------- ----------- + -------------- + --------------- + ------- -------- + ---------- +

| Id | exchange | flowType | size | time | requestCount | filteredCount | outPriceCount | bidCount |

+ ---- + ---------- + ---------- + ----------- + ---------- ----------- + -------------- + --------------- + ------- -------- + ---------- +

| 1 | tt | desktop | 250X250FC | 2015-11-19 14:03:00 | 0 | 431884 | 0 | 0 |

| 2 | tt | desktop | 250X250FC | 2015-11-19 14:03:00 | 0 | 431884 | 0 | 0 |

+ ---- + ---------- + ---------- + ----------- + ---------- ----------- + -------------- + --------------- + -
     
         
       
         
  More:      
 
- Spring inject a type of object to enumerate (Programming)
- Comparison of Nginx and Nginx + (Server)
- hadoop 2.7.1 High Availability Setup Deployment (Server)
- Fedora 22 users to install the VLC media player (Linux)
- Ubuntu 14.04 can be used to create a WIFI hotspot for Android (Linux)
- The compiler installed Kaldi under Ubuntu 12.04 (Linux)
- Nonstandard IMP-00010 error processing one case (Database)
- Some common regular expressions (Linux)
- HashMap in Android and Java different implementations (Programming)
- Learn to read the source code of vmstat (Linux)
- Commonly used Linux system camouflage method (Linux)
- Oracle 11G using DG Broker create DataGuard (Database)
- MySQL performance comparison of large amounts of data storage (Database)
- HA-Federation-HDFS + Yarn cluster deployment (Server)
- Linux command find (Linux)
- xCAT Installation Kit (Linux)
- How to migrate MySQL to MariaDB under linux (Database)
- Linux prohibit non-WHEEL user su command Detail (Linux)
- Fast Sort Algorithms (Programming)
- CentOS 6.5 configuration SSDB 1.8.0 (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.