Depending on the nature of the script, you may need control of the delimiter used to separate the statements that will make up a script. The most common example of this is where you have a multi-statement stored routine as part of your script. In this case if the default delimiter of “;” is used . . .
Today we consider the organization of SSH tunneling through PUTTY to MySQL. Some programs require a connection to the database MySQL. For example mysql.exe console or other tools to work with databases of online stores or websites or MySQL IDE. Very often, in the application, which requires a connection to the database MySQL, there are . . .
Problems with MySQL 5.7.8-rc. In different situations, when you run queries or connect to MySQL database you get an error: ERROR 3167 (HY000): The ‘INFORMATION_SCHEMA.GLOBAL_VARIABLES’ feature is disabled; see the documentation for ‘show_compatibility_56’ To resolve the problem you must set ON global variable show_compatibility_56. Connect to MySQL database via console and execute the command: SET . . .