LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-05-2009, 08:44 PM   #1
rocka
Member
 
Registered: Jan 2007
Posts: 30

Rep: Reputation: 0
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 :-)
 
Old 08-06-2009, 05:17 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
you havn't set a user with password in the phpmyadmin config file. That's what the message indicates, isn't it...
 
Old 08-06-2009, 07:25 AM   #3
rocka
Member
 
Registered: Jan 2007
Posts: 30

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by j-ray View Post
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....
 
Old 08-06-2009, 11:20 AM   #4
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
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...
 
Old 08-09-2009, 03:00 PM   #5
rocka
Member
 
Registered: Jan 2007
Posts: 30

Original Poster
Rep: Reputation: 0
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

Last edited by rocka; 08-09-2009 at 03:01 PM.
 
Old 08-10-2009, 07:43 AM   #6
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
if auth type 'cookie' doesnt work set that to config and supply a user + password
 
Old 08-10-2009, 05:17 PM   #7
rocka
Member
 
Registered: Jan 2007
Posts: 30

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by j-ray View Post
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.

Last edited by rocka; 08-13-2009 at 01:27 AM.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
phpmyadmin remote login M_C Linux - Server 3 04-28-2009 07:40 AM
can't login to phpmyadmin candyman123 Linux - Software 2 05-27-2006 08:18 PM
What is the defult phpmyadmin login badgerbox76 Linux - Newbie 2 01-08-2006 02:36 PM
phpmyadmin: can not login quarry_06 Linux - Software 1 04-27-2005 10:37 AM
phpmyadmin can't login vladimir@ares Linux - Software 2 12-31-2004 03:00 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

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

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration