in the file “my.cnf” in the [mysqld] section default_time_zone=’+00:00′
Category Archives: MySQL
Cannot load from mysql.proc. The table is probably corrupted
After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat:
Sorting a VARCHAR column as FLOAT using the CAST operator
Solution 1 SELECT guid, number FROM table ORDER BY number * 1 DESC
Plesk 11.0 to 11.5 Upgrade
ERROR while trying to upgrade APSC SQL database from 11.1.0
mysql unknown variable ‘init_connect=set names utf8’
To set the default to UTF-8, you want to add the following to my.cnf
mysql cli dump and repair commands
some usefull mysql commands for cli