Today's Question:  What are you most afraid of as a programmer?        GIVE A SHOUT

Technical Article => Database =>  MySQL

Run MySQL on Command Line in Windows

  Pi Ke      2011-08-21 04:14:58      3,661    0    0

Sometimes if we want to run MySQL but we don't have phpMyAdmin installed. What should we do?

On Windows we can run MySQL in following steps:
  1. Open Console Window->Type "mysqld -u root". This means we start the mysql server with username root. This program will handle all the communications between our console window and the actual data;
  2. After starting the server, we need to use a client to connect to the server and communicate with it. the mysql program is right for this. Next in the command console, we type "mysql -u root -p" to connect the server. By default, after the installation,the default password for user root is blank. If you have changed the password, please enter your new password after the prompt "Enter password:";
  3. If all go well, congratulations, you have successfully connected to the server and next you can use some commands from this link to handle subsequent database processing. http://pixelstech.net/article/index.php?id=1306747097

WINDOWS MYSQL COMMAND LINE CONSOLE DEFAU

  SAVE AS PDF   MARK AS READ   MARK AS IMPORTANT

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

  RELATED


  0 COMMENT


No comment for this article.


  WRITE ARTICLE

Chrome, itadakimasu

By sonic0002