setup mysql 8

mysql-8-setup.md

setup mysql

sudo mysql_secure_installation

enable remote access

• edit /etc/mysql/mysql.conf.d/mysqld.cnf
• set bind-address

bind-address            = 0.0.0.0

create new user

create user 'ubuntu';
grant all privileges on *.* to 'ubuntu' with grant option;
flush privileges;
alter user ubuntu identified with mysql_native_password by 'secret';

check open port

• https://www.ipfingerprints.com/portscan.php

set root pass

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

CREATE USER 'root'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;