1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Mysql Problem

Discussion in 'Plesk for Linux - 8.x and Older' started by hostshelter, Apr 6, 2005.

  1. hostshelter

    hostshelter Guest

    0
     
    Hi everybody,
    I'm using plesk 7.5.2 under RedHat el3. The problem is a follow: A week ago a domain hosted on my server creates a mysql database with no problem. Minutes later he tried to change the user name to admin. Plesk complained that such user already exists. Some how after that the whole plesk control panel came to halt.

    That client called me and describes the problem to me. Me as administrator I was lock out plesk and with not privileges on mysql database.

    The admin user from the mysql database was COMPLETELY removed and I can't access mysql because I no longer have root privileges.

    I would like to know if someone has been gone through this before. I would appreciate any comment.

    Miguel
     
  2. eWebtricity

    eWebtricity Guest

    0
     
    Can you SSH to the server and try and access MySQL from the command line? then you could directly query the plesk DB table and see if the admin user still exists.

    Restore the DB from a backup?
     
  3. hostshelter

    hostshelter Guest

    0
     
    Hi eWebtricity,
    Thanks for your response.

    Yes I can SSH to the server. I also can connect to MYSQL server and the admin user was created again. The problem is mysql table of MYSQL server can not be access, I don't have any privileges on that table anymore. It seems to be damage.

    I can't create new databases but the ones created already work fine.

    Is there any way I can fix mysql table of MYSQL without trying to install MYSQL again.

    Thanks
    Hostshelter
     
  4. supernut

    supernut Guest

    0
     
    same problem here, if you have the app-vault that still allows new mysql databases, other then that its a no go for other scripts, i just hope someone has a fix for this as soon as possible as its looking like more and more are having the same problem.
     
  5. supernut

    supernut Guest

    0
     
  6. supernut

    supernut Guest

    0
     
    anyone got a fix for this problem yet ?
     
  7. defencer

    defencer Guest

    0
     
    I have the same problem here. Did anybody kick swsoft already?
     
  8. jimroe

    jimroe Guest

    0
     
    If you have root access to the shell, you can reset the password to MySql:

    1 - stop mysql (/etc/rc.d/init.d/mysqld stop)
    2 - start mysql with this command:
    /usr/bin/safe_mysqld --skip-grant-tables&

    Now - you can log in as root with no password, and can access the mysql database. You can put the password for admin back in, or reset it to the Plesk admin password using SQL commands.
     
  9. supernut

    supernut Guest

    0
     

    what do you mean about the password

    could you explain that step by step please ?
     
Loading...