Did you set the permissions on the new datadir? Ezra
On 11/18/05, 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? > > Thanks, > -RO. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
