How to create database using php shell_exec and sql command line

Question

i am trying to create a database using shell_exec and mysql commands. I do not want to use php built-in mysql_query because of severals reasons. However, i cant get the below command to execute successful. Anyone can show me some light on what went wrong?

$test = shell_exec("mysql -u root -pmypassword create database db_hello;");

var_dump($test);

shell_exec should be disabled, I don't think this is a good idea, I'd never do it. — markus
– markus, Commented Jun 7, 2012 at 23:21
@markus-tharkun along with exec(), passthru() and system() — user1403947
– user1403947, Commented Jun 7, 2012 at 23:24

score 8 · Accepted Answer · 2012-06-07 23:22:05Z

8

The correct syntax is like this:

mysql -u [username] -p -e "create database somedb"

Or

mysql --user=user_name --password=your_password -e "SELECT 1 FROM information_schema.tables"

Reference: http://www.electrictoolbox.com/run-single-mysql-query-command-line/

$cmd = escapeshellcmd('mysql -u [username] -p -e "create database somedb"');
$test = shell_exec($cmd);

var_dump($test);

edited Jun 7, 2012 at 23:22

answered Jun 7, 2012 at 23:15

user1403947

Sign up to request clarification or add additional context in comments.

3 Comments

Slay Over a year ago

the command is ok when i run it through mysql command line, however, it i run it through php it does not work

Slay Over a year ago

tried your code in php, it doesnt seems to work. return NULL.

Slay Over a year ago

Thank you all. Decided to use mysql_query instead.

Benoit · Accepted Answer · 2013-10-16 14:11:09Z

0

The issue might be the path to mysql in your php script. For me was : /usr/local/bin/mysqld (osx 10)

answered Oct 16, 2013 at 14:11

Benoit

3213 silver badges4 bronze badges

Collectives™ on Stack Overflow

How to create database using php shell_exec and sql command line

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related