For security reasons, LiveConfig doesn’t install phpMyAdmin by default. But you may install phpMyAdmin manually or through the AppInstaller in any webspace and make it available to all of your users.
With Single Sign-On you can log on to phpMyAdmin directly from LiveConfig without entering your database credentials. To avoid unsafe submission through the users’ browser, this script transmits them server-side. So the user also can’t see the currently configured database password.
Important: LiveConfig never saves passwords that aren’t required any more. When creating a new MySQL database or changing its password, LiveConfig deletes this password immediately after execution. If single sign-on is enabled in LiveConfig, these passwords remain in the LiveConfig database (encrypted, of course). Because of this, if single sign-on is enabled for an existing MySQL database its password must be entered (or a new password must be set).
download the file lc-sso.php and save it into the root directory of your phpMyAdmin installation
edit the file
config.inc.php and add a new server:
$i++; $cfg['Servers'][$i]['auth_type'] = 'signon'; $cfg['Servers'][$i]['host'] = 'SingleSignOn'; $cfg['Servers'][$i]['SignonSession'] = 'SignonSession'; $cfg['Servers'][$i]['SignonURL'] = 'index.php'; $cfg['Servers'][$i]['LogoutURL'] = 'lc-sso.php?logout';
Remember the number (value of
$i) of this new server entry!
edit the file
lc-sso.php and set
PMA_SIGNON_INDEX to the server id (
$i) of the previously added entry
if you have changed the
SignonSession name in
config.inc.php, also adjust
if you’re running LiveConfig with a SSL certificate of a trusted CA, you should set
finally log in as admin to LiveConfig, go to Servers -> Server Management -> Databases. Edit the MySQL options and enable the Single Sign-On checkbox there. A link to your phpMyAdmin installation must also be configured of course.
Normal LiveConfig users then may enable single sign-on for new and existing databases at Hosting -> Databases. With existing databases, the password must be provided. The link to phpMyAdmin contains a small key icon to symbolize that SSO is enabled.