Thanks Gleb. I get the exact same results when I connect with:
# mysql -u=root --- Maybe a different issue but, for some reason I can't connect with # mysql --user=root ^^^ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I can with: # mysql -user=root ^^^ MySQL v4.1.10a-standard. Thanks for your time. I'm only a sporadic user of MySQL - so some of this maybe a case of RTM. -RO On 11/19/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > With SHOW DATABASES you see only those databases for which you have some > > kind of privilege, unless you have the global SHOW DATABASES privilege. > > Connect to mysql under the root user. > > > > > > Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > >Hi, > > >I'm on Solaris 9 with mysql 4.1. > > > > > >I've moved the datadir to a new location, and edited the mysql start > script > > >directly so that it now has the line: > > > > > >datadir=/export/www1/data > > > > > >The server restarts no problem, and my phpBB web app can talk to it no > > >problem. > > > > > >However when I try to connect to it using the /usr/local/mysql/bin/mysql > > >client I get: > > > > > >[EMAIL PROTECTED]:/usr/local/mysql:> ./bin/mysql --user=mysql > > >Welcome to the MySQL monitor. Commands end with ; or \g. > > >Your MySQL connection id is 3 to server version: 4.1.10a-standard > > > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > >mysql> show databases; > > >+----------+ > > >| Database | > > >+----------+ > > >| test | > > >+----------+ > > >1 row in set (0.00 sec) > > > > > >mysql> > > > > > >------ > > > > > >I'm not sure where it's getting the 'test' db from, but it's not showing > the > > >phpBB database - or other databases I have. > > > > > >I've tried creating a /etc/my.cnf file - but I can't get it to work. > > > > > >Thoughts? > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com <http://www.mysql.com> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
