phpMyAdmin

[treadstone]

I have SuSE 10.3. I installed apache, mysql and php. I also installed phpMyAdmin. When I go to http://localhost/phpMyAdmin/, I get following error:


Welcome to phpMyAdmin 2.11.9

Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Error

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

I came across one solution: that of editing config.inc.php in phpMyAdmin/libraries and entering the root password in $cfg['Servers'][$i]['password'] = '';

Is this mehod secure?? Because this way, I will have to give up my mysql root password. And what if I have another mysql user such as 'admin' with same permissions as 'root'.

[darkblue]

No it is not safe to give your password to config.inc.php file unless and untill it is a productive server.
try this:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

or

$cfg['Servers'][$i]['auth_type'] = 'config';

it probably should give a pop up asking for username and password, make sure ur controluser and controlpass is commented...

// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';

Keep updating because am working on similar thing and so far it worked absolutely worth a treat on fedora but having hard time in ubuntu... tryin to fig out more files and configurations, for best practice make a back file of existing config.inc.php and then play with the main file!

[treadstone]

thanks darkblue, this works!!