From owner-freebsd-questions@FreeBSD.ORG  Sun Nov  7 20:40:12 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 3AFB516A4CF
	for <FreeBSD-Questions@FreeBSD.org>;
	Sun,  7 Nov 2004 20:40:12 +0000 (GMT)
Received: from out009.verizon.net (out009pub.verizon.net [206.46.170.131])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9D56043D41
	for <FreeBSD-Questions@FreeBSD.org>;
	Sun,  7 Nov 2004 20:40:11 +0000 (GMT)
	(envelope-from Michael.Stassen@verizon.net)
Received: from [192.168.0.7] ([68.163.191.126]) by out009.verizon.net
          (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP
          id <20041107204010.XPLG3542.out009.verizon.net@[192.168.0.7]>;
          Sun, 7 Nov 2004 14:40:10 -0600
Message-ID: <418E882C.6030203@verizon.net>
Date: Sun, 07 Nov 2004 15:40:12 -0500
From: Michael Stassen <Michael.Stassen@verizon.net>
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US;
	rv:1.7.2) Gecko/20040804 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "W. D." <WD@US-Webmasters.com>
References: <5.1.0.14.2.20041107130001.071db340@209.152.117.178>
In-Reply-To: <5.1.0.14.2.20041107130001.071db340@209.152.117.178>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Authentication-Info: Submitted using SMTP AUTH at out009.verizon.net from
	[68.163.191.126] at Sun, 7 Nov 2004 14:40:10 -0600
cc: mysql@lists.mysql.com
cc: FreeBSD-Questions@FreeBSD.org
Subject: Re: Completely remove MySQL?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 07 Nov 2004 20:40:12 -0000

That's using a shotgun to kill a gnat.  The IP used by phpmyadmin is set in 
the config.inc.php file in the phpmyadmin directory.  Just edit this file to 
change the old setting to the new value.  Problem solved.

Reinstalling mysql and php, on the other hand, will have no effect. 
Reinstalling phpmyadmin may replace config.inc.php with default settings, 
but you'd still have to edit it to have the correct settings, so you may as 
well just edit the one you already have.

Michael

W. D. wrote:

> Hi Folks,
> 
> How does one completely remove MySQL from FreeBSD 4.9?
> 
> My router died, and upon replacement I switched to
> static IP addresses on my local network.  Unfortunately,
> When using phpMyAdmin to access a database, it
> tries to access the database at the old IP.
> 
> I can easily recreate the database--as well easily
> reinstall PHP, MySQL, and phpMyAdmin--but how do I
> remove everything so that the old IP address is
> not referenced?
> 
> By the way, where is this IP address being stored?
> 
> Thanks mucho for any light you can shed!