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.
todd12345's Avatar, Join Date: Sep 2015
Go4Expert Member
PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.
MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.