php - i install phpmyadmin on my ubuntu but its not working -
i install phpmyadmin on ubuntu 10.4 can't login
this content of /etc/phpmyadmin/config.inc.php file
if enter password #2002 cannot log in mysql server
if not enter password login without password forbidden configuration (see allownopassword)
can me
/** * debian local configuration file * * file overrides settings made phpmyadmin interactive setup * utility. * * example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz * * note: not add security sensitive data file (like passwords) * unless know you're doing. if do, user can * run php or cgi on webserver able read them. if still * want this, make sure secure access file * (also on filesystem level). */
/** * server(s) configuration */ $i = 0; // $cfg['servers'] array starts $cfg['servers'][1]. not use $cfg['servers'][0]. // can disable server config entry setting host ''. $i++;
/** * read configuration dbconfig-common * can regenerate using: dpkg-reconfigure -plow phpmyadmin */ if (is_readable('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); }
/* configure according dbconfig-common if enabled / if (!empty($dbname)) { / authentication type */ $cfg['servers'][$i]['auth_type'] = 'cookie'; /* server parameters */ if (empty($dbserver)) $dbserver = 'localhost'; $cfg['servers'][$i]['host'] = $dbserver;
if (!empty($dbport)) { $cfg['servers'][$i]['connect_type'] = 'tcp'; $cfg['servers'][$i]['port'] = $dbport; } //$cfg['servers'][$i]['compress'] = false; /* select mysqli if server has */ $cfg['servers'][$i]['extension'] = 'mysqli'; /* optional: user advanced features */ $cfg['servers'][$i]['controluser'] = $dbuser;
$cfg['servers'][$i]['controlpass'] = $dbpass; /* optional: advanced phpmyadmin features */ $cfg['servers'][$i]['pmadb'] = $dbname; $cfg['servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['servers'][$i]['relation'] = 'pma_relation'; $cfg['servers'][$i]['table_info'] = 'pma_table_info'; $cfg['servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['servers'][$i]['column_info'] = 'pma_column_info'; $cfg['servers'][$i]['history'] = 'pma_history'; $cfg['servers'][$i]['designer_coords'] = 'pma_designer_coords';
/* uncomment following enable logging in passwordless accounts, * after taking note of associated security risks. */
// $cfg['servers'][$i]['allownopassword'] = true;
/* advance next server rest of config */ $i++;
}
/* authentication type */ //$cfg['servers'][$i]['auth_type'] = 'cookie'; /* server parameters */ //$cfg['servers'][$i]['host'] = 'localhost'; //$cfg['servers'][$i]['connect_type'] = 'tcp'; //$cfg['servers'][$i]['compress'] = false; /* select mysqli if server has / //$cfg['servers'][$i]['extension'] = 'mysql'; / optional: user advanced features / // $cfg['servers'][$i]['controluser'] = 'pma'; // $cfg['servers'][$i]['controlpass'] = 'pmapass'; / optional: advanced phpmyadmin features */ // $cfg['servers'][$i]['pmadb'] = 'phpmyadmin'; // $cfg['servers'][$i]['bookmarktable'] = 'pma_bookmark'; // $cfg['servers'][$i]['relation'] = 'pma_relation'; // $cfg['servers'][$i]['table_info'] = 'pma_table_info'; // $cfg['servers'][$i]['table_coords'] = 'pma_table_coords'; // $cfg['servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // $cfg['servers'][$i]['column_info'] = 'pma_column_info'; // $cfg['servers'][$i]['history'] = 'pma_history'; // $cfg['servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* uncomment following enable logging in passwordless accounts, * after taking note of associated security risks. */ // $cfg['servers'][$i]['allownopassword'] = true;
/* * end of servers configuration */
/* * directories saving/loading files server */ $cfg['uploaddir'] = ''; $cfg['savedir'] = '';
if using blank password uncomment:
// $cfg['servers'][$i]['allownopassword'] = true; it safe if inside isolated development vm, otherwise set password.
Comments
Post a Comment