The post How to Setup MySQL Master-Slave Replication on RHEL 8 first appeared on Tecmint: Linux Howtos, Tutorials & Guides .
MySQL Replication is a process where data from one server is automatically copied or replicated onto another backup server in r…
MySQL is a popular and widely used database management system that stores and organizes data and allows users to retrieve it. It comes with a vast array of options that grant users certain permissions
The post How To Create a New User and Grant Permiss…
When creating a MySQL user with a relatively weak password, you might encounter the error ‘MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements’. Technically, this is not an error,
The post How to Fix “MySQL ERROR 18…
After installing MySQL Set the root passwoord using mysqladmin -u root password new-password login as root and run the following comands drop database test; use mysql; delete from db; delete from user where not (host=”localhost” and user=”root”); flush privileges;
Stop the mysql daemon Restart mysql using the command mysqld_safe –skip-grant-tables Now you should be able to connect as root Once connected run the following: update user set Password=PASSWORD(‘new-password’) where user=’root’; then flush privileges exit mysql restart mysql and you should be able to login with the new password