LAMP impossible de se connecter sur phpmyadmin

Ton problème viendrait plutôt de mysql alors, parce que si tu n’as pas accès en ligne de commande, phpmyadmin sera dans le même cas.

Toujours est-il que tu peux regarder dans ton fichier config.inc.php

cat /etc/phpmyadmin/config.ini.php

et chercher la ligne user et password pour être sur.

`daniel@daniel-linux:~$ sudo cat /etc/phpmyadmin/config.ini.php
[sudo] Mot de passe de daniel :
cat: /etc/phpmyadmin/config.ini.php: Aucun fichier ou dossier de ce type
daniel@daniel-linux:~$

`

Excuse-moi c’est config.inc.php. C’est la fatigue. :pensive:

Désolé je sais pas comment faire CODE

<?php /** * 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.sample.inc.php * or * /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php * * 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). */ if (!function_exists('check_file_access')) { function check_file_access($path) { if (is_readable($path)) { return true; } else { error_log( 'phpmyadmin: Failed to load ' . $path . ' Check group www-data has read access and open_basedir restrictions.' ); return false; } } } // Load secret generated on postinst if (check_file_access('/var/lib/phpmyadmin/blowfish_secret.inc.php')) { require('/var/lib/phpmyadmin/blowfish_secret.inc.php'); } // Load autoconf local config if (check_file_access('/var/lib/phpmyadmin/config.inc.php')) { require('/var/lib/phpmyadmin/config.inc.php'); } /** * 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 (check_file_access('/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) || $dbserver != 'localhost') { $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; /* 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]['table_uiprefs'] = 'pma__table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; $cfg['Servers'][$i]['users'] = 'pma__users'; $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; /* 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++; } /* 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; /* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; /** * phpMyAdmin configuration storage settings. */ /* User used to manipulate with storage */ // $cfg['Servers'][$i]['controlhost'] = ''; // $cfg['Servers'][$i]['controlport'] = ''; // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Storage database and tables */ // $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]['table_uiprefs'] = 'pma__table_uiprefs'; // $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; // $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; // $cfg['Servers'][$i]['recent'] = 'pma__recent'; // $cfg['Servers'][$i]['favorite'] = 'pma__favorite'; // $cfg['Servers'][$i]['users'] = 'pma__users'; // $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; // $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; // $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; // $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; // $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; // $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; /* Contrib / Swekey authentication */ // $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf'; /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; /* Support additional configurations */ foreach (glob('/etc/phpmyadmin/conf.d/*.php') as $filename) { include($filename); }

Entoure ton code de trois fois ` au début et trois fois à la fin (AltGr+7)

Couché ??
Moi vais pas tarder (3H)

Non toujours là. :slight_smile:

De toute façon le problème ne vient pas de phpmyadmin donc pour l’instant mets le de côté, ou encore mieux désinstalle le avec

sudo apt-get purge phpmyadmin

On va reprendre avec mysql.

Commence par stopper le processus (tout en root)

/etc/init.d/mysql stop

puis lance mysqld_safe

mysqld_safe --skip-grant-tables --skip-networking &

Tu te connectes à mysql à la BDD mysql

mysql mysql

puis tu changes ton mot de passe ‘mdp_a_changer’

UPDATE user SET Password=password('mdp_a_changer') WHERE User="root" AND Host="localhost";

tu quittes my sql

quit

tu arrêtes le processus mysqld_safe

mysqladmin shutdown

et tu relances mysql

/etc/init.d/mysql restart

et essayes de te connecter avec le mot de passe que tu as changé.

Vais essayer !
Essaie de mettre des commandes complètes avec sudo… souvent j’oublie et je perds du temps.
J’essaie çà

coincé


UPDATE user SET Password=password('glop') WHERE User="root" AND Host="localhost";
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

je suis toujours en prompt mysql>

DESCRIBE user;

Password n’est pas reconnu, étrange.

je tape DESCRIBE user; ?

DESCRIBE user;
^C
mysql> 


Oui ça listera les field.

pas marché ?

Non, ça doit te lister les champs de la DB mysql.

Fais

USE mysql;

et

DESCRIBE user;
mysql> USE mysql;
Database changed
mysql> DESCRIBE user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                  | Type                              | Null | Key | Default               | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                   | char(60)                          | NO   | PRI |                       |       |
| User                   | char(32)                          | NO   | PRI |                       |       |
| Select_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Insert_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Update_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Delete_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Create_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Drop_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Reload_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Shutdown_priv          | enum('N','Y')                     | NO   |     | N                     |       |
| Process_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| File_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Grant_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| References_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Index_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Show_db_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Super_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tmp_table_priv  | enum('N','Y')                     | NO   |     | N                     |       |
| Lock_tables_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Execute_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_slave_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_client_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Create_view_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Show_view_priv         | enum('N','Y')                     | NO   |     | N                     |       |
| Create_routine_priv    | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_routine_priv     | enum('N','Y')                     | NO   |     | N                     |       |
| Create_user_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Event_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Trigger_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tablespace_priv | enum('N','Y')                     | NO   |     | N                     |       |
| ssl_type               | enum('','ANY','X509','SPECIFIED') | NO   |     |                       |       |
| ssl_cipher             | blob                              | NO   |     | NULL                  |       |
| x509_issuer            | blob                              | NO   |     | NULL                  |       |
| x509_subject           | blob                              | NO   |     | NULL                  |       |
| max_questions          | int(11) unsigned                  | NO   |     | 0                     |       |
| max_updates            | int(11) unsigned                  | NO   |     | 0                     |       |
| max_connections        | int(11) unsigned                  | NO   |     | 0                     |       |
| max_user_connections   | int(11) unsigned                  | NO   |     | 0                     |       |
| plugin                 | char(64)                          | NO   |     | mysql_native_password |       |
| authentication_string  | text                              | YES  |     | NULL                  |       |
| password_expired       | enum('N','Y')                     | NO   |     | N                     |       |
| password_last_changed  | timestamp                         | YES  |     | NULL                  |       |
| password_lifetime      | smallint(5) unsigned              | YES  |     | NULL                  |       |
| account_locked         | enum('N','Y')                     | NO   |     | N                     |       |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
45 rows in set (0,00 sec)

mysql> 


Apparemment le champ a changé dans les dernières versions… Je ne savais pas.

UPDATE user SET authentication_string=password('glop') WHERE User="root" AND Host="localhost";

Après que tu es continué la manip’ du dessus tu devrai pouvoir te reconnecter sans problème avec les identifiants.

Edit : Juste une question que j’aurai du te poser au début, tu as installé lamp-server ou tu es passé par les paquets manuellement ?

1 J'aime

sorry
j’ai pas pu répondre => trop de posts premier jour
j’ai créé un autre compte

Tout a fonctionné Mille merci

Tout est ok merci
J’ai pas pu te remercier, les nouveaux sont bloqués à 22 messages le premier jour. (je suis devenu fou !)
Phpmyadmin fonctionne aussi.
Je vais installer un Wordpress pour vérifier tout çà mais il n’y a pas de raison.
Tes compétences et ta gentillesse m’ont impressionné !
Je vais revenir ces jours ci et j’espère t’y retrouver :wink:
Faudrait que je configure mon réseau (avec Windows 7)
So long…

Du coup ton problème initial avec phpmyadmin est aussi réglé ?