Webmaster2020.com

I got the message in my logs /var/log/mysql/error.log
Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

So how to fix this ?
On MySQL 8.0.34 through 8.3, you get this warning.
After ...

The event_Scheduler is, a way to Schedule Events (in this case queries) to run in MySQL at a given time.
It is simply waiting for an event to trigger it.

It is enabled by default, but can be disabled by running:
SET @@global.event_scheduler = 0;

or add it to my.conf of /etc/mysql/mysql.conf.d ...

Grep thinks that it is binary file for some reason,
and doesn't process it.
Maybe there are some special characters in the txt file.

You can solve it by forcing:
grep --text
grep -a
or grep --binary-files=text

The certificate on your server is part of a chain.
Many time the are delivered as separated files.
Something like : server.cert and server.ca-bundle

For dovecot, it easier to put them 1 file (order is important ! ).
And add the file in
/etc/dovecot/conf.d/10-ssl.conf
ssl_cert = </etc/ssl/private ...

The problem is that the key has expired.
You need to update it, but do it form a trustwordy source.

from Ubuntu

Code: Select all

apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys B7B3B788A8D3785C

Or from Mysql:

Code: Select all

wget -qO - https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 | sudo apt-key add -

You first should check why you have a duplicated key.

You can use INSERT IGNORE command rather than the INSERT command.
If a record doesn't duplicate an existing record, then MySQL inserts it as usual. If the record is a duplicate, then the IGNORE keyword tells MySQL to discard it silently without ...

You can install php-fpm,
best is to install the others also
apt-get install php php-cli php-common php-fpm php-mysql

To enable PHP support for Lighttpd.
you need to modify the php.ini file
nano /etc/php/7.4/fpm/php.ini
Change cgi.fix_pathinfo value to 1:
cgi.fix_pathinfo=1

By default, PHP ...

You first have to drop the current primary key,
and after create a new.
Best is to do it in 1 SQL alter statement.

Code: Select all

ALTER TABLE table_name DROP primary key, ADD primary key(k1, k2, k3);

You can send a task to the background,
with &. (and symbol)

Code: Select all

#command to the background
ls -la /home &

#get the process id
P1=$!;

#wait for it to finish
wait $P1;

I personaly like versio.nl.
It is a provider based in the Netherlands (Europe).
Good and fast service.

For more info about what types of hosting there are:
https://www.webmaster2020.com/hosting/

Webmaster2020.com

Search found 212 matches

Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. P

Re: event_scheduler ?

Re: grep : binary file matches

Re: Linux fetchmail showing error

Re: Update problem ?

Re: PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate entry

Re: install lighttp with php

Re: change primary key

Re: Run commands parallel

Re: What are some good hosting providers?