Php shell_exec unable to run mysql commands?

Question

Referencing this post as well(How to create database using php shell_exec and sql command line)

I've followed the accepted answer in that post, but I am curious as to why the shell_exec is unable to run mysql code. It merely returns NULL.

The user already has sudo access, when i copy the following command line into the console log manually it works.

$cmd = escapeshellcmd('sudo mysql -u root -e "create database somedb"');
$test = shell_exec($cmd);

var_dump($test);

Edit 1: Updated [username], if root may cause some issues

A better way to create a database would be to use mysqli or pdo to do so in PHP rather than using shell_exec. — atymic
– atymic, Commented Jul 19, 2019 at 3:59
sorry was a formatting issue, the cmd was hidden cause i had it inline with the triple ( ` ) — James Yong
– James Yong, Commented Jul 19, 2019 at 4:07

John.M · Accepted Answer · 2019-07-19 04:16:03Z

0

You will need to use the full path to mysql

Type whereis mysql to find it.

It will most likely be /usr/bin/mysql

Change your command to:

$cmd = escapeshellcmd('sudo /usr/bin/mysql -u [username] -e "create database somedb"');

You may need full path to sudo .. same principles will apply.

answered Jul 19, 2019 at 4:16

John.M

3632 silver badges11 bronze badges

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

1 Comment

James Yong Over a year ago

tried the suggested command but it didnt work, still returned null,but im sure the path is correct because when i run it in the console directly, it works.

Collectives™ on Stack Overflow

Php shell_exec unable to run mysql commands?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related