These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for phpmyadmin on the new forum.
Web Hosting and Cloud Computing Control Panels
Hi I have a simular problem, i have phpmyadmin installed and it works fine with webmin but i can get any of my clients to connect to the database unless i give them the root password, which i am not willing to do, so only customers that have a preinstalled application are able to have databases also from the phpmyadmin page if you go to login and enter nothing as the password it logs you in.
I would be grateful for any suggestions
If you want the ability to create MySQL databases and users on the fly, purchase Virtualmin Pro. It is cheap while it is still in early adopter phase!
Not to discourage anyone buying Virtualmin Pro, but Virtualmin GPL can also create MySQL and PostgreSQL accounts for virtual server account holders, just like Pro (this is one area where there is no difference between the two products).
--
Check out the forum guidelines!
Only MySQL users have access to MySQL databases via phpMyAdmin.
root obviously is a MySQL user by default (but no password is given to the root user so remember to enter one!). Of course, you shouldn't give anyone your root login!
Consult the MySQL manual at http://dev.mysql.com/doc/ to learn how to create MySQL users via command line. You can create a MySQL user login for each of your clients if you like. You need to limit user privileges (i.e. what MySQL function they can use, which database they have access to etc.)
Consult the MySQL manual.
It is better to use
$cfg['Servers'][$i]['auth_type'] = 'cookie';
for phpMyAdmin. It is a bad idea to insert root and root password in the config file, and allow automatic login via phpMyAdmin. Anyone accessing http://mydomain.com/phpMyAdmin will be able to access your databases!