Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
exactly what you did before except try this:
UPDATE mysql.user SET Password=OLD_PASSWORD('my_new_password') WHERE
User='root'
You will need to FLUSH PRIVILEGES again. If this doesn't work at least we
have eliminated another possibility.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
X y <[EMAIL PROTECTED]> wrote on 04/05/2005 12:42:01 PM:
> I may add that I also tried;
>
>
>
> 1. I kill the mysqld-process on the server.
>
> 2. I start mysqld_safe by typing; "mysqld_safe --skip-grant-tables &"
>
> 3. Connect to the mysqld-server by doing; "shell> mysql -u root"
>
>
> 4. Inside, I write; UPDATE mysql.user SET
> Password=PASSWORD('my_new_password') WHERE User='root';
>
> and get the following reply from mysql;
>
> Query OK, 5 rows affected (0.00 sec)
> Rows matched: 5 Changed: 5 Warnings: 0
>
>
> 5.Still inside mysql, I write; FLUSH PRIVILEGES;
>
> and get the following reply;
>
> Query OK, 0 rows affected (0.00 sec)
>
>
>
>
> According to
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
> I should now be able to login using "my_new_password*, but this
> doesn't happen.
>
> What is the next step?
>
>
>
> Thank you.
>
>
>
> N.P.
>
>
> On Apr 5, 2005 6:11 PM, X y <[EMAIL PROTECTED]> wrote:
> > I do the following;
> >
> > 1. I kill the mysqld-process on the server.
> >
> > 2. I start mysqld_safe by typing; "mysqld_safe --skip-grant-tables &"
> >
> > 3. Logged in as root, I type this shell> mysqladmin -u root
> > flush-privileges password "my_wanted_password"
> >
> > 4. I try to login as root to the MySQL-server, by typing: shell> mysql
> > -u root -p (then entering my password in the dialogue) - and I get the
> > following error-message; "ERROR 1045: Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: YES"
> >
> > Any remedy for this?
> >
> > Thanks.
> >
> >
> > On Mar 29, 2005 10:48 AM, Gleb Paharenko <[EMAIL PROTECTED]>
wrote:
> > > Hello.
> > >
> > > Add '[EMAIL PROTECTED]' account.
> > >
> > >
> > > >I did this;
> > >
> > > >
> > >
> > > >050328 16:20:57 7 Query GRANT ALL PRIVILEGES ON *.* TO
> > >
> > > >root@'%'
> > >
> > > >GRANT ALL PRIVILEGES ON *.* TO root@'%'
> > >
> > > >
> > >
> > > >Yet still I get 050328 16:21:08 8 Connect Access denied
for
> > >
> > > >user: '[EMAIL PROTECTED]' (Using password: YES)
> > >
> > > >
> > >
> > > >050328 16:13:33 4 Connect Access denied for user:
> > >
> > > >'[EMAIL PROTECTED]' (Using password: YES)
> > >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
