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.
Let me know if this helped. Follow me on Twitter, Facebook and YouTube, or 🍊 buy me a smoothie.
p.s. I increased my AdSense revenue by 200% using AI 🤖. Read my Ezoic review to find out how.