命令行不能使用mysql_无法从命令提示符运行MySQL

bd96500e110b49cbb3cd949968f18be7.png

I downloaded MySQL 5.6.25 for Windowsx64 and I tried to run the command

mysql -uroot -p

to start using MySQL but it says

'mysql' is not recognized as an internal or external command, operable program or batch file.

Do I need to move MySQL to some other place? It is currently on the desktop.

EDIT: I downloaded Xampp but now when I run that same command I get this:

nzxNL.png

解决方案

You need to place mysql in your environment variable PATH in order to run it from the command prompt, if you are not in bin directory of mysql.

On windows 7 (should be similar for 8):

go to control panel>system

on left hand side you should see Advanced system settings>double click on that

At bottom of system properties you should see Environment Variables

scroll down in the bottom panel till you see PATH click on it

then click EDIT button underneath>opens new window Edit system variables

at the end add your path to your mysql installation bin folder like C:\mysql\mysql5.6.23\bin; (must separate by ;).

jQxBQ.png

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值