1.mysql5.7.17安装
windows10系统，下载mysql-5.7.17-winx64，copymysql-5.6.35-winx64的data文件，进入安装数据库目录bin： cd C:\ProgramFiles\mysql-5.7.17-winx64\bin
安装服务：mysqld -install;
启动服务：net start mysql;
空密码进入：mysql -hlocalhost -uroot;
设置密码：
use mysql
update user set password=PASSWORD('123') where user='root';
2.赋予外网访问权限(否则外网访问显示没有权限)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;
3.解决错误ERROR 1524 (HY000)+1045
退出：quit;
重新登录：mysql -hlocalhost -uroot -p123
提示错误：
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1524 (HY000): Plugin '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' is not loaded
为避免密码显示不安全，改为：mysql -u root -p 123
提示输入密码：Enter password: ***
出错：ERROR 1524 (HY000): Plugin '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' is not loaded
设置使用空密码登录数据库： mysqld -uroot --skip-grant-table
登录数据库：mysql -uroot；
出错：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
用密码登录：mysql -uroot -p
重置plugin：
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
FLUSH PRIVILEGES;
3.解决外部访问出错：
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist
进入bin目录，输入：
mysql_upgrade -u root -p --force
重启服务，ok
