Hello ,
after three days and nights just give up, i change a system for ubuntu to mint and back couple of times , and still getting TMySQL57Connection : Server connect failed.
have no more ideas .
If someone can help me please.
Regards
Arek EI9GWB
this is mysql file
[mysqld]
# Use UTF-8 encoding for tables
character_set_server=utf8
collation_server=utf8_bin
# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
# Deprecated in MySQL >= 5.6.3
#innodb_additional_mem_pool_size=1M
# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
# Larger values means less I/O
innodb_buffer_pool_size=80M
# Create a .ibd file for each table (default:0)
innodb_file_per_table=1
# Write out the log buffer to the log file at each commit (default:1)
innodb_flush_log_at_trx_commit=2
# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
# larger values means less I/O
innodb_log_buffer_size=1M
# error log file name, relative to datadir (default:hostname.err)
log_error=mysql.err
# print warnings and connection errors (default:1)
log_warnings=2
# Convert table named to lowercase
lower_case_table_names=1
# Maximum size of one packet or any generated/intermediate string. (default:1M)
max_allowed_packet=32M
# Maximum simultaneous connections allowed (default:100)
max_connections=256
# The two options below make no sense with prepared statements and/or transactions
# (make sense when having the same query multiple times)
# Memory allocated for caching query results (default:0 (disabled))
query_cache_size=0
# Do not cache results (default:1)
query_cache_type=0
# Do not use the privileges mechanisms
skip_grant_tables
# The number of open tables for all threads. (default:64)
table_open_cache=200
# How many threads the server should cache for reuse (default:0)
thread_cache_size=3
# wait 365d before dropping the DB connection (default:8h)
wait_timeout=31536000
[client]
default-character-set=utf8




Hi!
My strong guess is that you have Mysql installed instead of MariaDB. That is so common problems with faulty install packets from Ubuntu based systems.
Check your ~/.config/cqrlog/database/mysql.err file.
The file you have included is mysql.cnf and that does not show anything for this problem.
At the beginning of mysql.err file you will find a line where there is something like "starting Mysql 8.0......"
That tells you have wrong Mysql
There should be "starting MariaDB". If that is found then the problem needs more investigation.
Otherwise install MariaDB that overrides Mysql. There are lot of messages here about same subject.
--
Saku
OH1KH