ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密码';
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 73
Server version: 5.5.54-0ubuntu0.14.04.1 (Ubuntu)
mysql> show databases ;
mysql> use flow_information;
mysql> show tables;
mysql> desc staWor2AppNew;
mysql> create table staWor2AppDF like staticWord2App;
mysql> select count(*) from staWor2AppDF;
mysql> select count(*) from staWor2AppNew;
+----------+
| count(*) |
+----------+
| 55052 |
+----------+
1 row in set (5.78 sec)
mysql> select count(*) from staticWord2App;
+----------+
| count(*) |
+----------+
| 7795441 |
+----------+