Lost access to database

[Wavoz]

So today i was ready to launch my server until i made new user to pma, i frogot to grant all permissions and deleted other users that were not on localhost.
So here i am with no access to databse, How could i regain it? the only way to access is by localhost. Can i grant permisssions/add users to PMA with putty? Any solutions? I tried reinstalling OS on this VPS but it didn't do anything.... my old data remains,

I also bought second VPS, got databse working fine, server set up, but the server wont start, after i compiled tfs for linux, i copied and renamed it tfs.custom and places it to bin folder, set tfs version to custom, removed !stop but it doesnt come up. Console log is empty, restarter log is showing "starting server" in every 2 minutes but always failing, server doesnt come up.

 

[Black Reaper]

Using mysql? You should have a root user.
https://help.ubuntu.com/community/MysqlPasswordReset

 

[Wavoz]

Thank you for your asnwer, but i deleted root users and left only my new user, but i can only access it trough localhost, since its VPN i can't access it trough localhost (when using PMA in web browser)

 

[Don Daniello]

You can login from the server to that user using 'mysql' command. You can always reinstall your server.

 

[Wavoz]

I managed to get access to PMA on web browser after i made SSH tunnel on port 3306 and turned of SQL on my local PC if anyone else ever should have problem like that.

Reinstall server feature doesnt seem to work, i tried it, nothing got erased/reinstalled.

 

[Don Daniello]

Did you get any message when you attempted reinstalling?

 

[Wavoz]

No message, it just returns to page where you can stop, reboot, reinstall the server.

 

[Don Daniello]

Open a ticket and we can reinstall the server for you.

 

[Natroxxxx]

Help me please When i try to open ot its says Error:Couldn't estabilish connection to sql database
Help me please..

 

[Wavoz]

Check your database section on config.lua, see if you have correct user and password set there, also correct database name. In PMA check if you have correct permissions on user for your database.