Sql Statement On How To Create Users In Mysql Help!

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 24, 2009, 12:54 PM
431821 members and 298812 Topics
Latest Member: veron80
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 1165 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.
 Microsoft Launches Silverlight: An Alternative To Flash  What's new in PHP 5 and PHP 6  Java Server Pages (jsp) Or Java Server Face(jsf Which Path To Trend? ? ? ?  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

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

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.