₦airaland Forum

Can somebody help me with SQL statement on how to create User, Edit and grant a user previledges in MYSQL.

just use mysql administrator

www.mysql.com

download it and fire up

click User Adminitration to the left

and click add user at the bottom right panel

gl

Thanks for your concern. I want to edit and add user using programming language not using their interface.

I suggest you try using phpmyadmin or MYSQL ADMIN

but in the mean while:
Create User with :
GRANT USAGE ON * . * TO 'user'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

Grant privileges with :

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , FILE , INDEX , ALTER , CREATE TEMPORARY TABLES ON * . * TO 'user'@'localhost'
IDENTIFIED BY '********'
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0

If you use a cpanel just go to the option
MYSQL DATABASES then create a database, create a user and assign the user to a database and grant permission to the user.