Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

PHPMyAdmin Login Error

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

PHPMyAdmin Login Error

Postby jetpacmidge » Sun Aug 27, 2006 9:18 am

I am using Apache Web Server v1.3, PHP v5.1.3 and MYSQL v 5.0.21 and installing PHPMyAdmin v 2.8.1 I have also installed MYSQL administrator and MYSQL Query on my PC and works with the user name and password to access the server.

When I access PHPMyAdmin the following msg occurs :-

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Copy of config.inc.php script ...

Code: Select all
<?php
$cfg['PmaAbsoluteUri'] = 'http://127.0.0.1/phpMyAdmin/';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['blowfish_secret']='southampton';
?>


I have included end excluded the user name , controlpass and password in the script but still get the same result. I have created the folder 'pma' and moved the files into the 'pma' folder and have performed the following on MYSQL Command Client:-

Code: Select all
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

GRANT SELECT (

Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,

Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,

File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,

Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,

Execute_priv, Repl_slave_priv, Repl_client_priv

) ON mysql.user TO 'pma'@'localhost';

GRANT SELECT ON mysql.db TO 'pma'@'localhost';

GRANT SELECT ON mysql.host TO 'pma'@'localhost';

GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)

ON mysql.tables_priv TO 'pma'@'localhost';


When I open up a MYSQL command client I always have to type in the password for the user.

Any help to resolve my problem would be grateful.

Thanks.

Rgds,

:)
jetpacmidge
New php-forum User
New php-forum User
 
Posts: 2
Joined: Fri Jan 14, 2005 7:00 am
Location: Reading, Berkshire

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.