Results 1 to 3 of 3

Thread: 1045 Error

  1. #1
    Join Date
    Dec 2003
    Location
    Seoul
    Posts
    2

    Unanswered: 1045 Error

    Hello, all!
    My system : win2k, mysql4.0.17,php4.3.2

    According to mysql manual, user is recommended to delete anonymous user having full privileges like,

    mysql> DELETE FROM user WHERE Host='localhost' AND User='';
    mysql> FLUSH PRIVILEGES;
    mysql> QUIT
    D:\mysql\bin>mysqladmin -u root password SECRET;
    D:\mysql\bin>mysql -uroot -pSECRET mysql;

    After this, I cannot access to root@localhost and had to reinstall.

    Could you please explain what I was wrong and what to to?

    Thank you in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You need to flush the privileges tables
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2003
    Location
    Seoul
    Posts
    2
    hehehe...
    As I mentioned above, I did it right after delete command.
    Several time I did. If I delete only anonymous, result is same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •