Replace -uroot with -u if you have a different username, and -ppassword with -p.Īlso, make sure you change the path from MySQL Server X.X to the actual folder location.
To create a shortcut in Windows, enter the following in the command line:.Step: 4 Create Windows Shortcut to Login to MySQL One of the folders will display the version number of your MySQL installation.įor example, if you’ve installed MySQL 5.5, you should see a folder named “MySQL Server 5.5”.
This lists the contents of the current folder. The command prompt should change to mysql> letting you know you’re currently in the MySQL folder. The command prompt changes to look like this: mysql>Ĭhange to the MySQL folder, use the cd command: cd c:\Program Files\MySQL Server version: 5.7.11-log MySQL Community Server (GPL)
Enter the password from the user account you specified with the –u tag, and you’ll connect to the MySQL server. Replace with the username for your MySQL installation.Įnter mysql.exe -uroot -p, and MySQL will launch using the root user. Step 3: Connect to a Local MySQL Serverįirst, start MySQL in Windows using the following command: mysql.exe -u -p Left-click the MySQL service to highlight it, then right-click to open a context menu. Scroll down to find MySQL, and check the status column. Enter the following command: services.mscĪ new window will launch and display the list of services available on your system.
If MySQL is not on the list, you can start it using the Services panel.