Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,150,312 members, 7,808,051 topics. Date: Thursday, 25 April 2024 at 06:02 AM

Sql Statement On How To Create Users In Mysql Help! - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Sql Statement On How To Create Users In Mysql Help! (3057 Views)

How To Solve Multiple Foriegn Key In Mysql / Capture Image From Webcam And Store In Mysql Database From C Sharp Winform / Php/mysql Help:how To Run Sql Query From A Link (2) (3) (4)

(1) (Reply) (Go Down)

Sql Statement On How To Create Users In Mysql Help! by luckyCO(m): 7:50pm On Feb 10, 2007
Can somebody help me with SQL statement on how to create User, Edit and grant a user previledges in MYSQL.
Re: Sql Statement On How To Create Users In Mysql Help! by Cactus(m): 4:12pm On Feb 11, 2007
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
Re: Sql Statement On How To Create Users In Mysql Help! by luckyCO(m): 9:58am On Feb 12, 2007
Thanks for your concern. I want to edit and add user using programming language not using their interface.
Re: Sql Statement On How To Create Users In Mysql Help! by kengimel(m): 10:01am On Feb 12, 2007
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
Re: Sql Statement On How To Create Users In Mysql Help! by MDSADMIN(m): 4:06pm On Feb 14, 2007
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.

(1) (Reply)

Software Development / Mason: A Java Json Parser That Works / Cost Of Building An Android App For A Magazine

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 9
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.