¿Í·þµç»°£º029-85795818

ÈçºÎ¹ÜÀíMySQLÊý¾Ý¿â£¿

A£ºMYSQLÊý¾Ý¿âµÄ¹ÜÀí·½Ê½ÈçÏÂ:

 

Ê×ÏÈÏÂÔØPhpMyAdminÈí¼þ£¬½«´ËÎļþ°ü½âѹ£¬ÕÒµ½ÆäÖеÄÒ»¸öÎļþ:config.inc.php(»òÕßÈçconfig.*µÈ, ¸ÃÎļþÃû»áÒòphpmyadmin°æ±¾²»Í¬, ¶øÓÐËù²î±ð)
ÐÞ¸ÄÒÔÏÂÅäÖÃ:
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfgServers[1]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[1]['stduser'] = ''; // MySQL standard user settings (this user must have read-only
$cfgServers[1]['stdpass'] = ''; // access to the "mysql/user" and "mysql/db" tables)
$cfgServers[1]['adv_auth'] = FALSE; // Use advanced authentication?
$cfgServers[1]['user'] = 'alintest'; // MySQL user
$cfgServers[1]['password'] = 'alintest'; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = 'alintest'; // If set to a db-name, only this db is displayed at left frame

È»ºóÄúftpµ½ÄúµÄÍøÕ¾, ÔÚwwwrootϽ¨Á¢Ò»¸öĿ¼phpmyadmin, °ÑphpmyadminËùÓÐÎļþÉÏ´«µ½¸ÃĿ¼Ï£¬·ÃÎÊhttp://www.yourdomain.com/phpmyadmin, ¼´¿É¶ÔÊý¾Ý¿â½øÐйÜÀí¡£
ÔÚ½¨ºÃÊý¾Ý¿âºó, Îñ±Ø½«ÕâЩphpadminµÄÎļþÒÆ×ß, ·ñÔòÈκÎÈ˶¼¿ÉÒÔ¹ÜÀíÓû§µÄÊý¾Ý¿â¡£

ÈôÊDzÉÓÃÓÃphp±à³Ì, ¿ÉÒÔÓÃÒÔÏ´úÂëÁ¬½ÓÊý¾Ý¿â: 
<?php
$database = "alintest";
$user = "alintest";
$password = "alintest";
$link = mysql_connect ("localhost", $user, $password)
or die ("Could not connect");
 mysql_select_db($database, $link);

 ..........

mysql_close ($link);
?>

Èç¹û²ÉÓÃperl±à³Ì, ¿ÉÒÔÓÃÈçÏ´úÂëÁ¬½ÓÊý¾Ý¿â:
#!/usr/bin/perl

use DBI;
$database = "alintest";
$user = "alintest";
$password = "alintest";
$dbh = DBI->connect("DBI:mysql:$database", $user, $password);

..........

$rc = $dbh->disconnect;

Èç¹ûÐèÒªmod_perlµÄ¹¦Äܵϰ, ¿É·ÃÎÊhttp://www.youdromain.com/perl/yourcgi.cgi
°ÑÆÕͨµÄ/cgi-bin/¸Ä³É/perl/£»
¶ømod_perlµÄCGIĿ¼ºÍÆÕͨCGIĿ¼ÊÇÒ»ÑùµÄ, ¶¼ÔÚ wwwroot/cgi-binÏÂ.

Àý£º°ÑÒ»¸öenv.cgiµÄ³ÌÐòÉÏÔØµ½ wwwroot/cgi-binĿ¼Ï£º
Èç¹ûÓÃÆÕͨµÄ·½Ê½·ÃÎÊ£¬ ÄÇôURLΪ£ºhttp://www.yourdomain.com/cgi-bin/env.cgi
Èç¹ûÓÃmod_perlµÄ·½Ê½·ÃÎÊ£¬ÄÇôURLΪ£ºhttp://www.yourdomain.com/perl/env.cgi

Êý¾ÝÍø ©2014- All Rights Reserved. ±¸°¸ºÅ£ºÉÂICP±¸14006389ºÅ-4