Fellow builders,

This is a sad case, where I entrusted someone to complete my designing but unfortunately he vanished half way. . . and now I have the complete the rest of this project.

I have access to logon to the server and I am able to download the directories & content into my local drive.

However, Im unable to connect to the database which is on the server since the password doesnt seem to match with my server logon details.

Hence, my question:-

1) How can I access my database fields currently residing on the server ?

2) If by any means, I can reset the password in order to see my database fields would be good.

Please help me out guys. Thanking in advance !

    As you are hosting it, I would suggest contacting your ISP, they will have all of your details and can verify who you are, etc.

    I doubt anyone would give details of how to reset the root password for mysql on an open forum (although it is possible to do).

    Do you not have a control panel or something similar to access your hosting details? (such as cpanel?). If not, as I say, contact your isp.

      Hi there,

      The issue here is my files are still hosted at the server of this guy who has now vanished.

      I have full access to this server as I can view most of the directories.

      Can someone tell me where does my mysql data tables sit ? which directory in particular ? Server is running UNIX

      One more question, how can I locate the `.pid' file that contains the server's process ID? I need to terminate this so I can reset the password

        You are getting close to asking questions that a) shouldn't be asked here in the first place and b) not going to get answered because of the nature of the questions regarding security. At this point, you really reall need to contact your web host as PickledOnion suggested in the first place.

        You should have cPanel and perhaps PHPMyAdmin on the server anyhow, and thus, you should be able to get in and export the tables and DB information... In any respect, you need to seek assistance from your web host from this point on, regarding this issue.

          Originally posted by TheDefender
          At this point, you really reall need to contact your web host as PickledOnion suggested in the first place.

          Who has apparently disappeared. However, I take it that the machine is still up and running somewhere....

          Just one more reason why I never trust a server I don't know the physical location of.

            OK, this may be an off the wall solution, but here goes....

            Do you FTP access to the server?

            If so, write some code to strip all of the data from all of the tables in your database and save the data locally.

            It is a very crude method, but then I'm no expert so I tend to use crude and dirty methods, which I try to refine later.

            Hope this helps,

            Neil.

              Which password exactly are we talking about. If this is a web app where a password has to be passed into the MySQL database to get access, it is likely squirelled away in some php file that the web app has access to.

              Or am I wayyyy off base here?

                Write a Reply...