The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

All user mysql users/passwords not working

Discussion in 'General Discussion' started by noimad1, Jan 29, 2005.

  1. noimad1

    noimad1 Well-Known Member

    Joined:
    Mar 27, 2003
    Messages:
    627
    Likes Received:
    0
    Trophy Points:
    16
    We had a problem with our server and have been messing around with permissions and files and etc.

    We've got everything running except mysql. All users/passwords for mysql seem to be missing. Are these stored in a specific file?

    Wheny any users attempts to connect to his/her mysql databases they get:

    In cpanel, under the database names, where it normally lists the users for the database it says this instead:

    So I am thinking we have the wrong permissions on whatavever file has db users and passwords stored in...?
     
  2. DigitalN

    DigitalN Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    420
    Likes Received:
    1
    Trophy Points:
    18
    Your mysql database (mysql.*) keeps all the users and passwords, privs etc.

    Have you made any changes to /var/lib/mysql/mysql/* ?

    If you have a backup of the mysql db, that should solve any issues if the data is lost somehow. Check the tables first, to see if they just need repairing or something.
     
  3. noimad1

    noimad1 Well-Known Member

    Joined:
    Mar 27, 2003
    Messages:
    627
    Likes Received:
    0
    Trophy Points:
    16
    Yup..found out I overwrote it by mistake. Unfortunetly with no backup of it. I looked in my backups folder, but no luck there! Really sucks - have to have all of my users create new mysql users and passwords....what a pain...
     
Loading...

Share This Page