PHPMyAdmin Login Error

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

Moderators: macek, egami, gesf

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

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 :-

MySQL said:

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

Copy of script ...

Code: Select all

$cfg['PmaAbsoluteUri'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['password'] = '';

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';


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 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.




Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 1 guest