mysql

MySQL

Setting up a testing environment

Setup MySQL for Ubuntu 17.10

• https://www.computerbeginnersguides.com/blog/2017/10/27/install-configure-mysql-server-on-ubuntu-17-10-artful-aardvark/
• alternatives: MariaDB for Fedora 27 and MySQL for Fedora 27

Create user

• https://stackoverflow.com/questions/5016505/mysql-grant-all-privileges-on-database

• log in to mysql: mysql -u root -p

• create user 'ryan'@'%' identified by 'XXXX';

• grant all privileges on *.* to 'ryan'@'%'; (optional with grant option`)

• flush privileges

• edit /etc/mysql/mysql.conf.d/mysql.cnf: in section [mysqld] add bind-address = 0.0.0.0

• restart: sudo systemctl restart mysql

Protocol references

Protocol:

• https://dev.mysql.com/doc/internals/en/client-server-protocol.html
• https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_PROTOCOL.html

Authentication:

• sha2 authentication:
  • https://dev.mysql.com/doc/dev/mysql-server/latest/page_caching_sha2_authentication_exchanges.html
  • https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
  • https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/
• MariaDB: https://mariadb.org/history-of-mysql-mariadb-authentication-protocols/

X Protocol:

• https://mysqlserverteam.com/mysql-5-7-12-part-3-more-than-just-sql/