https://www.cnblogs.com/linhaifeng/articles/7126847.html
1.数据库服务器：运行数据库管理软件的计算机
2.数据库管理软件：MySQL，Oracle，db2，SQLserver
3.库：文件夹
4.表：文件
5.记录：事物一系列的特征：cy，male
6.数据：描述事物特征的符号
安装MySQL后将MySQL加入系统服务指令
Microsoft Windows [版本 10.0.19045.6456]
(c) Microsoft Corporation。保留所有权利。C:\Users\12906451>tasklist |findstr mysql
mysqld.exe 33840 Console 1 465,920 KC:\Users\12906451>taskkill /F /PID 33840
成功: 已终止 PID 为 33840 的进程。C:\Users\12906451>mysqld --install
Service successfully installed.C:\Users\12906451>mysqld --remove
Service successfully removed.C:\Users\12906451>mysqld --install
Service successfully installed.
破解密码
C:\Users\12906451>tasklist |findstr mysqld
C:\Users\12906451>taskkill /F /PID 123567C:\Users\12906451>net stop MySQL
MySQL 服务正在停止.
MySQL 服务已成功停止。
C:\Users\12906451>mysqld --skip-grant-tablesC:\Users\12906451>mysql -uroot -p
mysql> update mysql.user set password=password("") where user="root" and host="localhost";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)mysql> exitC:\Users\12906451>tasklist |findstr mysqld
C:\Users\12906451>taskkill /F /PID 123567
C:\Users\12906451>net start MySQL统一字符编码
新建my.ini 配置设置文件
[mysqld] # mysqld服务端的配置
character-set-server=utf8
collation-server=utf8_general_ci
[client] # 客户端的配置
default-character-set=utf8
[mysql] # MySQL客户端的配置
default-character-set=utf8
user="root"
password=""
新建my.ini 配置设置文件前
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.6.39, for Win64 (x86_64)Connection id: 5
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.6.39 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 14 hours 2 min 2 secThreads: 1 Questions: 14 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.000
--------------
新建my.ini 配置设置文件后
# 查看配置文件
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.6.39, for Win64 (x86_64)Connection id: 6
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.6.39 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 14 hours 14 min 18 secThreads: 1 Questions: 20 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.000
--------------
配置完成后重启MySQL服务
C:\Users\12906451>net stop MySQL
MySQL 服务正在停止.
MySQL 服务已成功停止。C:\Users\12906451>net start MySQL
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
mysql数据库怎么存入emoji表情
# 第一步：设置数据库字符编码为utf8mb4_general_ci 设置相应表字段字符编码为utf8mb4_general_ci# 第二步：设置my.ini增加以下配置信息[client]
default-character-set = utf8mb4[mysql]
default-character-set = utf8mb4[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'# 第三步：重启MySQL 保存表情数据查看数据库就可以看到数据库中有表情字符的存在。