Affordable web design - SETTING UP MYSQL AND PHPMYADMIN 3. To change
SETTING UP MYSQL AND PHPMYADMIN 3. To change the automatic startup option, highlight MySQL in the Services panel, right-click to reveal a context menu, and choose Properties. 4. In the dialog box that opens, activate the Startup type drop-down menu and choose Automatic, Manual, or Disabled. Click OK. That s all there is to it. Using the MySQL monitor on Windows Although most of your interaction with MySQL will be through phpMyAdmin or your own PHP scripts, it s useful to know how to access MySQL through the MySQL monitor (or the Command Line Client, as it s called in Windows Essentials). It s also a good way to test that your installation went without problems. To start a session From the Windows Start menu, select Programs . MySQL . MySQL Server 5.0 . MySQL Command Line Client. This will open the Command Line Client, which will ask you for your password. Type in the root password that you chose in step 10 of the section Configuring MySQL Windows Essentials and press Enter. As long as the server is running and you typed your password correctly you will see a welcome message similar to the one shown here. If you get your password wrong, your computer will beep and close the window. If you find this happening repeatedly, even though you re sure you typed in your password correctly, there are two likely explanations. The first is that your Caps Lock key is on MySQL passwords are case-sensitive. The other is that the MySQL server isn t running. Refer to the previous section on how to control MySQL manually before doing too much damage by banging your forehead on the keyboard. Being unable to connect to MySQL because the server isn t running is probably the most common beginner s mistake. The MySQL server runs in the background, waiting for requests. Opening the Command Line Client does not start MySQL; it opens the MySQL monitor, which is a channel for you to send instructions to the server. Equally, closing the Command Line Client does not stop MySQL. The server continues running in the background until the computer is closed down or until you stop it manually. Ending your session After you finish working with the MySQL monitor, type exit or quit at the mysql> prompt, followed by Enter. The MySQL Command Line Client window closes automatically. 269
In case you need quality webspace to host and run your web applications, try our personal web hosting services.