can't connect to mysql

[arzie2000]

I have created a table on my website using myphpadmin. When I try to connect to that database i get an “Error code: 1045”. here’s what i did:

• New Base Database
• on Steps:
  1. Select Database, i selected “Connect to an existing database”, from the drop down, “MySQL”
  2. Set up MySQL Connection, i selected " Connect Directly".
  3. Set up JDBC Connection, I entered the database name, my domain IP as server, port 3306.
  4. Set up user authentication, I used my admin username and password. but when I press the test connection, that’s where the error appears.

What/where did I do wrong? thanks.

[Ratslinger]

Hello,

Your question states using a direct connection and a JDBC connection. You can only be using one or the other in the Base connection. Also it is important to know the MySQL version your are using and if 8.0 what level of security was applied.

For reasoning and further insight to your problem see this post:

Mysql direct connector in LO 7

Hello, You do not state what version of MySQL server you are dealing with. I have not tried with LO v7.0.x yet but MySQL v5.7.x seems to present no problem with other versions I have tied. MySQL v8.x seems to be problematic with the native connector. See tdf#135202 Don’t know of any fix currently except to change to either an ODBC or JDBC connector.

Also, the error you posted indicates either an incorrect password or database is used.