Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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).
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....
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...
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();
?>
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.