显现'mysql' 不是内部或外边命令，亦不是可运行的程序怎么处理？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"> 在cmd里<span style="color: black;">显现</span>mysql 不是内部或<span style="color: black;">外边</span>命令，<span style="color: black;">亦</span>不是可运行的程序怎么<span style="color: black;">处理</span>？</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 在cmd里<span style="color: black;">显现</span>mysql 不是内部或<span style="color: black;">外边</span>命令，<span style="color: black;">亦</span>不是可运行的程序或批处理文件怎么<span style="color: black;">处理</span>？安装phpstudy后<span style="color: black;">起步</span>mysql，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1d116c5aa3014646a0ace516e239dd6e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=9ri3Yv7gDM62oMJMRpjPZ%2BDZolo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">然则</span>在cmd里输入mysql -u root -p会提示下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c38567f8c864409894df4bc579ad31fc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=zYVdueLQEGnwrcLq9fDEc2NzUe8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">mysql 不是内部或<span style="color: black;">外边</span>命令，<span style="color: black;">亦</span>不是可运行的程序或批处理文件。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"> <span style="color: black;">处理</span><span style="color: black;">办法</span>：</strong>这是<span style="color: black;">由于</span>window的环境变量里<span style="color: black;">无</span>添加mysql数据库BIN的目录。下面<span style="color: black;">起始</span>添加操作：<strong style="color: blue;">右键我的电脑→属性</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6b927a70a9e0447d9b432bbad922912c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=J%2B0juw4uB%2Ft%2FWkNVZdpJyDzZWxU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击高级系统设置如下图</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/fb20964846bc401eab76bccd30bd8d73~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=DnGcShDmmlAkcQEi0CBpIwt3jpQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击环境变量如下图</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e5b5f5261e9246c48e1de34172f646f8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=DYgZmv6QOUzJW8xyiffvGICT4iY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击path（path的中文翻译为路径）如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a82793fee5164e57a6a5f2d1f7519056~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=Q5iLXPLTdvdscos55pOp%2FESQxm0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击编辑后出来下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/923d4b32c8ed4ced9986d9f6d21fc0c3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=6huzhkE9U8k%2BZ2CNOpK6MUh0h1A%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击新建出来下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8603b4f05c31474f8abf9541f67c10a7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=x8g%2F0cDDrTOhx1y7%2FNvTxILbutw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">找到mysql数据库的安装目录：找到phpstudy目录下的Extensions（英文翻译中文的意思为扩展），找到如下目录：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d9b057632a984cafb4043409b0d894b2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=hG1bZcLPsE2VGR3z%2BPOoJbG0FdI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在mysql目录里在找到bin目录，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c17407e7c1d0480da6c85767655b117d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=fzqwxXRiM41bh%2B6yOtJbqLF2UKA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">从而得到<span style="color: black;">咱们</span>的mysql数据库里的BIN路径：D:\phpstudy_pro\Extensions\MySQL5.7.26\bin</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">复制以上路径</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ab5191d3df4e4e489bd2ef4eb48a3bbd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=o%2FOP5FG3X7LZzNAEiCi2wjyjifY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击确定，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2bbb62b231494f79819983084b9d80eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=zzn%2FoWQtEYQybBIddY1ql%2BbbdFc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击确定，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/06dafc3969ee472d80746eac604044ef~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=L7wm6UFzYQF%2F6OCj8uuqo2SNuyo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>重启mysql如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/97b0d40a9c014b0e9efbab0c91b9c742~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=S9PW2M%2B9oX8Ld67EEWDgml1%2F8Aw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>运行cmd运行cmd如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b254c5d2ca244d6786289ac87807e2ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=gf8w85wqLgiYgDVqcG5rJRSt%2FRg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在cmd里重新输入mysql -u root -p如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8508e4ba6f9b42468a1038502550b026~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728294412&x-signature=w9%2FYOYWMBKktdBDY%2F3Y93ed6f6k%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">会提示弹出Enter password:输入你的<span style="color: black;">秘码</span>就<span style="color: black;">能够</span>，<span style="color: black;">而后</span>就<span style="color: black;">能够</span>cmd登陆你的mysql数据库了。</p>
你的见解真是独到，让我受益匪浅。
页:
[1]