Interact with a MySQL database from Windows command line

Question

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?

Peter Mortensen · Accepted Answer · 2021-10-05 19:42:12Z

2

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.

edited Oct 5, 2021 at 19:42

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 11, 2019 at 20:42

Mohammad Hossein Fattahizadeh

2,7315 gold badges35 silver badges50 bronze badges

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

1 Comment

Peter Mortensen Over a year ago

Do you understand your own writing? Are you using machine translation (e.g., Google Translate)?

Peter Mortensen · Accepted Answer · 2021-10-05 19:38:22Z

0

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

edited Oct 5, 2021 at 19:38

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 11, 2019 at 20:32

Amir

1,9153 gold badges22 silver badges42 bronze badges

Collectives™ on Stack Overflow

Interact with a MySQL database from Windows command line

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related