Home / server / Questions / 66304
Accepted
BIBD
Asked: 2009-09-18 07:55:34 +0800 CST

Getting Simply Accounting's MySQL connection information

  • 772

My organisation is using Simply Accounting (S.A.) as the accounting system for a larger project. I see that it's using MySQL as its back-end database. I'd like to scrape some data out of the database directly instead of through S.A.'s interface.

Is there a way I can sniff out the Username and Password that S.A. is using? Alternately, how I could I add my own account to the database, and avoid the whole thing altogether?

mysql

3 Answers

  1. Best Answer

    Got it... found here (now broken) or archive.org

    I didn't find out how to sniff the username, but I did find out what it is and the rest of the connection info.

    connection type: TCP
username:        sysadmin
password:                  ''// <-- default is blank 
database:        simply    
host:            myMachineName
port:            ######    ''// You can get this using the following procedure

1. Open Simply Accounting
2. Go to Help->About Simply Accounting [blah blah blah]
3. Click on "Support Info"
4. look in the top-right corner of the Support Info window, you will see a
   region labelled "Database Engine". The Port is listed at the bottom.

    Scrape away.

    Note, S.A. MUST BE OPEN for you to connect to it.

    • 3

  2. If you can start/stop MySQL server of S.A. system, you can restart it with option --skip-grant-tables, connect with usual mysql client without knowing root password and create necessary users.

    Don't forget to restart MySQL again without --skip-grant-tables to close your server from others.

    • 1

  3. You want to read this page about adding user accounts to MySQL. And then you want to add a user and grant them full rights on the S.A. database.

    • 0