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