Get MySQL error when running project on the Digital Ocean server

📚 Official Books Server Side Swift with Vapor
1

When running the project on Digital Ocean server, I get this error like this:
Running TILApp6 …
[ INFO ] Migrating ‘mysql’ database (MigrationConfig.swift:69)
:warning: [MySQLError.fullAuthRequired: Full authentication not supported over insecure connections.] [/root/practice/.build/checkouts/mysql.git-2705124829566944602/Sources/MySQL/Connection/MySQLConnectionHandler.swift:52:158]
Error: Run failed.

But it’s fine when running on the local pc like this.

Thammaporns-MacBook-Pro:practice Thammaporn$ vapor run
Running TILApp6 …
[ INFO ] Migrating ‘mysql’ database (FluentProvider.swift:28)
[ INFO ] Migrations complete (FluentProvider.swift:32)
Running default command: .build/debug/Run serve
Server starting on http://localhost:8080

2

What version of MySQL are you connecting to in digital ocean?

3

I think I’m connecting to MySQL version 8.0.11 .
Please see below .

root@ubuntu-s-1vcpu-1gb-sgp1-01:~# docker exec -it mysql mysql -uvapor -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

4

And my local host pc .
The MySQL version is 5.7.22

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

5

Hello,

I solved it after changing to MySQL version 5.7.
Thanks for your advice.

root@ubuntu-s-1vcpu-1gb-sgp1-01:~/practice# vapor run serve
Running TILApp6 …
[ INFO ] Migrating ‘mysql’ database (MigrationConfig.swift:69)
[ INFO ] Migrations complete (MigrationConfig.swift:73)
Server starting on http://localhost:8080

6

Yeah there are issues with MySQL 8 in Docker!

1 Like