Local MySQL

root@localhost: vl;!NF6tr1We

root@localhost: root

Get MySQL port

mysql> SHOW GLOBAL VARIABLES LIKE 'PORT’;

Reset root password

https://www.variphy.com/kb/mac-os-x-reset-mysql-root-password (Paths)

https://coolestguidesontheplanet.com/how-to-change-the-mysql-root-password/ (SQL query)

MySql Settings

FIle location:

/etc/my.cnf

Default settings:

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION

Selecting settings

select @@sql_mode;

Reset password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass’;

mysql> FLUSH PRIVILEGES;