When I try to connect MySQL 5.7 I get the following error
Example:
Solution:
Try to use Dbforge Studio Latest Version
Or
Keep the show_compatibility_56 always ON in MySQL.
Add the following line to the [mysqld] section of your MySQL configuration file (my.cnf or my.ini):
show_compatibility_56 = On
Then restart the MySQL server:service mysql restart
Or
Keep the Temperary show_compatibility_56 ON in MySQL.
You must be logged with a user with super privileges in order to perform this action(Command line).
Run the following query in your MySQL database:
set @@global.show_compatibility_56=ON;
0 Comments