Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Robert Heaton on August 21, 2001, 06:45:46 PM

Title: Managing MySQL
Post by: Robert Heaton on August 21, 2001, 06:45:46 PM

Anyone know a MySQL manager, for creating/viewing current SQL databases??
Is there an RPM that slots into the e-smith manager???

Thanks is advance,
Rob.

Title: Re: Managing MySQL
Post by: Bill Scobie on August 21, 2001, 06:53:30 PM

PHPMyAdmin is what you are looking for, I think. And, look for it at http://www.e-smith.org/contrib/rpm-index/RPM-e-smith-phpmyadmin-0.2-3.noarch.html

Title: Re: Managing MySQL
Post by: Robert Heaton on August 21, 2001, 09:21:30 PM

Thanks Bill

Rob

Title: Re: Managing MySQL
Post by: Sidney on August 21, 2001, 09:38:24 PM

Hello,
  how do you manage Mysql outside of the network?

Title: Re: Managing MySQL
Post by: Craig Bursey on August 22, 2001, 04:34:39 PM

You install PhpMyAdmin in an IBAY with a password for the internet.  Works for me :-)

Craig

Title: Re: Managing MySQL
Post by: Noah on August 23, 2001, 06:24:43 PM

Sidney wrote:
>
> Hello,
>   how do you manage Mysql outside of the network?

Install phpMyAdmin on your server (the easiest way is to put it in an i-bay) and enable Advance Authetication (the phpMyAdmin distribution has info on this).  When you use Advance Authentication, phpMyAdmin prompts you for a username and password that it then uses to connect to your MySQL server.  In other words, phpMyAdmin only runs with the permissions granted to the user who logs on.  This is particularly useful if you have multiple users accessing MySQL.

The one dis-advantage of Advance Authentication is that you can not install it in a password protected i-bay (well, if you can, I haven't figured out how).

Noah