Today's Question:  What weekend projects have you created?        GIVE A SHOUT

Technical Article => Database =>  MySQL

Steps to connect to MySQL on Windows Command Line

  Pi Ke      2011-11-05 08:22:39      6,040    0

To connect to MySQL database on Windows through Command line, there are some steps to be followed.

1. You need to start the MySQL service, you can go to Start->Control Panel->System and Securities->Administrative Tools->Component Service->Services(local), then on the right panel, you can find one service name called MySQL and you should start this service

2. Go the the MySQL installation folder, which is something like this : C:\Program Files\MySQL\MySQL Server 5.1. In this folder, find the bin folder.

3. Open a command console and change the working directory to C:\Program Files\MySQL\MySQL Server 5.1\bin (You may change this according to you MySQL installation folder). And then type mysqld to start the MySQL server. You can check the status of the mysql server by start the task manager to check whether the mysqld process is present or you can type mysqladmin -u <username> -p <password> version to check whether it works or not.

4. Next you need to start the mysql client, which is the mysql.exe file in the same folder as the mysqld.exe. On the same command console, type mysql -u <username> -p <password> to connect to the server.

5. If the connection is successful, the mysql> prompt will show up. If the connection fails, you may check whether you type the correct username and password.

6 After successful connection, you can type SHOW DATABASES; to check the databases on the MySQL server.

That's all. If you still have confusions, please feel free to leave a message below or send me an email through



Share on Facebook  Share on Twitter  Share on Google+  Share on Weibo  Share on Reddit  Share on Digg  Share on Tumblr    Delicious



No comment for this article.


Samsung Galaxy Note 7 starter package

By sonic0002