phpmyadmin

5 posts / 0 new
Last post
#1 Sat, 09/13/2008 - 07:06
Joe
Joe's picture

phpmyadmin

i recently uploaded the flash version of it and i like the way it works. http://www.tufat.com/s_flash_phpmyadmin.htm is where to get it

just wanted to share this info

Mon, 06/25/2007 - 10:32
MichaelGibbons

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

Mon, 06/25/2007 - 12:38 (Reply to #2)
ah...lifes...good

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!

Mon, 06/25/2007 - 20:49 (Reply to #3)
Joe
Joe's picture

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!

Mon, 06/25/2007 - 11:52
ah...lifes...good

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!

Topic locked