Проблема с временной зоной в mysql

Такую ошибку я получил при попытке подключить localhost в DBeaver. The server time zone value ” is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support….

Read more...

Problem with phpMyAdmin and PHP 7.2

It’s possible that when you installed phpMyAdmin, the version in the repository (phpMyAdmin v4.6.6) was not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.8 as of writing), which fixes these compatibility issues with PHP 7.2.

Read more...

MySQL CLI Cheat Sheet

show databases; – показывает все базы данных create database sport; – создаёт базу данных `sport` use sport; – использовать базу дынных `sport` set names utf8 collate utf8_unicode_ci; SHOW TABLE STATUS; – shows information about all table in db, including collation. show full columns from post; Collation SHOW TABLE STATUS; – shows information about a table,…

Read more...