Home / Questions / 530637
Accepted
Revolucion for Monica
Asked: 2022-06-29 02:02:48 +0800 CST 2022-06-29 02:02:48 +0800 CST

'mysql' is not recognized as the name of a cmdlet

  • 772

I have connected to my Amazon bastion and am now trying to connect to my database. However, when I try to run mysql I get an error:

PS C:\Users\antoi> mysql --u admin -p password -h127.0.0.1 -P4000
mysql : The term 'mysql' is not recognized as the name of a cmdlet, function, script file, or operable program. Check
the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ mysql --u admin -pfswR6c9Vbq5AvBNd4jntUCzYJaeTP_7F -h127.0.0.1 -P4306
+ ~~~~~
    + CategoryInfo          : ObjectNotFound: (mysql:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

So I have MySQL here:

PS C:\ProgramData\Microsoft\Windows\Start Menu\Programs\MySQL> dir


    Directory: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\MySQL


Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d-----        27/04/2021     08:20                MySQL Installer - Community
d-----        25/06/2021     11:33                MySQL Server 5.7
-a----        14/06/2021     10:15           2238 MySQL Workbench 8.0 CE.lnk

Unfortunately there is not bin/in my directory:

enter image description here

mysql

1 Answers

  1. Best Answer

    If you want to execute the command mysqlfrom any directory you have to add to the "Environment Variables" of Window the path to theexe

    Steps:

    1. Right click the Start button > click "System"
    2. Click on "Advanced system options"
    3. Click on the "Advanced" tab
    4. Click the "Environment Variables" button

    enter image description here

    1. Select "Path" under "User Variables" or "System Variables" ( my preferred ) and click the "Edit" button

    enter image description here

    1. Add the path to the directory where theexe

    enter image description here

    1. Click "OK" in the "Edit environment variables" window
    2. Click "OK" in the "Environment Variables" window
    3. Click "OK" in the "System Properties" window
    4. Open a new console/powershell/cmd

    PS: Excuse me, but my Windows is in English xD

    Option 2:

    From the console run the command:

    set PATH=%PATH%;C:\path\al\directorio\

    Note: The "downside" is that it is temporary and only applies to the console session.

    • 3