Date: Thu, 16 Mar 2006 16:17:22 -0500 From: Derrick Edwards <dantavious@comcast.net> To: freebsd-ports@freebsd.org, mark@foster.cc Cc: dantavious@comcast.net Subject: Re: Problems with mysql Message-ID: <200603161617.23411.dantavious@comcast.net>
next in thread | raw e-mail | index | archive | help
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>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200603161617.23411.dantavious>