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,
