Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

20 Dec 2019   #1
Basil

Win 7 Pro 64 Bit
 
 
Please recommend a simple win 7 app to edit a mySQL database.

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


My System SpecsSystem Spec
.
20 Dec 2019   #2
z3r010

Windows 10 Workstation x64
 
 

If you are running MySQL on your local machine set HeidiSQL to use 127.0.0.1
My System SpecsSystem Spec
20 Dec 2019   #3
Basil

Win 7 Pro 64 Bit
 
 

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?
My System SpecsSystem Spec
.

20 Dec 2019   #4
z3r010

Windows 10 Workstation x64
 
 

Do you have MySQL installed and running and do you know it's port, username and password?
My System SpecsSystem Spec
20 Dec 2019   #5
Basil

Win 7 Pro 64 Bit
 
 

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.
My System SpecsSystem Spec
21 Dec 2019   #6
z3r010

Windows 10 Workstation x64
 
 

TBH I think your best option is to wipe it and reinstall.
My System SpecsSystem Spec
21 Dec 2019   #7
F22 Simpilot

Windows 7 Ultimate x64
 
 

Check out what's available here: Search for freeware and shareware at SnapFiles
My System SpecsSystem Spec
.
4 Weeks Ago   #8
Alejandro85

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by Basil View Post
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?
My System SpecsSystem Spec
4 Weeks Ago   #9
Basil

Win 7 Pro 64 Bit
 
 

Quote   Quote: Originally Posted by z3r010 View Post
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 :)
My System SpecsSystem Spec
4 Weeks Ago   #10
F22 Simpilot

Windows 7 Ultimate x64
 
 

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.
My System SpecsSystem Spec
Reply

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




Thread Tools




Similar help and support threads
Thread Forum
Cannot install MySQL
I had to to Reinstall Windows 7SP1 64Bit. After more then 180 Updates I can't install MySQL and some other Programs (OO-Defrag, Alcohol 120%, ...). MySQL only installs "Connector/ODBC" instead the complete Database.
Software
Can you recommend a good general purpose app to edit video files?
I recently obtained a number of large video files. They have several different file types (file extensions). Among those types are: .AVI .MKV .MPG .MPE .MP4 .WMV There are other types as well. I'd very much like to perform some simple editing on these files. The most common editing...
Music, Pictures & Video
which simple screen video capture software do you recommend?
Hello guys, I am looking for a free simple screen video capture software. Which one do you recommend that I should use? I have Adobe captivate but it look really complicated.
Media Center
MS Access - MySQL export
Hi, I'm making a little database for web, but i can't find how to export it (the code, not the content). If possible, the result should look like this example: CREATE TABLE `tasks` ( `id` int(11) NOT NULL auto_increment, `text` varchar(100) NOT NULL, `added` datetime NOT NULL, `done`...
Microsoft Office
phpBB + MySQL + IIS7??
I am trying to install phpBB for testing purposes on my IIS "server". I have MySQL installed, and have created a db with the following info: name: wiki (don't ask me why) user: root password: ****** At the db config, I enter: Type: MySQL with MySQLi Extension DSN: 10.0.0.227 or localhost...
Network & Sharing


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:14.
Twitter Facebook