mysql adminstrator tool inq

Robin01 · 10-19-2003, 02:18 PM

Hello everybody..

I'm looking for a mysq managment application to control mysql as a administrator and also one for the regular user where it would give them the basic rights to and remove create there own database managment...

basically what i'm looking for is something what an ISP would give there clients.. limited access to the mysq database interms of how many database one can create and the space they can use...sort of think

any help u can give me would be greatly appreciated

cli_man · 10-22-2003, 06:42 AM

What I use at my ISP is I setup webmin for me to administer mysql and create databases, then I also setup phpMyAdmin for the users to use. I am not sure that I would let a regular user create a database as that just sounds like trouble (getting your server hacked or otherwise messed up) Setup phpMyAdmin so it prompts for the username password for the database when you log in so that it will only show the databases that you have control over. I can send you what I used in my config if you wish.

Robin01 · 10-22-2003, 07:32 AM

HI cli_man

Thanks for the reply...
So, you recommend that i use webmin to administrate mysql and use phpmyadmin for the users.. sounds good...

Sure, please send the info....love to know more about it..

what are your opinions on mysqlyog.....

cli_man · 10-22-2003, 08:09 AM

I had never heard of it before, but thus far I have not needed to do anything that webmin couldn't do, now another thing you might want to think about if you are going to be running a mysql server is the backups, I am using mysql_backup.cgi and running it from cron twice a day.

http://worldcommunity.com/opensource

phpMyAdmin:
www.phpmyadmin.net

Webmin:
www.webmin.com

The one part of the config from phpMyAdmin that I thought might help you is in the file config.inc.php and this is my config

Code:

$cfgServers[1]['host'] = 'localhost';           // MySQL hostname
$cfgServers[1]['port'] = '';                    // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = true;             // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root';             // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = 'yourrootpass';                 // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'root';                // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = '';                // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = '';                 // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';                 // Verbose name for this host - leave blank to show the hostname

Robin01 · 10-22-2003, 01:58 PM

Hi,
Excelent.. thanks for the help...
I will look at those sites u gave me....

Just wondering if u could answer one more question..

Ipower, they host my webpage... to setup my own webpage they have a nice looking control panel i guess to manage you own website..you login and you have all these icons linking to varius other programs example phpmysql and file managment system.whats the name of a tool like that and do u know of a free one i can play with...

what i'm trying to do:
I purchased a pc just to learn linux and i'm going through the process of what an ISP would do to host a webpages what better way to learn linux right. so i'm trying to setup my linux box to what an isp wuld have...

cli_man · 10-22-2003, 02:07 PM

I don't know the names of them off hand, I have tried some and didn't like them as they tried to do too much, I personally like to find the best tool for each task, make sure they are all written in php and then write a front end to them for my own custom web control panel. I know there are some like you are talking about on freshmeat but I don't have the time or energy at the moment to find them :-)

www.freshmeat.net