Trouble creating a remote database (MySQL)

[temibalao]

Hello,

I am attempting to create a new DNA database by connecting to a MySQL database. However, when I enter the information and click "Create data structures," nothing comes up. Am I typing in the information incorrectly? I tried the host address "Temis-MBP.attlocal.net" as well, but it did not work. Any assistance would be greatly appreciated.

Attached are screenshots of Discourse Network Analyzer and the MySQL database server information.

Thank you.

[leifeld]

I would try to log into the database manually (without DNA) first to verify the access is possible. Double-check that you have the right user name, that the user name has write access (including creation of tables), then try to create a table and delete it again. You can try it with the basic command line tool or some GUI tool like DBeaver or HeidiSQL. If that works, try it with DNA. In DNA, you can also have a look at the log messages (the bug symbol in the lower right corner) to see if any particular messages come up when you try to connect. It could already tell you if the connection couldn't be established or if there is a problem with access rights etc. Let me know how it goes.

[leifeld]

Also, I suspect you may have the wrong server address. If it's a local installation, chances are that the address is 127.0.0.1. Also have a look at this link, or look for information on how to find the connection IP or URL for a local MySQL installation on MacOS.

[leifeld]

Here are also some instructions on how to query your login details and server address on the command line.