| by Scott Kilroy

How To Create a New User and Grant Permissions in MySQL

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…

Share Button
Read More
| by Scott Kilroy

How to Fix “MySQL ERROR 1819 (HY000):” in Linux

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…

Share Button
Read More
| by Scott Kilroy

Basic MySQL Security

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;

Share Button
Read More
| by Scott Kilroy

Optimize and repair all mysql tables

mysqlcheck -o -u root -p –all-databases

Share Button
Read More
| by Scott Kilroy

Reset the mysql root password

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

Share Button
Read More