Sql Statement On How To Create Users In Mysql Help!

A Member? Please Login  
type your username and password to login
Date: October 14, 2008, 11:26 AM
249695 members and 148383 Topics
Latest Member: awhyher
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Programming  |  Sql Statement On How To Create Users In Mysql Help!
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: Sql Statement On How To Create Users In Mysql Help!  (Read 620 views)
luckyCO
Sql Statement On How To Create Users In Mysql Help!
« on: February 10, 2007, 07:50 PM »

Can somebody help me with SQL statement on how to create User, Edit and grant a user previledges in MYSQL.
Cactus (m)
Re: Sql Statement On How To Create Users In Mysql Help!
« #1 on: February 11, 2007, 04:12 PM »

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
luckyCO
Re: Sql Statement On How To Create Users In Mysql Help!
« #2 on: February 12, 2007, 09:58 AM »

Thanks for your concern. I want to edit and add user using programming language not using their interface.
kengimel (m)
Re: Sql Statement On How To Create Users In Mysql Help!
« #3 on: February 12, 2007, 10:01 AM »

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
MDS-ADMIN (m)
Re: Sql Statement On How To Create Users In Mysql Help!
« #4 on: February 14, 2007, 04:06 PM »

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.
 Article: Why A Career In Computer Programming Sucks  Who Do You Consider When Writing A Program?  Tutorials On C++  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 
Google
 
Web www.nairaland.com
Sections: TV/Movies (2) Music/Radio (2) Celebrities Job Talk Jobs/Vacancies (2) Career Talk Romance Books Politics Sports Fashion Travel
Health Schooling Religion General(2) Business Webmaster Programming Computers Phones Cars & Trucks

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.