Run MySQL on Command Line in Windows

  Pi Ke        2011-08-21 04:14:58       8,645        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

MYSQL  CONSOLE  COMMAND LINE  WINDOWS  DEFAU 

       

  RELATED


  0 COMMENT


No comment for this article.



  RANDOM FUN

HTTP 200 OK