Geek Answers Handbook

I install phpmyadmin on my ubuntu but its not working

I install phpmyadmin on my ubuntu 10.4 but it cannot be logged in

this is the contents of the file /etc/phpmyadmin/config.inc.php

if we enter the password # 2002 Unable to login to MySQL server

if we do not enter a password Logging in without a password is prohibited by the configuration (see AllowNoPassword)

Can you help me?

/** * Debian local configuration file * * This file overrides the settings made by phpMyAdmin interactive setup * utility. * * For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz * * NOTE: do not add security sensitive data to this file (like passwords) * unless you really know what you're doing. If you do, any user that can * run PHP or CGI on your webserver will be able to read them. If you still * want to do this, make sure to properly secure the access to this file * (also on the filesystem level). */

/** * Server(s) configuration */ $i = 0; // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can disable a server config entry by setting host to ''. $i++;

/** * Read configuration from dbconfig-common * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin */ if (is_readable('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); }

/* Configure according to 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 your server has it */ $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Optional: User for advanced features */ $cfg['Servers'][$i]['controluser'] = $dbuser;

$cfg ['Servers'] [$ i] ['controlpass'] = $dbpass; /* : phpMyAdmin */ $ 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 the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */

//$cfg ['Servers'] [$ i] ['AllowNoPassword'] = TRUE;

 /* Advance to next server for rest of config */ $i++;

}

/* */ // $cfg ['Servers'] [$ i] ['auth_type'] = 'cookie'; /* */ // $cfg ['Servers'] [$ i] ['host'] = 'localhost'; // $cfg ['Servers'] [$ i] ['connect_type'] = 'tcp'; // $cfg ['Servers'] [$ i] ['compress'] = false; /* mysqli, / // $cfg ['Servers'] [$ i] ['extension'] = 'mysql'; /: / // $cfg ['Servers'] [$ i] ['controluser'] = 'pma'; // $cfg ['Servers'] [$ i] ['controlpass'] = 'pmapass'; /: phpMyAdmin */ // $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'; /* , * . */ // $cfg ['Servers'] [$ i] ['AllowNoPassword'] = TRUE;

/* * */

/* * / */ $ cfg ['UploadDir'] = ''; $ cfg ['SaveDir'] = '';

code>
+4
source share
2 answers

If you use an empty password:

 // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

It is safe if you are in an isolated development virtual machine, otherwise set a password.

+4
source

I had the same problem, but I think I might have sorted it out.

Solution: Assuming you used the setup.php file to install phpMyAdmin, once you have completed the mysql server setup and you saved the changes, copy the config.inc.php file automatically created in config / folder to phpMyAdmin. Make sure it is write-protected and removes the configuration / folder. Then refresh your browser.

Worked for me .. I hope this works for you too.

Greetings.

+2
source

More articles:


All Articles