I download the FusionAuth on my windows machine and after some stuggle I get it working with MySql database. Then I download fresh copy of FA (just app no docker or anything) and upload to my ubuntu server. copy the mySql Connecotr 8.0.33 editon to lib folder as document says.

but it is not connecting to database. I am stuck at installation screen. where I only get it working once with my Root password to create database, but it create half database before it lost connection. So I create blank database and username password and try to proceed. it is not connecting..

Now I copy my Windows database to server and give username password to in .properties file but it is not connecting and redirecting me to installation screen. where it is giving error as

The user for the username you provided was either created or already existed but could not be granted access to the database. The error from the database was [No suitable driver found for jdbc:mysql://10.131.37.113:3306/mysql?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true].

My server is on same LAN in data center and my php apps are connecting file with give authentication but not FA.

I have similar issue with MySql 5.7 and create a issue report here : https://github.com/FusionAuth/fusionauth-issues/issues/2658

Apparently it seem there is typing error in Sql query that miss the table name but use the alias only and hence the error.

@dan Thanks for reply. I manage to solve it but not fully. I was using Direct Download version first and that is where it was not connecting. Then I use DEbian installation method and it connect using same Connector file I use for direct download to mysql 5.7 (but it doesn't connect to Mysql 8.0.32 server )

It works fine except that now SQL query it runs for application and Tenant page has error I create issue in Github here: https://github.com/FusionAuth/fusionauth-issues/issues/2658 Not sure it is related (as in some installation error occur ) or it is just programming bug.

@dan I know this is old thread and OP didn't reply. But I have same issue and I did see mysql Connector when I echo $CLASSPATH in script .. I am getting that It cannot access database. I am using Connector 8.0.33 but my mysql is 5.7 is that a problem? Because I check authentication setting to mysql and using PHP Script I can connect fine but not from fusionAuth 1.48

I download the FusionAuth on my windows machine and after some stuggle I get it working with MySql database. Then I download fresh copy of FA (just app no docker or anything) and upload to my ubuntu server. copy the mySql Connecotr 8.0.33 editon to lib folder as document says.

but it is not connecting to database. I am stuck at installation screen. where I only get it working once with my Root password to create database, but it create half database before it lost connection. So I create blank database and username password and try to proceed. it is not connecting..

Now I copy my Windows database to server and give username password to in .properties file but it is not connecting and redirecting me to installation screen. where it is giving error as

The user for the username you provided was either created or already existed but could not be granted access to the database. The error from the database was [No suitable driver found for jdbc:mysql://10.131.37.113:3306/mysql?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true].

My server is on same LAN in data center and my php apps are connecting file with give authentication but not FA.