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 'caus
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?
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
> >
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 abov
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 ano
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
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
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
Hello.
It seems that you already have the password set to 'my_password'.
But in MySQL access privilege system the host from you're connecting
also has the value. You may enable the general log and find the
user and the host which can't login. Check that you have those entries
in your mysql.u
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 fo
10 matches
Mail list logo
