Thanks. On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > How did you accomplish that? > > > > Ezra > > > > On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > > Thanks Gleb, Ezra. > > > > > > Fixing the root user was the trick. > > > > > > I've got it working now. > > > > > > ~mm > > > > > > > > > On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > > > > > > > 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] > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
