Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Belgium
    Posts
    23

    Unanswered: can't login in mysql

    Hey,

    I'm messing around with mysql-databases in webmin.
    I changed the user-permissions :

    root was only available from localhost, I changed it to all hosts, but that was a big mistake. This is the error I get :

    DBI connect failed : Access denied for user: '@localhost' to database 'mysql'


    I can't do or change anything anymore, and my databases aren't visible in webmin (only 1 : test). Even the standard database mysql isn't visible. What can I do ???

    I hope someone can help me, because I'm really desperate !!!


    Thanks !!!

    PS: I tried to change a password in the shell, with the command :

    mysqladmin -u root password 'password'

    but it says :

    mysqladmin: unable to change password; error; 'Access denied for user: '@localhost' to database 'mysql'

    Help please !!!!
    You help me, and I'll try to help you

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: can't login in mysql

    Originally posted by Geypens
    Hey,

    I'm messing around with mysql-databases in webmin.
    I changed the user-permissions :

    root was only available from localhost, I changed it to all hosts, but that was a big mistake. This is the error I get :

    DBI connect failed : Access denied for user: '@localhost' to database 'mysql'


    I can't do or change anything anymore, and my databases aren't visible in webmin (only 1 : test). Even the standard database mysql isn't visible. What can I do ???

    I hope someone can help me, because I'm really desperate !!!


    Thanks !!!

    PS: I tried to change a password in the shell, with the command :

    mysqladmin -u root password 'password'

    but it says :

    mysqladmin: unable to change password; error; 'Access denied for user: '@localhost' to database 'mysql'

    Help please !!!!
    try logon to mysql: mysql -u root -p

  3. #3
    Join Date
    Apr 2003
    Location
    Belgium
    Posts
    23
    I can login to mysql, but I can't change something, always same error .

    I hope it wasn't a fatal mistake
    You help me, and I'll try to help you

  4. #4
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137
    Restart mysqld with the option --skip-grant-tables, then fix the user table in the database mysql. Follow the instructions in the manual: http://www.mysql.com/doc/en/Resetting_permissions.html

Posting Permissions

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