You are here: Re: [PHP] Access Denied-phpMyAdmin « PHP « IT news, forums, messages
Re: [PHP] Access Denied-phpMyAdmin

Posted by Andre Dubuc on 04/16/05 14:39

On Saturday 16 April 2005 07:18 am, Mark Sargent wrote:
> Marek Kilimajer wrote:
> > Mark Sargent wrote:
> >> Hi All,
> >>
> >> I can access the database from the terminal on Fedora 3,
> >>
> >> [root@localhost 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
> >
> > Change $cfg['Servers'][$i]['connect_type'], I guess it should be
> > 'socket' in your setup
>
> Hi All,
>
> thanx, but, no difference. What I don't un, is, the setup is the same as
> another FC3 box, and it works. Cheers.
>
> Mark Sargent.


Mark,
I had the same problem. Try:

$cfg['PmaAbsoluteUri'] = '';

/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

.......

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP
address

Hth,
Andre

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация