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]

Reply via email to