connection problem to mysql v 8.0.16

Post here your questions about SFS2X. Here we discuss all server-side matters. For client API questions see the dedicated forums.

Moderators: Lapo, Bax

adifong
Posts: 20
Joined: 10 Aug 2016, 06:50

connection problem to mysql v 8.0.16

Postby adifong » 17 May 2019, 02:23

Hi,

I have problem when i want to upgrade database mysql from 5.7 to 8.0.16,
before i don't have any problem when connect to mysql v 5.7 and i got problem when change to mysql v8.
does any change need to support mysql v8?
i already install connector j8 for java but still cannot connect to database via smartfox.
does smartfox support mysql v8?

thank you
adi
User avatar
Lapo
Site Admin
Posts: 23008
Joined: 21 Mar 2005, 09:50
Location: Italy

Re: connection problem to mysql v 8.0.16

Postby Lapo » 17 May 2019, 07:51

Hi,
what problems are you seeing exactly? Are there any Exceptions? If so can you show us the relative stack traces?

Thanks
Lapo
--
gotoAndPlay()
...addicted to flash games
adifong
Posts: 20
Joined: 10 Aug 2016, 06:50

Re: connection problem to mysql v 8.0.16

Postby adifong » 18 May 2019, 03:09

Hi,

i already fix this, so i change the connector for mysql and put in lib mysql-connector-java-8.0.16,
and change drivername to :
<driverName>com.mysql.cj.jdbc.Driver</driverName>
<connectionString>jdbc:mysql://192.168.1.189:3306/db1?serverTimezone=GMT</connectionString>

thanks

adi
User avatar
Lapo
Site Admin
Posts: 23008
Joined: 21 Mar 2005, 09:50
Location: Italy

Re: connection problem to mysql v 8.0.16

Postby Lapo » 18 May 2019, 06:48

Hi,
so it's working fine now?

Cheers
Lapo

--

gotoAndPlay()

...addicted to flash games

Return to “SFS2X Questions”

Who is online

Users browsing this forum: No registered users and 73 guests