This is phpMyAdmin general not SME specific.
phpMyAdmin, at it's simplest best (single user) requires a MySQL user that has all privileges to connect.
So, at the shell,
mysql -uroot
now, at the mysql> prompt
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> quit
Now we add the above user (monty) and password (some_pass) to the phpmyadmin config file - config.inc.php
It maybe located in this directory..
/opt/administration/phpmyadminmulti
The parts to edit are
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
Between the ' ' place config monty some_pass
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'monty'; // MySQL user
$cfg['Servers'][$i]['password'] = 'some_pass'; // MySQL password (only needed
Save and now go to your phpmysql url.
It is now setup in the most basic way.
Now that it working, create another user that only you know.
Exit out and edit config.inc.php to how it's shown below. cookie blank blank
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
Also, ensure this line is at the top somewhere...
$cfg['blowfish_secret'] = 'xf5g4+6x4g6n4x+fg4n+x4+9n-xg-h*-+-*-*+89gx-+8n-xgh-+x8-gd-xdg4n+-xgx7*g+-nx-g7n+';
Save and exit and return to your pma url.
Now login as the user you just created and delete the monty dude
You should now have something looking like this..
My phpMyAdmin