Chapter 12 . Security 317 Note Using these
Chapter 12 . Security 317 Note Using these pages, the administrator can monitor the MySQL server s performance. This can save time and make it so other administrators can monitor the MySQL server without having to know the backend commands for MySQL administration. You should protect these Web pages via effective passwords; unauthorized access to them is especially dangerous. A requirement for viewing dynamic monitoring Web page on a network is to get a Web server running. This does not have to be the same physical machine as the one that houses the MySQL server. If the machines are separate you will need to automatically transfer the resulting output from the MySQL commands to the Web server. The following example processes are performed in Linux, running an Apache Web server. (Your version of Linux may vary slightly from the one shown here.) Creating the fake database The steps involved to produce a MySQL monitoring Web page are as follows: 1. Make a publicly available directory to hold HTML output, using this command: mkdir mysqlmonitor 2. Create a password method to prevent unauthorized access to the directory; the .htaccessfile is a useful example, and Figure 12-8 shows how to create one. Figure 12-8: Creating a .htaccess file within the mysqlmonitor directory to prevent unauthorized access to the MySQL monitoring Web pages. 3. With the .htaccessfile in place, you must create a password file to accompany the .htaccessfile. The name of the file is specified in the .htaccess file.
Please visit Domain Name Hosting services for high quality webhost to host and run your jsp applications.