ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密碼';
win10下MYSQL的下載、安裝以及配置超詳解教程~~小白入 - 云南省高校數(shù)據(jù)化運營管理工程研究中心的博客 - CSDN博客
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 |
+----------+