I am fairly new to MYSQL. OK, I have no idea what I'm doing, lol.
I have installed MYSQL and it is running properly on windows, I want to use TransTRBO with MYSQL for GPS reasons.
I have used MYSQL workbench, but I really have no idea if or how to setup the database. I did real the TransTRBO documentation about MYSQL, but I'm just not sure what to do. All I know currently, is that whatever I am doing is not working.
I'm using TransTRBO 0.1.1.7 and MYSQL 5.7.11.10.
Any help would be greatly appreciated.
-Mark
MYSQL Database Setup
- Administrator
- Site Admin
- Posts: 381
- Joined: Mon Jul 21, 2014 5:48 am
Re: MYSQL Database Setup
Hi Mark,
I use HeidiSQL available here:
http://www.heidisql.com/
When you created MySQL you will have a :-
Username: root (usually)
Password: <your_password>
NB: #1, #2 and #3 refer to screen shot below ...
Hopefully it should work ...
(If not - you may have to create a new database using the Work bench/HeidiSQL the name must be the Database Prefix with the entire Radio Serial in my case transtrbo_038tmc4558)
cheers
Will
I use HeidiSQL available here:
http://www.heidisql.com/
When you created MySQL you will have a :-
Username: root (usually)
Password: <your_password>
NB: #1, #2 and #3 refer to screen shot below ...
- Connect to the Base Station Radio
- Select Configuration from the Toolbar
- Select Database Settings page - #1
- Select MySQL - GPS Logging - #2
- Leave Database Prefix as the default
- Leave Net Address as the default
- Leave Port as the default
- Enter the MySQL Username (default is usually root)
- Enter the MySQL Password
- Radio Serial - should automatically be here - leave it alone
- Press the Test button #3
- A response of "MySQL OK" should appear in the box under the Test button
- Hit the OK button
- Disconnect from the Radio
- Reconnect to the Radio
Hopefully it should work ...
(If not - you may have to create a new database using the Work bench/HeidiSQL the name must be the Database Prefix with the entire Radio Serial in my case transtrbo_038tmc4558)
cheers
Will
Geriatrics Generate Methane.
Grafitti Clifton Hill 1974
Living proof 2021
Grafitti Clifton Hill 1974
Living proof 2021