Update root password MySQL
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; »
Find duplicate rows MySQL
A nice simple query to find duplicate rows in MySQL: SELECT COLUMN_NAME, COUNT(*) c FROM TABLE GROUP BY COLUMN_NAME HAVING c > 1; Credit »
Create MySQL docker container and access externally
If you have a fairly simple setup with one network card and would like a MySQL container bound to both the internet docker IP and the »
Change/update MySQL password
To change the MySQL password for a particular user first login to MySQL: mysql -u root -p Next update the appropriate user's password with the following »
Disable/Enable MySQL Password Validation
If you are having issues with MySQL password validation, you can run the following commands to disable it: mysql -u root -p uninstall plugin validate_password; »
