how-do-i-automatically-create-users-in-mysql

Asked by:
MtKuile / 41 Points
Time:
2013-09-16 4:43 pm EST
Category:
Databases
Hits:
290
I would like new users to be automatically accepted to use my MySQL database service by having access rights to the MySQL database pre-set for every new registrant. How can I do that?

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

arnelc
Staff
13,461 Points
2013-09-16 5:23 pm EST
Hello MtKuile,

Thanks for the question. Apologies but we do not provide coding solutions for requests of this nature. We do try to point you in the right direction. Your request would require that you have a way to input new users through a front-end interface. The user creation request would then automatically add the user with a preset access level so that they can access the database as required via other web-based interfaced that you would need to create. The database is a back-end component to the website, so you would need to create front-end interface that interact with your website visitors.

You can find more information on this type of issue by looking at Adding User accounts in Mysql. The programming for the front-end of the website will depend upon what you wish to use to develop these interfaces. For example, you could learn PHP5 or use HTML 5.

I hope this helps to get you the information you need to accomplish your programming goals.

Regards,
Arnel C.

To submit a comment on this answer, please first login.

0

JacobN
Staff
3,661 Points
2013-09-16 5:27 pm EST
Hello MtKuile,

This wouldn't be possible as in order to create additional MySQL users you'd need to create a MySQL user in cPanel which can't be called directly from another script.

If instead you're using a CMS such as WordPress, these have the ability to allow users to register themselves to create users in WordPress. But if you're trying to grant users direct MySQL database access, this wouldn't be doable.

Please let us know if you had any further questions.

- Jacob

To submit a comment on this answer, please first login.

Want to share this Question?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.