Database Actions

[webdes03]

I was wondering if anyone would know how to go about adding a new mysql user through a PHP script. Something I could put in a website that would create a user for mysql when given username and password variables?

How does a utility like CPanel go about creating Databases, Users, and setting user permissions. Thats basically what I'm trying to do, but I have no idea where to start.

Any help is appreciated.
Thanks.

[LordShryku]

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users

It's just SQL statements...

[webdes03]

My hitch is that I want to do it through QUERY statements. That tells you how to do it from the mysql prompt on the "machine MySQL is running on". Any idea how to do it through query statements?

[LordShryku]

1) Don't double post. It's really annoying.
2) Those statement it shows you don't have to be from the local machine. You can run those rom anywhere, given that the user you are using has access to do it.

[webdes03]

My appologies, I misread the link you sent. Thanks for the help.