Thanks.
On 11/24/05, Rajesh Olafson <rolafson@stripped> wrote:
> Hi Ezra,
>
> I fixed the root user by following the instructions laid out at
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
> .
>
> The root user was somehow corrupted.
>
> I started mysql with the mysqld_safe --datadir=/my/new/location ... plus the
> other parameters set out in the docs.
>
> The db was always working fine over JDBC - it was just the cmd line
> utilities [like /usr/local/mysql/bin/mysql] that were acting strange.
>
> RO
>
>
>
> On 11/24/05, Ezra Taylor <ezra.taylor@stripped> wrote:
> >
> > How did you accomplish that?
> >
> > Ezra
> >
> > On 11/24/05, Rajesh Olafson <rolafson@stripped> wrote:
> > > Thanks Gleb, Ezra.
> > >
> > > Fixing the root user was the trick.
> > >
> > > I've got it working now.
> > >
> > > ~mm
> > >
> > >
> > > On 11/24/05, Ezra Taylor <ezra.taylor@stripped> wrote:
> > > >
> > > > 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.
> > > > >
> > > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=1
> > > >
> > > >
> > >
> > >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
