Firstly, you must log in as root.
mysql -u root -p
Now you can create a new user. Replace
password with your own.
CREATE USER 'your_username'@'localhost' IDENTIFIED BY 'password';
Now you can grant privileges. Replace
your_password with your own details.
GRANT ALL PRIVILEGES ON your_dbname.* To 'your_username'@'localhost' IDENTIFIED BY 'your_password';
Once you have finalised the permissions that you want to set up for your new users, always be sure to reload all the privileges.
p.s. I increased my AdSense revenue by 200% using AI 🤖. Read my Ezoic review to find out how.