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 --
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
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
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
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
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
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_
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
>
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
^^
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
10 matches
Mail list logo
