MariaDB to MySQL 80 on FreeBSD

service mysql-server stop

cd /usr/ports/databases/mariadb104-server/
make deinstall clean

cd /usr/ports/databases/ mariadb104-client/
make deinstall clean

pkg autoremove

pkg search mariadb

pkg delete -x  mariadb

rm -rf /var/db/mysql/

cd /usr/ports/databases/mysql80-server
make rmconfig

cd /usr/ports/databases/mysql80-server
make install  clean

service mysql-server start

service mysql-server status

mysql_secure_installation

mysql -u root -p
create database db;
CREATE USER 'wpuser'@'localhost' IDENTIFIED  WITH mysql_native_password  BY 'passwd';
GRANT ALL PRIVILEGES ON db.* TO 'wpuser'@'localhost';
FLUSH PRIVILEGES;
exit;

mysql -u root -p
SELECT user, host FROM mysql.user;
DROP USER  'wpcsd'@'localhost';