AimyThomas's Avatar

While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access levels for them in MySQL?

Secondly, if a website does not offer PHP Admin, how can I use a database I created in phpMyAdmin on my PC for that website?

Thank in Advance
anthonyemuobo's Avatar, Join Date: Mar 2015
Newbie Member
Generating User is easy with MySQL as it is easy in phpmyadmin. The format for creating users is:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

and after creating the user we use to the below syntax to grant privileges.

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

Hope this helps.