Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have downloaded MYSQL without installer suppourt in my windows 64 bit machine . I have followed the guidelines mentioned in this website

i have installed it inside c: mysql directory .

As first step i navigated to c:\mysql\bin>mysqld , as shown in picture below . This started the Database

enter image description here

Then i opened another command Prompt Window and navigated to c:\mysql\bin> and typed show databases;

With this it it showing an Error in Command Prompt saying

enter image description here

share|improve this question

migrated from Jun 15 '12 at 15:20

This question came from our site for professional and enthusiast programmers.

You have to launch the mysql command line tool by typing mysql before you may type mysql commands. – Denys Séguret Jun 15 '12 at 15:13
First, cmd is not mysql console. Launch mysql command before executing any queries. Second, I believe this question is better suited for SuperUser or ServerFault. – mingos Jun 15 '12 at 15:13
Thanks a lot , the document hasn't mentioned this thing i guess :) – yyy i 777 Jun 15 '12 at 15:15

From your second image enter mysql - then you're "in" mysql, and should do all your mysql operations there. The second image is "just a command prompt", not in mysql, so windows itself doesn't recognize such commands. Try a sql statement like 'SHOW STATUS' after entering the mysql application with mysql.

share|improve this answer

There's two parts, your MySQL Server and your MySQL Client.

mysqld command launches the MySQL Server.

You have to launch the MySQL Client to interact with your Server, with command line tool by typing mysql before you may type mysql commands.

share|improve this answer

You must log in to answer this question.