MySQL

The number of characters in a word when searching for a FULLTEXT key. The ft_min_word_len parameter.

Base of automobile tires and disks. The database contains: manufacturer, model, year, modification, PCD, diameter, nut, tire and wheel factory sizes, possible replacement options, tire and wheel tuning. There are no trucks in the database.

Consider setting up MySql 5.7 access on Ubuntu 18.04. Let's define the mysql root user on the local machine, set the root password for him, consider changing the password length and restrictions on it.

What to do if the error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db.books' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by