Accessing MySQL via phpMyAdmin
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.
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:
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:
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.
If you have installed Zend Server CE with MySQL, you should be able to type
the following into your browser to start 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.
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