Database Server

[How To] Update or Change MySQL database timezone

mysql logo

Sometimes you need to change the timezone used by MySQL database for some  specific applications or globally. The below steps will guide you to change the MySQL time zone: 1) Check time_zone* tables in mysql database. If it is empty then insert Zone Info data using following command  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root …

Read More »

Plesk error Table ‘mysql.servers’ doesn’t exist

mysql logo

If  you are using Plesk and MySQL you may get a error while adding a MySQL database user to a database as Error: Connection to the database server has failed: Table ‘mysql.servers’ doesn’t exist     To fix this error, SSH  the server as a root user. Execute the command [[email protected] ~]# mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose On executing the …

Read More »