Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,939 members, 7,956,550 topics. Date: Monday, 23 September 2024 at 01:48 PM |
Nairaland Forum / Science/Technology / Programming / Sql Statement On How To Create Users In Mysql Help! (3084 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)
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)
Can Not Run My Applet In A Web Browser / Kivy Vs Android Studio Which Is The Best For Android App Development? / My Portfolio Projects
(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. 8 |