Open the command prompt and type:. The best answers are voted up and rise to the top. You should just use -p with no password, and wait to be prompted for it instead. I've updated my question with what happened. You can also try to start the server as mysqld --console; in this case, you may get some useful information on the screen that may help solve the problem. Shaun Wild Shaun Wild 1 1 gold badge 2 2 silver badges 10 10 bronze badges. Question feed. I'm trying to connect to mysql server command line from my windows prompt I write the next line in cmd but i get an error.
Starting MySQL from the Windows Command Line. The MySQL server can be started manually from the command line. This can be done on any version.
MySQL MySQL Reference Manual Starting MySQL from the Windows Command Line
On Windows, click Start, All Programs, MySQL, MySQL Command Line Client. If you did not install MySQL with the MySQL Installer, open a command prompt. If your \MYSQL\BIN is on drive C: then your commands need to be:.
(After that you can open Windows Task Manager and verify in Processes.
Sign up to join this community. As in my case its Linked Thanks a lot this worked. If you type mysqlWindows will automatically look for an executable file with that name and run it if it finds it.
How To Run MySQL Queries Through Windows Command Prompt Artisans Web
You can also try to start the server as mysqld --console; in this case, you may get some useful information on the screen that may help solve the problem.
Video: Open mysql windows Open MySQL through Command Prompt CMD
Installing MySQL Database on Windows. To install MySQL database: Install the MySQL database server only and select Server Machine as the configuration.
How to connect to MySQL from the Windows command line
It is the file with a suffix of. Alvarez 61 1 1 silver badge 1 1 bronze badge. So to log in, type: mysql. Assumption : Assuming that mysql bin already included in path environment variable.
Open mysql windows
|Peter Mortensen 8, 16 16 gold badges 62 62 silver badges 85 85 bronze badges.
Don't include the password in the command, just use mysql. Featured on Meta. Ramandeep Singh Ramandeep Singh 2 2 silver badges 4 4 bronze badges.
Video: Open mysql windows Beginners MySQL Server Starting From cmd
Unicorn Meta Zoo 7: Interview with Nicolas. Other names may be trademarks of their respective owners. I'm not saying is wrong, I'm just saying change anything so I can upvote your answer?!