MySQL5.7.24安装配置（图⽂超详细教程）innodb_flush_log_at_trx_commit=0 （208⾏）
更改为0
innodb_buffer_pool_size=2G（224⾏）
数值⼀般修改为实际内存的⼀半即可
修改数据库编码为UTF8
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
添加完毕后去服务⾥⾯重启My SQL
测试My SQL
切换到⽬录D:\MySQL\MySQL Server 5.7\bin下
运⾏cmd窗⼝
mysql -uroot -p 输⼊密码 然后status
D:\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.24-log MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> status
--------------
mysql  Ver 14.14 Distrib 5.7.24, for Win64 (x86_64)
Connection id:          6
Current database:
Current user:          root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:        5.7.24-log MySQL Community Server (GPL)
Protocol version:      10
Connection:            localhost via TCP/IP
Server characterset:    utf8
Db    characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:              3306
Uptime:                10 min 17 sec
Threads: 1  Questions: 6  Slow queries: 0  Opens: 108  Flush tables: 1  Open tab
les: 101  Queries per second avg: 0.009
--------------
mysql>
最终显⽰utf8
MySQL调试完毕
导⼊数据库
常⽤source 命令
进⼊mysql数据库控制台
如 mysql -uroot -p
show databases;
mysql>use xxx;
然后使⽤source命令，后⾯参数为脚本⽂件(如这⾥⽤到的.sql) mysql>source D:/xxx.sql
mysql下载配置显⽰导⼊成功即可

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。