Solution of the error “Using unique option prefix pass instead of password is deprecated …”

I noticed some errors coming to the root mail with the subject and the text: Cron /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. The problem lies in the file ~ / .my.cnf, […]

How to fix error “Table ‘name’ is marked as crashed and last (automatic?) repair failed”

Once in the FreeRADIUS logs I noticed a MySQL error: Table ‘./radius/radacct’ is marked as crashed and last (automatic?) repair failed As it turned out, the radacct table was damaged, since the data there were not particularly important, then the entire table was cleaned. You can clean up via phpMyAdmin or SQL query: A bit […]

How to change MySQL database encoding and its tables

Here is an example of changing the MySQL encoding of a database and tables. Before any actions on important data it is necessary to make a backup copy, for example: For the test, we will connect to MySQL and create a couple of new databases without specifying the encoding and specifying: Create a test table […]

How to create a MySQL user and configure access rights

To create a user, we first connect to the MySQL server console: Let’s see what users are: Create a user (where localhost is specified from where the user can connect, you can specify the IP address, localhost – from the local machine where the MySQL server itself, or % from any addresses): If you intend […]

The solution of error “ERROR 1067 (42000) at line 211: Invalid default value for ‘blablabla'”

I noticed once when importing a sql file the following error: ERROR 1067 (42000) at line 211: Invalid default value for ‘blablabla’ It arises because new versions of MySQL server use strict mode and parameters such as NO_ZERO_DATE do not allow entering date values like ‘0000-00-00’ into the database. Connect to mysql server: Execute a […]