Menu
Community /Pin to ProfileBookmark
@NogDogJan 24.2011 — #Just in case: be aware that many web hosting plans to not allow you to create users via scripts: you have to use whatever control panel mechanism they give you for doing so. But if that is not an issue for you, see:
[url=http://dev.mysql.com/doc/refman/5.1/en/account-management-sql.html]Account Management Statements[/url] @NogDogJan 24.2011 — #
Yeah, what they normally do is only grant permissions for creating databases and users to the MySQL user that their control panel tool uses -- no other DB users can be given those permissions. It can be a bit of a pain, but it is probably a good security configuration, especially in any sort of shared hosting situation where multiple site users are using the same DB host.
How to create database users, etc
Hi,
Can someone pls let me know how to create MySQL users and assign users to created databases.
Ideally with plain SQL queries, instead using CPanel scripts etc.
Thank you.
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogJan 24.2011 — #Just in case: be aware that many web hosting plans to not allow you to create users via scripts: you have to use whatever control panel mechanism they give you for doing so. But if that is not an issue for you, see:0
@NogDogJan 24.2011 — #Thanks for the reply and as you said, it seems to be blocked by the web host.[/QUOTE]
Yeah, what they normally do is only grant permissions for creating databases and users to the MySQL user that their control panel tool uses -- no other DB users can be given those permissions. It can be a bit of a pain, but it is probably a good security configuration, especially in any sort of shared hosting situation where multiple site users are using the same DB host.