Please recommend a simple win 7 app to edit a mySQL database.

[Basil]

Could someone please recommend a simple to use and free Windows 7 app to manually edit an existing mySQL database on a PC here? Thanks! I downloaded Heidisql but it seems to be expecting to work over a LAN? I don't really know how these things work, but the file is on the same PC from which I need to edit it...I'll take a back up as I am well out of my comfort zone, if you couldn't already tell

 

[z3r010]

If you are running MySQL on your local machine set HeidiSQL to use 127.0.0.1

 

[Basil]

Thanks for the very fast reply, appreciated. I have tried this but not sure how to direct it to the database which is in C:/Program Files/Traccar/data/database.mv.db


What port should I use? I was naive enough to think it could be edited as a fancy text file, I had no idea it had to be accessed via TCP/IP.... Do I need to stop the service first?

 

[z3r010]

Do you have MySQL installed and running and do you know it's port, username and password?

 

[Basil]

Well, feel free to snigger, I deserve it, but i am not sure. It's a tracking server run on my home PC, I recently installed it and it works superbly, as good as using a commercially sourced external server, but i screwed up the creating of the admin user and can no longer create one as the option is greyed out. the clever Russian writer replied to a cry of help by saying edit the database file manually. It's apparently a JVDC (?) database running mySQL I log in using a fixed IP address through a port I opened in Windows Firewall and in my router. So yes, I probably can hazard a good guess as to the port, and the username, but my quest is to create a password and give me admin rights. Sorry to sound so vague, it's because I am! If it becomes very involved it may be efficacious to wipe the app and reinstall as it's not a terrible chore. Thank you for your patience and help.I am persevering myself as in future this may be something I could do with semi understanding if I do anything else daft.

 

[z3r010]

TBH I think your best option is to wipe it and reinstall.

 

[file3456]

Check out what's available here: Search for freeware and shareware at SnapFiles

 

[Alejandro85]

I have tried this but not sure how to direct it to the database which is in C:/Program Files/Traccar/data/database.mv.db

This immediately tells that the DB isn't MySql. A MySql database spans multiple files (one per table, plus a couple more) and is always located where the server is installed, not the program using it. How do you know that it's MySql? If so, how did you installed the server?

 

[Basil]

TBH I think your best option is to wipe it and reinstall.

You were correct! I made the mistake of believing it was a mySQL database and in fact it urns out to be an H2 one. Wiping and reinstalling seemed easiest given I have to admit to not really knowing what I was doing... Thanks to all for the advice and help, a happy Christmas and a healthy and prosperous New Year

 

[file3456]

A .db database could be SQLite and DB Browser can open it. DB Browser for SQLite

I know you now deleted the database, so posting this here for anyone that needs the information in the future.