Required tools:
1: Perl script parsing tool:
Http://www.activestate.com/activeperl/
2: Perl script for mysqlreportCode:
Http://hackmysql.com/mysqlreport
3. Apache:
Http://httpd.apache.org/
Steps:
1,WindowsInstallActivePerl(I use a ActivePerl-5.10.1)
2,Install and configureApache;EnableCGIModule(Enabled by default)
3,SetMysqlreportAdd the suffix ". PL" to the script and put it in the specified Apache directory (Cgi-bin);
4. open Perl (you can directly enter "ppm" in cmd or open it in the "Start" menu), open it, and click "View All packages ", find "DBD-mysql", right-click "Install", and click "Run marked actions" in the upper menu of Perl ", to install "DBD-mysql" (if "DBD-mysql" is already installed, skip this step)
5. ModifyMysqlreport. Pl
First line modification:
#! D:/perl/bin/perl.exe-W
ModifyMysqlreportOf
The73 74 75 76 77Line
$ Mycnf {'host '}= "127.0.0.1 ";
$ Mycnf {'Port '}= "3306"; # MySQL Port
$ Mycnf {'socket'} =$ Op {'socket '} If have_op 'socket ';
$ Mycnf {'user '}= "Root"; # MySQL Username
$ Mycnf {'pass '}= "Admin"; # special characters are required when setting the MySQL user name, password, and password.
OK. Now you can access http: // 127.0.0.1/cgi-bin/mysqlreport. pl.