====== MySQL Security ======


==== Creating a New User ====

<code>
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
</code>

Creates a new MySQL user.

==== Granting Permissions ====

<code>
GRANT ALL PRIVILEGES ON my_database.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
</code>
Grants full privileges on my_database to newuser.

==== Revoking Permissions ====

<code>
REVOKE ALL PRIVILEGES ON my_database.* FROM 'newuser'@'localhost';
</code>
Revokes all privileges from newuser.

==== Enabling Secure Connections ====
<code>
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
</code>
Ensures secure authentication.