* If you wish to enable local network access, you can do so via:
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
service mysqld restart
This will enable port 3306
* If you wish to have developers access your database:
1. Create an extra account e.q. [dba] with all priviliges for admin usage
2. Create a control useraccount [pma] and give select rights to mysql.users and so on:
For 'HTTP' and 'cookie' modes, phpMyAdmin needs a controluser that has only the SELECT privilege on the mysql.user (all columns except "Password"), mysql.db (all columns) & mysql.tables_priv (all columns except "Grantor" & "Timestamp") tables.
You must specify the details for the controluser in the config.inc.php file under the $cfg['Servers'][$i]['controluser']& $cfg['Servers'][$i]['controlpass'] settings.
2. Change config.inc.php in /etc/e-smith/templates/opt/administration/phpmyadmin
- set auth_type to http
- set the user to ''
- set the password to ''
- fill in the created controluser and password
3. Change httpd.conf in /etc/e-smith/templates/etc/httpd/conf/httpd.conf/ the file 86PhpmyadminAlias
- add # to the following 4 lines
# AuthName "phpMyAdmin"
# AuthType Basic
# AuthExternal pwauth
# require user admin
# Satisfy All
restart the httpd:
service httpd restart
4. go to
https://myserver/phpmyadminfill in your dba username and password
create databases users and specific rights
developers and system specialist can now log on to the database using specific users with specific rights.
Good luck,
Lars
5 Replies
4224 Views