PHP & MySQL

[Etherwood]

Is it possible to create a new database, create new users, and grant permissions using a php INSERT query or does it have to be done at root?

[DH - Tristan Perry]

It's not possible to do this via an INSERT SQL query, no. INSERT is to a row of data into a database table.

I think you'd need to login to your control panel to create a new user, in a standard PHP/MySQL set-up.

[megamoose]

To create a table in MySQL:

$result = mysql_query("CREATE DATABASE mydatabase");

Obviously you have to connect to the MySQL server first, but I'm sure you can do that already. That line above will create a new database. Note that if you are not logging in as the root user (which you should always create a separate user for separate sites/scripts anyway), that you will need to make sure that user has access to create databases.

[ScriptMan]

Originally Posted by Etherwood

Is it possible to create a new database, create new users, and grant permissions using a php INSERT query or does it have to be done at root?

Sounds like you are on a VPS or dedi. If you don't already have phpmyadmin

http://www.phpmyadmin.net/home_page/index.php

why don't you download and install it. For sure to make your life far easier in the long run.

Might be available as a YUM auto install. I did not look to see.

[Hades]

PHP has nothing to do with the type of queries that you run on the DB.

With PHP (or any other language, platform, etc) you can do anything that the database user is allowed to do. So if you are connected to the database with a user that has administrative privileges, you can run any ALTER, CREATE, DROP statements. If you are connected with an account that only has data privileges you can run only INSERTS, UPDATES, DELETES, TRUNCATE, etc.

So the answer to your question is, yes, you can run administrative queries from a PHP script, but you need to know 2 things:
1-if the user that is connecting to the DB has administrative permissions.
2-how to write those administrative queries (they are not INSERTS).

For reference on how to write the DDL SQL commands, suggested reading:
http://dev.mysql.com/doc/refman/5.1/...efinition.html

For reference on how to manage database users:
http://dev.mysql.com/doc/refman/5.1/...anagement.html

[websiteguy]

if you have cpanel than you can create a new database with mysql wizard.
if you are using ssh than you have to login with mysql user make sure you have db creation rights.
command: create database dbname;
also many panels provide your phpmyadmin you can create db and assign rights to user with it