当前位置：首页 > news >正文

数据库介绍，安装，配置

news 2026/3/26 22:11:34

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 保存表情数据查看数据库就可以看到数据库中有表情字符的存在。

查看全文

http://www.jsqmd.com/news/33555/