Hi Mark: First of all, have you commented out the line "Allow networking" in the /etc/mysql/my.cnf?. If not, put a "#" before this line. Probably this error is because of this directive.
Second, assuming that you have created the phpMyAdmin database with the script provided, and assuming that you have set the $cfg['Servers'][$i]['auth_type'] variable to "http", in the config.inc.php file, have you set the variable $cfg['Servers'][$i]['controluser'] with the proper user and have you given the proper privileges to this user?. And third, check the privileges of the root user (for the localhost and other hosts). Probably the privileges are set to the localhost, but not to remote hosts, so you cannot acces from there. I hope this clues are helpful for you. Best regards, Alvaro ----- Original Message ----- > > From: "Mark Sargent" <[EMAIL PROTECTED]> > > To: <mysql@lists.mysql.com> > > Sent: Saturday, April 16, 2005 5:08 AM > > Subject: Access denied-phpMyAdmin > > > > > > > Hi All, > > > > > > I can access the database from the terminal on Fedora 3, > > > > > > [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p > > > Enter password: > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > Your MySQL connection id is 2 to server version: 4.1.10a-standard > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > mysql> > > > > > > But, get the following error when accessing via phpMyAdmin with user as > > > root and the correct password, > > > > > > phpMyAdmin tried to connect to the MySQL server, and the server rejected > > > the connection. You should check the host, username and password in > > > config.inc.php and make sure that they correspond to the information > > > given by the administrator of the MySQL server. > > > > > > |#1045 - Access denied for user 'root'@'localhost' (using password: YES) > > > > > > > > > I don't understand this. What have I missed..? > > > > > > $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/'; > > > > > > $cfg['Servers'][$i]['user'] = 'root'; // MySQL user > > > $cfg['Servers'][$i]['password'] = 'password is correct'; > > > // MySQL password (only needed > > > > > > Cheers. > > > > > > Mark Sargent. > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
