LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 10-19-2003, 02:18 PM   #1
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
mysql adminstrator tool inq


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
 
Old 10-22-2003, 06:42 AM   #2
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
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.
 
Old 10-22-2003, 07:32 AM   #3
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Original Poster
Rep: Reputation: 15
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.....
 
Old 10-22-2003, 08:09 AM   #4
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
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
 
Old 10-22-2003, 01:58 PM   #5
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Original Poster
Rep: Reputation: 15
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...
 
Old 10-22-2003, 02:07 PM   #6
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
tool to format report output from mysql? alar Linux - General 0 08-03-2004 08:16 PM
postfix inq. Robin01 Linux - Newbie 1 12-27-2003 07:25 PM
bash_profile inq Robin01 Linux - General 1 12-10-2003 09:30 PM
mysql importing inq Robin01 Linux - Newbie 1 11-30-2003 09:12 AM
mysql installation inq Robin01 Linux - Newbie 1 10-06-2003 10:27 PM


All times are GMT -5. The time now is 07:31 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration