mysql5.7.24免安装版配置及密码初始化及mysql-font连接异常
1、解压文件，例如：置于E:\Program Files\mysql-5.7.24-winx64，新建my.ini ,内容如下：
[mysqld] # 设置为自己MYSQL的安装目录 basedir=E:\Program Files\mysql-5.7.24-winx64 # 设置为MYSQL的数据目录 datadir=E:\Program Files\mysql-5.7.24-winx64\data port=3306 character_set_server=utf8 sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER #开启查询缓存 explicit_defaults_for_timestamp=true #skip-grant-tables
新建data文件夹；
2、环境变量中，配置path:;E:\Program Files\mysql-5.7.24-winx64\bin;
3、cmd管理员身份打开，定位到E:\Program Files\mysql-5.7.24-winx64\bin下，执行命令：
mysqld -install [服务名]
显示服务创建成功。服务名默认为mysql；
4、获取初始密码，执行命令：
mysqld --initialize --user=mysql --console
记录末尾的密码，初次登陆时使用，例如：localhost: x;4aCuXaUHx-；
5、启动服务，执行命令：
net start mysql
6、登陆mysql:
mysql -u root -p
输入步骤4中的密码，登陆成功；
7、设置默认密码，依次输入下列命令：
use mysql； alter user 'root'@'localhost' identified by 'mysql'; SET PASSWORD = PASSWORD('123456'); flush privileges;
8、连接MySql-Front提示异常信息The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see thedocumentation for 'show_compatibility_56'，执行如下代码：
MySQL> select * from information_schema.global_status limit 3; ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' --查看show_compatibility_56其值 MySQL> show variables like '%show_compatibility_56%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | show_compatibility_56 | OFF | +-----------------------+-------+ 1 row in set (0.01 sec) --把show_compatibility_56打开 mysql> set global show_compatibility_56=on; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%show_compatibility_56%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | show_compatibility_56 | ON | +-----------------------+-------+ 1 row in set (0.00 sec) mysql> select * from information_schema.global_status limit 3; +-----------------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------------+----------------+ | ABORTED_CLIENTS | 0 | | ABORTED_CONNECTS | 0 | | BINLOG_CACHE_DISK_USE | 0 | +-----------------------+----------------+ 3 rows in set, 1 warning (0.00 sec)优质内容筛选与推荐>>
1、ajax和axios、fetch的区别
2、虚拟机centos6.5 --开放端口
3、rabbitmq和redis用作消息队列的区别
4、第一篇 HTML 认识HTML
5、Java随记