How To Check If Mysql Service Is Running On Windows

Introduction

MySQL is a popular and open-source relational database awarding. Therefore, many servers brand utilize of MySQL. The fashion you access the database depends on the operating system from which you lot are working.

This guide walks you through using the Windows Command line to connect to a MySQL database.

how to connect to mysql from windows command line

Prerequisites

A Windows-based system with an administrator account
A local installation of MySQL
Notepad text editor (optional)

Starting MySQL from the Windows Command Line

Stride 1: How to Open a Windows Command Prompt

Start by opening the Run control box in Windows. Use the keyboard shortcut – concord the Windows (super) key and printing the letter R (Win+R).

Then, type in cmd and press Enter. This command opens the Windows command line.

A black control line interface should launch, with white text and a cursor for you to type.

Stride two: Verify MySQL is Running on Windows

Adjacent, run the command to display a list of all the services that are currently running. Enter the following in the command prompt:

          cyberspace start

If MySQL is not on the list, y'all can commencement it using the Services panel. Enter the post-obit command:

          services.msc

A new window volition launch and display the listing of services available on your system. Ringlet downwardly to discover MySQL, and check the status column. Left-click the MySQL service to highlight it, then right-click to open up a context menu. Finally, left-click on start.

Footstep 3: Connect to a Local MySQL Server

First, first MySQL in Windows using the following command:

          mysql.exe -u[username] -p

Supervene upon [username] with the username for your MySQL installation.

Enter mysql.exe -uroot -p , and MySQL will launch using the root user.

MySQL will prompt you for your password. Enter the password from the user account you specified with the –u tag, and you'll connect to the MySQL server.

          Welcome to the MySQL monitor.  Commands stop with ; or g. Your MySQL connection id is 2 Server version: five.7.xi-log MySQL Community Server (GPL)

The control prompt changes to wait like this:

          mysql>

Alter to the MySQL binder, use the cd command:

          cd c:\Program Files\MySQL

The control prompt should change to mysql> letting you know yous're currently in the MySQL folder.

To list the contents of this folder:

dir

This lists the contents of the electric current folder. Ane of the folders will brandish the version number of your MySQL installation.

For instance, if you've installed MySQL five.5, you should see a binder named "MySQL Server 5.v".

Stride: 4 Create Windows Shortcut to Login to MySQL

To create a shortcut in Windows, enter the following in the command line:

          notepad

Open the Windows Notepad text editor with the command:

          cmd /K "C:\Program Files\MySQL\MySQL Server X.X\bin\mysql.exe" -uroot -ppassword

Replace -uroot with -u[username] if you lot have a different username, and -ppassword with -p[YourActualPassword] .

Likewise, make certain you change the path from MySQL Server X.X to the bodily folder location.

Now, printing Ctrl-S to launch a Relieve dialog.

So, type "mysql.bat" in the name field, and change the location to your desktop (or some other place that'due south easy to find).

This creates a pocket-sized Windows executable file that you can double-click to log into MySQL using the specified username and password.

Conclusion

With the help of this simple guide, you lot should be able to connect to a MySQL database using the Windows command prompt. Once you've logged into the MySQL server, the commands will be the same regardless of what kind of system you lot're running on.

If you are searching for an alternative, final-based solution, try out using PostgreSQL from command line.

Was this article helpful?

Yes No