My Blog
Scroll Down
Add new mysql user to specific mysql database with console
Easily add a new mysql user (to protect the root user) on a specific basis:
You don't need to do it from PHPMYADMIN
Open a console and:
mysql -u yourusername -p write password and press enter CREATE USER 'newusername'@'localhost' IDENTIFIED BY 'passwordofnewuser'; GRANT ALL PRIVILEGES ON YOURDATABASENAME.* TO 'newusername'@'localhost'; exit
This post is also available in:
Ελληνικά
01.