Accessing MySQL via phpMyAdmin


Share

Although to use MySQL it is essential to learn these main commands and how they work, once you have learned them, it can be much quicker and simpler to use a program such as phpMyAdmin to manage your databases and tables.

In a phpMyAdmin we can crete database related to php and all related information store in phpMyAdmin. This a server side plateform where all user related data stored.

For example we can create world database and create city table. In city table we can store all website login user information like id, name, Email etc.


Windows Users


Ensure that you have Zend Server CE up and running so that the MySQL database is ready, then type the following into the address bar of your browser:
http://localhost/phpMyAdmin
Your browser should now look figure 1.1, where you should enter a username of zend (the default) and no password. You will then be presented with a screen similar to figure 1.2.

figure 1.1 Logging in to phpMyAdmin


figure 1.2 The phpMyAdmin main screen


OS X Users


Ensure that Zend Server CE is running and that the Apache and MySQL servers are started, then type the following into your browser:
http://localhost:10081/phpmyadmin/
You should see a screen similar to Figure 1.1, where you should enter a username of zend (the default) and no password. Your browser should now look like Figure 1.2.


Linux Users


If you have installed Zend Server CE with MySQL, you should be able to type the following into your browser to start phpMyAdmin:
https://localhost:10082/phpMyAdmin
Your browser should now look like Figure 1.1. Enter the username zend (the default), and you should see a screen similar to Figure 1.2.


Using phpMyAdmin


In the lefthand pane of the main phpMyAdmin screen, which should now appear in your browser, click on the drop-down menu that says “(Databases)” and select the database World. This will open the database and display its two tables just below. Click on the city table, and you’ll see a host of information about it appear in the righthand frame (see Figure 1.3).

From here you can perform all the main operations for your databases, such as creating databases, adding tables, creating indexes, and much more.


figure 1.3 The table city as viewed in phpMyAdmi