Did you set the permissions on the new datadir?
Ezra
On 11/18/05, Rajesh Olafson <rolafson@stripped> 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:
>
> root@catss:/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.
>
>
