Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Upgrading to MySQL 5.7.9 MySQL 5.6.23     - Linux `dirname $ 0` (Linux)

- C ++ 11 smart pointers (Programming)

- Installation and management of Linux applications (Linux)

- ORA-04031 Error Resolution (Database)

- To use Java arrays implement the order form (Programming)

- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)

- Atlassian Linux Shell Scripting the confluence remote backup methods (Linux)

- Default permissions Linux file and directory permissions and hide - umask, chattr, lsattr, SUID, SGID, SBIT, file (Linux)

- Ubuntu clean up unnecessary disk space usage (Linux)

- Error code: 2013 Lost connection to MySQL server during query (Database)

- Linux beginners should know 12 commands (Linux)

- Definition Format Oracle basis of various statements (Database)

- Linux character device - user mode and kernel mode data transfer data (Linux)

- Java reflection by calling the class method (Programming)

- Keepalived + HAProxy high availability load balancing (Server)

- Boost notes --Asio - (1) a simple small example of synchronous communication (Programming)

- Linux modify the network interface name (Linux)

- MySQL performance view and configure finishing Daquan (Database)

- Oracle user lock how to know what causes (Database)

- Linux how to view the graphics models notebook (Linux)

 
         
  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:      
 
- Install the Red Hat Container Development Kit on OSX (Server)
- Learning C language pointer essays (Programming)
- Ubuntu 14.04 Fixed update information is outdated error (Linux)
- CentOS environment prepared crontab scheduled tasks (Linux)
- Log device files under Linux - logger (Linux)
- OpenGL Superb Learning Notes - Fragment Shader (Programming)
- Internal class broadcasting needs public and static (Programming)
- Java executable file to read information from a database copy (Programming)
- Android basics summary article (Programming)
- To install the Git and Github under Ubuntu (Linux)
- Java reflection Introduction (Programming)
- stat Usage: Get permission to file the corresponding figures (Linux)
- How to use Linux to download music from Grooveshark (Linux)
- Binary tree traversal algorithm summary (recursive and non-recursive) (Programming)
- Installation salt-minion on RHEL5 (Linux)
- C ++ handling text input (Programming)
- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)
- Java reflection technology explain (Programming)
- Linux users should be aware that should the 7 ls command unique skills (Linux)
- CentOS7 installation hardware monitoring for Zabbix enterprise applications (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.