Windows系统通过CMD连接MySql

﹏ヽ暗。殇╰゛Y 2023-02-13 08:48 19阅读 0赞

1.按压Windows+R快捷键后输入"cmd"

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70][]

2.点击"确定"按钮后打开命令行

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 1][]

3.通过输入"cd"+MySql安装的bin目录，按压"Enter"后进入MySql安装的bin目录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 2][]

4.输入"mysql -h localhost -u root -p"，此处-h后为对应host，此处为localhost，-u后为用户名，此处为root，

\-p后应为密码，此处按压"Enter"按钮后依据提示输入对应密码，输入后按压"Enter"按钮后即可

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 3][]

注意:此处前提是对应host上MySql服务已开启且对应用户的可访问权限中包含本地

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200528100427400.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200528100522219.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200528100828366.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2020052810135534.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDkzMzMwOQ==,size_16,color_FFFFFF,t_70