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.
