Re: moving the datadir

2005-11-24 Thread Rajesh Olafson
. 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 &

Re: moving the datadir

2005-11-24 Thread Rajesh Olafson
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

Re: moving the datadir

2005-11-23 Thread Rajesh Olafson
;# mysql -u=root > > > > What is 'SELECT CURRENT_USER();' reporting for you? > > > > > > Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > >hanks Gleb. > > > > > >I get the exact same results when I connect with: > > > >

Re: moving the datadir

2005-11-21 Thread Rajesh Olafson
atabases for which you have some > > kind of privilege, unless you have the global SHOW DATABASES privilege. > > Connect to mysql under the root user. > > > > > > Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > >Hi, > > >I'm on Solaris 9 with

moving the datadir

2005-11-18 Thread Rajesh Olafson
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 us