Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Upgrading to MySQL 5.7.9 MySQL 5.6.23     - Introduction and MongoDB CRUD (Database)

- IntelliJ IDEA run in Mac10.9 and JDK7 environment (Linux)

- How to use systemd timer (Linux)

- 64 Ubuntu 15.04 Linux kernel upgrade to Linux 4.1.0 (Linux)

- Java is simple to read and write HDFS Demo (Programming)

- Ubuntu 14.10 / 14.04 how to install Quick Start tool Mutate 2.2 (Linux)

- Win7 + Ubuntu Kylin + CentOS 6.5 installed three systems (Linux)

- JavaScript function part (Programming)

- jobs command example (Linux)

- GEC2440 easiest a kernel compile Linux2.6.30.4 (Programming)

- Java objects to garbage collection (Programming)

- Setting CentOS firewall open port (Linux)

- MySQL Tutorial: Building MySQL Cluster under Linux (Database)

- Java study notes: String (Programming)

- Linux system commands to view hardware information (Linux)

- Python Socket Network Programming (Programming)

- Port Telnet command to detect the remote host is turned on (Linux)

- Getting Started with Linux system to learn: how to check memory usage of Linux (Linux)

- dd command: do hard disk IO performance test (Linux)

- Ubuntu 12.04 commonly use shortcuts finishing Share (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:      
 
- Hibernate + JUnit test entity class generate database table (Programming)
- PostgreSQL transaction model introduction (Database)
- DNF Command Tutorial (Linux)
- Use Mop monitor stock prices at the Linux command line (Linux)
- CentOS RedHat YUM Source Extensions Supplement (including 32-bit, 64-bit) (Linux)
- Python MySQL database connection (Database)
- Installation in lxml Python module (Linux)
- Sshuttle A VPN-based transparent proxy that uses ssh (Server)
- Java programmers talk about those advanced knowledge and direction (Programming)
- Linux System Getting Started Tutorial: mounted directly in Linux LVM partition (Linux)
- Transfer MySQL database to MariaDB (Database)
- MySQL simple operation notes under Linux (Database)
- Linux file compression and file system packaged with instructions (Linux)
- How to Install Redis server on CentOS 7 (Server)
- Eclipse-ee Tomcat browser can not start Tomcat, and Web project service deployment (Server)
- Java class loading order (Programming)
- Servlet life cycle works (Programming)
- Ubuntu Locale configuration problem solving Can not set LC_CTYPE (Linux)
- Java NIO1: I / O model overview (Programming)
- Linux in order to make NMAP hide and seek with the firewall (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.