MySQL password

[tleah1]

Where can I find our MySQL password for Miva 9? I can see the database name in the phpMyAdmin area, but I would also like to know the password.

[ILoveHostasaurus]

Re: MySQL password

The password is stored encrypted and is not retrievable. You can however add an additional user to the same database with its own password that you know. Keep in mind that you should not connect any other apps to the store database, especially ones like php-based scripts that store the password to the database in plain text; those are a massive security risk.

[tleah1]

Re: MySQL password

Hi,
Thank you for your help. I have added an additional user, but I am not sure the new user has the permission for remote login to the database? I am trying to connect to the database with vb.net to obtain additional order data that is not sent from Miva to Shipworks with the Shipworks shipping app. I only want to read data (not write), and the program will only be run locally to get the extra fields into Shipworks, so I do not think it is a big security risk because the password will not be online.

However, when I make the connection I am getting an error. This is the connection string I am using, and I use something similar to successfully login to other mysql databases remotely. (Of course my actual connection string has the server, database, etc. vs ***.)
"DRIVER={MySQL ODBC 5.1 Driver};" & " SERVER=***;" & " DATABASE=***;" & " UID=***;PWD=***; OPTION=3"

[ILoveHostasaurus]

Re: MySQL password

If it's hosted here, you'll need to contact our support staff with your IP address and it can be opened up to that. Keep in mind that this violates PCI and is not compatible with the PA-DSS validation, so while you can do it, there may be associated risks.

[tleah1]

Re: MySQL password

Ok, we definitely don't want to violate the PCI security, etc. I just need to get the custom field information for the orders to put into Shipworks, can you think of another automated way to do this?

[ILoveHostasaurus]

Re: MySQL password

Sorry for the delay, it sounds like the only safe way to do it would be for the ShipWorks staff to add that feature to their module that goes into the store, as it's the one pulling and returning the data that ShipWorks downloads.

[Mark Hood]

Re: MySQL password

Please contact shipworks to help get this done. ( I have done so several times already)

They are usually 1-2 years behind updating the module for new Miva features

[Rick Wilson]

Re: MySQL password

Let me see what I can do.

[tleah1]

Re: MySQL password

I have contacted Shipworks about it, but I don't think it is a priority for them. What I am doing as a work around is using the Template Based Emails in Miva to send out a custom email for each order with the notes and other custom fields. Then I am using visual basic to check these emails and put the notes automatically into Shipworks.