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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
