SitePoint Sponsor

User Tag List

Results 1 to 11 of 11
  1. #1
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Accidentally deleted the MySQL root user

    Hi,
    I have a virtual hosting account with ipower.com and this morning I accidentally deleted the root mysql user. My website can of course still read the data but I cannot make any changes to the database. The ipower.com support won't help because the virtual hosting accounts aren't managed servers. I've tried everything I could find after a couple of hours of google'ing but still no luck. I've been using both the Webmin and shell access but no luck. Would anyone be willing to log into the Webmin for me and figure it out? Thanks.

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    do a search in the mysql manual for "reset password" and follow those instructions. if that doesn't work for you, i'll be able to help when i get home later tonight.

  3. #3
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    shot - I just tried the reset password thing and now I'm totally locked out. My website can't even display the content. If anyone can help me out ASAP it would be very much appreciated!!

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    i'm home now. check your personal messages.

    did you get ALL the way through the instructions?

  5. #5
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i just PMed/emailed you. Thanks.

  6. #6
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks again for all of your help last night longneck.

    The below was in my MySQL error log - can anyone tell me how serious this is? Thanks.

    050726 04:39:45 mysqld ended

    050726 04:40:10 mysqld started
    050726 4:40:10 InnoDB: Started
    /usr/local/mysql/libexec/mysqld: ready for connections.
    Version: '4.0.16-log' socket: '/tmp/mysql.sock' port: 3306
    mysqld got signal 11;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help diagnose
    the problem, but since we have already crashed, something is definitely wrong
    and this may fail.

  7. #7
    SitePoint Enthusiast
    Join Date
    Mar 2005
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Umm, couldn't you have just created a new user in cpanel, then change the username to work with that database, then change the files where the mysql db information is at?

  8. #8
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The server doesn't have cpanel but longneck graciously fixed the problem for me last night. Now I'm just curious about message above in the error log. Thanks.

  9. #9
    SitePoint Enthusiast
    Join Date
    Jun 2005
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    would you please tell the solution longneck gave to you?
    I'm so curious about it!

    Chagh

  10. #10
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by GameAccounts
    Umm, couldn't you have just created a new user in cpanel, then change the username to work with that database, then change the files where the mysql db information is at?
    no, because the root password was already scrambled. for your suggestion to work, cpanel has to log in to mysql as root.

  11. #11
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Denver
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Chagh
    would you please tell the solution longneck gave to you?
    I'm so curious about it!

    Chagh
    Chagh - Longneck logged in via the shell and restarted MySQL and manually reset the root user/password.


Bookmarks

Posting Permissions

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