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
/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
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
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
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
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
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