Cannot connect to MySQL via Windows PowerShell

Question

I have MySQL 5.7 Community installed on Win10 and I have been using it with MySQL Workbench. Now I want to set up a replication slave and from what I found this is not possible using Workbench.

That means I have to use the Shell. According to the MySQL docs I open the Windows PowerShell (as I understand “your command interpreter”) and type the name of my database. so the line in the PowerShell looks like this:

PS C:> mysql my_database

What I get is: “mysql: the name ‘mysql’ was not recognized as the name of a Cmdlet, a function …” (this is my translation). I tried it with the path to where MySQL is installed but same output. Where is my mistake? What is missing? Would be happy if someone could give me a hint! Thanks!

mysql.exe is not in C: - open powershell, navigate to the folder where mysql.exe file is and then run mysql — Vladimir Bundalo
– Vladimir Bundalo, Commented Sep 4, 2018 at 14:16

DataVader · Accepted Answer · 2018-09-04 14:29:43Z

1

You need to set mysql in your windows environment variables to use the command "mysql" in your terminal. You could also use the full path in your terminal, but it's annoying and bad for scripting

answered Sep 4, 2018 at 14:29

DataVader

7801 gold badge5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rlinner Over a year ago

That's it! Thank you! But it was not that simple for someone who never used the Powershell. I tried the full path as well, but for some reason I did not get further than "MySQL\", it did not recognize "\MySQL Server 5.7\bin\" as part of a valid path. Does not bother me now. Thanks again

Collectives™ on Stack Overflow

Cannot connect to MySQL via Windows PowerShell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related