LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Phpmyadmin login problem (https://www.linuxquestions.org/questions/linux-server-73/phpmyadmin-login-problem-745441/)

rocka 08-05-2009 08:44 PM
Phpmyadmin login problem
 
I am getting a:

Quote:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host (host), username (username) and password (password) in config.inc.php and check that they correspond to the information received from the MySQL server administrator
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Invalid server name for server 1. Check your configuration.
I tried logging in from home and also via the server (localhost) I can log in fine via shell (Putty). I recently changed my apache server to host virtual domains, dunno if that has something to do with it (haven't used phpmyadmin for long).

I am running Debian Etch.

Thanks for any help :-)

j-ray 08-06-2009 05:17 AM
you havn't set a user with password in the phpmyadmin config file. That's what the message indicates, isn't it...

rocka 08-06-2009 07:25 AM
Quote:
Originally Posted by j-ray (Post 3633377)
you havn't set a user with password in the phpmyadmin config file. That's what the message indicates, isn't it...
That's not the problem, I am using cookie as the auth type, and that's only neccacary if you are using config. And on the other hand, it used to work fine, but now it doesn't and I haven't removed any passwords from the config file....

j-ray 08-06-2009 11:20 AM
The messagecomplains about an invalid server name. Sth changed in this respect?
Or added a password for root user with mysqladmin?
Anyway you have to edit that config file correctly...

rocka 08-09-2009 03:00 PM
Thanks for trying to help out j-ray :-) I can't see anything wrong with the config file (but, I am a bit of a newbie) so maybe you can take a look and see:
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.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++;

// Uncomment to override the default configuration
//$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
//$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
//$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
//$cfg['Servers'][$i]['connect_type']  = 'socket';    // How to connect to MySQL server ('tcp' or 'socket')
//$cfg['Servers'][$i]['extension']    = 'mysql';    // The php MySQL extension to use ('mysql' or 'mysqli')
//$cfg['Servers'][$i]['compress']      = FALSE;      // Use compressed protocol for the MySQL connection
//                                                    // (requires PHP >= 4.3.0)
//$cfg['Servers'][$i]['controluser']  = '';          // MySQL control user settings
//                                                    // (this user must have read-only
//$cfg['Servers'][$i]['controlpass']  = '';          // access to the "mysql/user"
//                                                    // and "mysql/db" tables).
//                                                    // The controluser is also
//                                                    // used for all relational
//                                                    // features (pmadb)
//$cfg['Servers'][$i]['auth_type']    = 'cookie';    // Authentication method (config, http or cookie based)?
//$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
//$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
//                                                    // with 'config' auth_type)
//$cfg['Servers'][$i]['only_db']      = '';          // If set to a db-name, only
//                                                    // this db is displayed in left frame
//                                                    // It may also be an array of db-names, where sorting order is relevant.
//$cfg['Servers'][$i]['verbose']      = '';          // Verbose name for this host - leave blank to show the hostname
//
//$cfg['Servers'][$i]['pmadb']        = 'phpmyadmin';// Database used for Relation, Bookmark and PDF Features
//                                                    // (see scripts/create_tables.sql)
//                                                    //  - leave blank for no support
//                                                    //    DEFAULT: 'phpmyadmin'
//$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';// Bookmark table
//                                                    //  - leave blank for no bookmark support
//                                                    //    DEFAULT: 'pma_bookmark'
//$cfg['Servers'][$i]['relation']      = 'pma_relation';// table to describe the relation between links (see doc)
//                                                    //  - leave blank for no relation-links support
//                                                    //    DEFAULT: 'pma_relation'
//$cfg['Servers'][$i]['table_info']    = 'pma_table_info';// table to describe the display fields
//                                                    //  - leave blank for no display fields support
//                                                    //    DEFAULT: 'pma_table_info'
//$cfg['Servers'][$i]['table_coords']  = 'pma_table_coords';// table to describe the tables position for the PDF schema
//                                                    //  - leave blank for no PDF schema support
//                                                    //    DEFAULT: 'pma_table_coords'
//$cfg['Servers'][$i]['pdf_pages']    = 'pma_pdf_pages';// table to describe pages of relationpdf
//                                                    //  - leave blank if you don't want to use this
//                                                    //    DEFAULT: 'pma_pdf_pages'
//$cfg['Servers'][$i]['column_info']  = 'pma_column_info';// table to store column information
//                                                    //  - leave blank for no column comments/mime types
//                                                    //    DEFAULT: 'pma_column_info'
//$cfg['Servers'][$i]['history']      = 'pma_history';// table to store SQL history
//                                                    //  - leave blank for no SQL query history
//                                                    //    DEFAULT: 'pma_history'
//$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
//                                                    // are up to date. This prevents compatibility
//                                                    // checks and thereby increases performance.
//$cfg['Servers'][$i]['AllowRoot']    = TRUE;        // whether to allow root login
//$cfg['Servers'][$i]['AllowDeny']['order']          // Host authentication order, leave blank to not use
//                                    = '';
//$cfg['Servers'][$i]['AllowDeny']['rules']          // Host authentication rules, leave blank for defaults
//                                    = array();

?>
And I do have a password set for the root user in mysql. Below is a screenshot of the error (unfortuntely partly in Norwegian).
http://dump.ninjapirat.org/files/phpmyadminerror.jpg

j-ray 08-10-2009 07:43 AM
if auth type 'cookie' doesnt work set that to config and supply a user + password

rocka 08-10-2009 05:17 PM
Quote:
Originally Posted by j-ray (Post 3637739)
if auth type 'cookie' doesnt work set that to config and supply a user + password
Tried that, didn't help :-(

Edit: I used the setup script in the script folder to create a new config file and that solved it. When I ran the script it was complaining that no server could be found, you probably want to add one.


All times are GMT -5. The time now is 07:41 PM.