CODEWITHSUNDEEP
mysqlmariadb
Andrew Koper
Andrew Koper

Reputation: 7191

Interact with a MySQL database from Windows command line

I want to use MySQL/MariaDB from the command line. In Windows, when I type "mysqld" to start the database server, the command prompt to run the MySQL client and type SQL disappears. How do I start the server and interact with the database on the command line?

Enter image description here

Upvotes: 1

Views: 1052

Answers (2)

Mohammad Hossein Fattahizadeh
Mohammad Hossein Fattahizadeh

Reputation: 2711

You're running mysqld (the MySQL daemon) successfully. It's a server and now serves MySQL.

After that, you need to run mysql, the MySQL client from the command-line interface for interacting with the server.

Upvotes: 2

Amir
Amir

Reputation: 1905

You can install the MySQL shell from here.

And then start it like this:

mysqlsh --uri user@localhost

Take a look at the official documentation

Upvotes: 0

Related Questions