Re: access-trouble using root
I wrote; mysql> UPDATE mysql.user SET
Password=OLD_PASSWORD('the_new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> \quit
Then; shell> mysql -u root -p
Enter password: the_new_password
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Is this 'cause I didn't kill mysqld_safe before trying to login again?
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access-trouble using root
On Apr 5, 2005 10:49 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> X y <[EMAIL PROTECTED]> wrote on 04/05/2005 03:51:02 PM:
>
>
> > On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > >
> > > 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'
> >
> > Did the above, put in my old password in OLD_PASSWORD and my new
> > password within the 'my_new_password' field (so to speak)
> >
> >
> > > You will need to FLUSH PRIVILEGES again. If this doesn't work at least
> we
> > > have eliminated another possibility.
> >
> >
> > Now I got this error message after doing mysql> FLUSH PRIVILEGES;
> >
> > ERROR 1064: You have an error in your SQL syntax. Check the manual
> > that corresponds to your MySQL server version for the right syntax to
> > use near 'FLUSH PRIVILEGES' at line 2
> >
> >
> > I'm using 4.0.20 (Your MySQL connection id is 1 to server version: 4.0.20)
> >
> >
> > Thank you for your feedback, 'tis appreciated!!!
> >
> >
> >
> > N.P
> I think you misunderstood
Looks like it
> OLD_PASSWORD() is a function (not something I wanted to you retype) added to
> versions 4.1 and later that will hash whatever plain text is in it into a
> pre-4.1 password just as the PASSWORD() function hashes plain text into a
> more robust post-4.1 password. I also left off the ending semicolon from the
> update statement (sorry that was my error) the actual statement should read
> (it will be re-wrapped by the list server but it started as one long
> statement):
>
> UPDATE user SET Password =
> OLD_PASSWORD('put_your_new_password_here') WHERE
> User='root';
When I write the above as one long statement, I get the following message;
"ERROR 1046: No Database Selected"
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access-trouble using root
On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> 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'
Did the above, put in my old password in OLD_PASSWORD and my new
password within the 'my_new_password' field (so to speak)
> You will need to FLUSH PRIVILEGES again. If this doesn't work at least we
> have eliminated another possibility.
Now I got this error message after doing mysql> FLUSH PRIVILEGES;
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'FLUSH PRIVILEGES' at line 2
I'm using 4.0.20 (Your MySQL connection id is 1 to server version: 4.0.20)
Thank you for your feedback, 'tis appreciated!!!
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access-trouble using root
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]
Re: access-trouble using root
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]
and some more on the root-access issue;
I tried the flush-privileges command and got the following; mysqladmin flush-privileges mysqladmin: reload failed; error: 'Access denied. You need the RELOAD privilege for this operation' - So, how can I set full access-rights to root the easiest way? (thank you) N.P -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
access-trouble using root
Over on http://forums.mysql.com/read.php?10,20058,20058#msg-20058 I
posted a msg connected to me having trouble to login to my MySQL
database handler.
I might save some space here in your email by asking you to go to the
above forum-thread, and my last post in the thread goes;
Ok, so I did the following;
1. Stop mysqld and restart it with the --skip-grant-tables option as
described earlier.
2. Connect to the mysqld server with this command: shell> mysql -u root
3. Issue the following statements in the mysql client: mysql> UPDATE
mysql.user SET Password=PASSWORD('newpwd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
Replace ``newpwd'' with the actual root password that you want to use.
4. You should be able to connect using the new password.
I got the following result;
mysql> UPDATE mysql.user SET Password=PASSWORD('my_password') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 5 Changed: 0 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
The thing is that this doesn't work, and I suspect that somehow,
webmin and my browser happened to remove some privileges of thr root
user while changing password through mentioned webmin.
I can't login to mysql neither via the shell as root using "mysql -u
root -p" (without the -p it works, but then I don't seem to be able to
do anything), neither can I login via webmin's interface using "root"
as my password and my assigned password.
My follow-up question is; where are these settings stored, and how can
I change back so that root has full access-rights again???
Thanks in advance!!!
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
