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

Popular posts from this blog

400 Bad Request on Apache/PHP AddHandler wrapper -

Add email recipient to all new Trac tickets -

php - Change action and image src url's with jQuery -