打开mysql的方法（高逼格）新手必学！！！

*新手务必一步一步来

共4个指令（包含指令与显示结果）

第一步：

启动myql的命令：

1.显示mysql提供的服务：

1.进入到bin目录下：cd  后面加路径

例如：

C:\Users\Administrator>cd C:\Program Files\MySQL\MySQL Server 5.5\bin     //下划线表示文件路径

C:\Program Files\MySQL\MySQL Server 5.5\bin>

 

2.运行dir命令:   \\显示mysql提供的服务（程序包）

例如：

C:\Program Files\MySQL\MySQL Server 5.5\bin>dir

驱动器 C 中的卷没有标签。

卷的序列号是 58D0-7369

C:\Program Files\MySQL\MySQL Server 5.5\bin 的目录

2020/03/27  17:31    <DIR>          .

2020/03/27  17:31    <DIR>          ..

2017/11/27  13:55         3,813,376 myisamchk.exe

2017/11/27  13:55         3,676,672 myisamlog.exe

2017/11/27  13:54         3,717,632 myisampack.exe

2017/11/27  13:55         3,692,544 myisam_ftdump.exe

2017/11/27  13:55         4,059,648 mysql.exe

2017/11/27  13:54         3,949,056 mysqladmin.exe

2017/11/27  13:54         4,083,200 mysqlbinlog.exe

2017/11/27  13:55         3,946,496 mysqlcheck.exe

2017/11/27  13:56         9,459,200 mysqld.exe

2017/11/27  13:54         4,023,296 mysqldump.exe

2017/11/27  13:50             7,576 mysqldumpslow.pl

2017/11/27  13:50            25,189 mysqld_multi.pl

2017/11/27  13:50            36,010 mysqlhotcopy.pl

2017/11/27  13:54         3,940,352 mysqlimport.exe

2017/03/13  18:37         2,973,600 MySQLInstanceConfig.exe

2017/11/27  13:54         3,940,352 mysqlshow.exe

2017/11/27  13:54         3,959,808 mysqlslap.exe

2017/11/27  13:50             8,769 mysql_config.pl

2017/11/27  13:50             4,380 mysql_convert_table_format.pl

2017/11/27  13:56        10,261,504 mysql_embedded.exe

2017/11/27  13:54         3,385,344 mysql_plugin.exe

2017/11/27  13:50             9,586 mysql_secure_installation.pl

2017/11/27  13:53         3,344,896 mysql_tzinfo_to_sql.exe

2017/11/27  13:54         4,016,640 mysql_upgrade.exe

2017/11/27  13:53         3,373,056 my_print_defaults.exe

2017/11/27  13:55         3,482,112 perror.exe

2017/11/27  13:53         3,371,520 resolveip.exe

              27 个文件     90,561,814 字节

               2 个目录 52,962,365,440 可用字节

C:\Program Files\MySQL\MySQL Server 5.5\bin>

 

 

 

 

启动mysql服务： mysqld --console

出现port 3306(端口号)启动成功

例如：

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --console

200514 17:23:30 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

200514 17:23:30 [Note] mysqld (mysqld 5.5.59) starting as process 9516 ...

200514 17:23:30 [Note] Plugin 'FEDERATED' is disabled.

200514 17:23:30 InnoDB: The InnoDB memory heap is disabled

200514 17:23:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions

200514 17:23:30 InnoDB: Compressed tables use zlib 1.2.3

200514 17:23:30 InnoDB: Initializing buffer pool, size = 42.0M

200514 17:23:30 InnoDB: Completed initialization of buffer pool

200514 17:23:30 InnoDB: highest supported file format is Barracuda.

200514 17:23:30  InnoDB: Waiting for the background threads to start

200514 17:23:31 InnoDB: 5.5.59 started; log sequence number 1981079

200514 17:23:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

200514 17:23:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

200514 17:23:31 [Note] Server socket created on IP: '0.0.0.0'.

200514 17:23:32 [Note] Event Scheduler: Loaded 0 events

200514 17:23:32 [Note] mysqld: ready for connections.

Version: '5.5.59'  socket: ''  port: 3306  MySQL Community Server (

 

 

**将程序最小化，重开一个命令行进入下一步

 

第二步：

进入mysql的命令：

依照上面的方法进入bin目录下：

运行 mysql.exe -u用户名  -p密码 回车

例如:

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql.exe -uroot -pasd

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.59 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>

 

 

启动成功