Database Reference
In-Depth Information
Figure 16.7
Query results via the web.
need a specific client running to enable you to administer your databases. This freedom
obviously comes with some problems such as security issues. The README file included
with the package explains how to password protect PHPMyAdmin to begin to secure your
installation.
You can see from the screen shown in Figure 16.5 that you can select a database to work
with or create a new one. You can also see that our mysqlfast database that we created in this
book is in the list of databases. Selecting this database gives the complex screen shown in
Figure 16.6.
This screen lists all of the tables that are in my mysqlfast database. You can access all
parts of your MySQL data from this interface. One useful part is the SQL tab. Clicking on
this will allow you to enter a SQL query directly into the web interface. Figure 16.7 shows
the results of the following query:
SELECT *
FROM Log;
You will see that Figure 16.7 shows the results of the query, as well as giving you the
options to go and edit some of the data that has been returned.
PHPMyAdmin is a great tool that I was very pleased to discover. As long as you consider
the possible security implications of using it, you will find it another invaluable aid in your
use of MySQL.
