Admin Panel 2: phpMyAdmin

Admin Panel 2

phpMyAdmin

Of all the tools this is my favorite, phpMyAdmin allows you handle the administration of your MySQL server locally or over the Internet. With it you can add and delete users, set their passwords and assign privileges. In addition you can execute any SQL statement.

It makes the task of creating and dropping databases extremely easy. Creating and altering tables and fields are less prone to error.

At the click of a button you can, drop tables or delete fields I wrote a step-by-step guide including images check out MySQL phpMyAdmin.

CLI

However if you prefer to access your MySQL server using a command line interface first make sure the servers are running, start a command prompt and navigate to folder *\Uniform Server\udrive\usr\local\mysql\bin and run the appropriate CLI commands from their.

Alternatively if you are using the default drive w you can navigate to the folder using this path: W:\usr\local\mysql\bin

In reality both paths are identical in that they take you to the same place, only difference one is quicker to type in.

If you have never used a command prompt and are following one of those tutorials that insist on going through those excruciatingly painful SQL exercises this example will get you to a mysql prompt.

Run a command window: start > run > type in cmd > click OK

This opens that small boring black window however don’t underestimate the power it allows you to gain access to the MySQL server through a MySQL prompt.

To obtain a MySQL prompt type everything highlighted in black, at the end of each line press return.

C:\main_docs>w: W:\>cd usr\local\mysql\bin W:\usr\local\mysql\bin>mysql -uroot -p Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.0.41-community-nt MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>

Notes:

1. C:\main_docs> This is referred to as the command prompt, You will see a different prompt depending what drive and folder you started from.
2. w: selects the drive Uniform Server is running on.
3. cd usr\local\mysql\bin takes you to the required folder.
4. mysql -uroot -p runs the mysql program with parameters. Most books seem to indicate a space is required between the u and root (u=user name) if you do expect an error 1049.
5. You could have placed the user name and password all on one line mysql -uroot -proot
6. mysql> is referred to as the mysql prompt. The actual program run is given the name mysql client.
7. If you seem to be stuck in a loop type \c and press return
8. To finish with the mysql client type exit and press return
9. To finish with the command prompt again type exit press return or click on the cross top right.

Top

---

Ric