From owner-freebsd-ports@FreeBSD.ORG  Thu Mar 16 21:17:26 2006
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id AF3D716A401
	for <freebsd-ports@freebsd.org>; Thu, 16 Mar 2006 21:17:26 +0000 (UTC)
	(envelope-from dantavious@comcast.net)
Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [63.240.77.81])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4AF3E43D46
	for <freebsd-ports@freebsd.org>; Thu, 16 Mar 2006 21:17:26 +0000 (GMT)
	(envelope-from dantavious@comcast.net)
Received: from [192.168.1.109]
	(c-68-55-192-50.hsd1.md.comcast.net[68.55.192.50])
	by comcast.net (sccrmhc11) with ESMTP
	id <20060316211720011002ttsge>; Thu, 16 Mar 2006 21:17:20 +0000
From: Derrick Edwards <dantavious@comcast.net>
To: freebsd-ports@freebsd.org,
 mark@foster.cc
Date: Thu, 16 Mar 2006 16:17:22 -0500
User-Agent: KMail/1.9.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200603161617.23411.dantavious@comcast.net>
Cc: dantavious@comcast.net
Subject: Re: Problems with mysql
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 16 Mar 2006 21:17:26 -0000

Derrick Edwards wrote:
>       Hi,
> I updated my MySQL installation today (mysql-client-5.1.6_1 
> mysql-server-5.1.6_2), once the update complete I restarted mysqld. Once 
that 
> was done it seems that MySQL does not see databases. I checked 
> in /var/db/mysql and all the folders for the databases are there and the 
> permissions are fine. I have updated before and never ran into this problem. 
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | test               |
> +--------------------+
> 2 rows in set (0.00 sec)

<This only shows you the databases you actually have access to as the
<user you logged in as.
<In other words, you didn't log in using root but some other
<less-privileged account. 
<Some days it's just not worth chewing through the restraints...
<Mark D. Foster, CISSP <mark at foster.cc>  http://mark.foster.cc/

	Actually,
That was the root account.

mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 445 to server version: 5.1.6-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql>