CODEWITHSUNDEEP
mysqlpowershell
rlinner
rlinner

Reputation: 57

Cannot connect to MySQL via Windows PowerShell

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!

Upvotes: 0

Views: 854

Answers (1)

DataVader
DataVader

Reputation: 780

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

Upvotes: 1

Related Questions