Re: moving the datadir

2005-11-24 Thread Ezra Taylor
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 --

Re: moving the datadir

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

Re: moving the datadir

2005-11-24 Thread Ezra Taylor
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 datad

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: > > Hi, > > I'm on Solaris 9 with mysql

Re: moving the datadir

2005-11-24 Thread Ezra Taylor
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/dat

Re: moving the datadir

2005-11-23 Thread Gleb Paharenko
Hello. >| @localhost | Obviously it is not a root user. If you're unable to connect as a root have a look here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Rajesh Olafson <[EMAIL PROTECTED]> wrote: >Hi Gleb, > >Here's the output: > >[EMAIL PROTECTED]:/u

Re: moving the datadir

2005-11-23 Thread Rajesh Olafson
Hi Gleb, Here's the output: [EMAIL PROTECTED]:/usr/local/mysql/bin:> ./mysql -u=root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 143 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SELECT CURRENT_

Re: moving the datadir

2005-11-23 Thread Gleb Paharenko
Hello. ># 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: > ># mysql -u=root > >--- >Maybe a different issue but, for some reason I can't connect with >

Re: moving the datadir

2005-11-21 Thread Rajesh Olafson
Thanks Gleb. I get the exact same results when I connect with: # mysql -u=root --- Maybe a different issue but, for some reason I can't connect with # mysql --user=root ^^^ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I can with: # mysql -user=root ^^

Re: moving the datadir

2005-11-19 Thread Gleb Paharenko
Hello. With SHOW DATABASES you see only those databases 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 mysql 4.1. > >I've moved

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