Problems with mysql

[Derrick Edwards]

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>