如何使用php shell_exec和sql命令行创建数据库 [英] How to create database using php shell_exec and sql command line

问题描述

我正在尝试使用shell_exec和mysql命令创建数据库.由于多种原因，我不想使用php内置的mysql_query.但是，我无法获得以下命令来成功执行.任何人都可以向我展示出哪里出了问题?

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);

推荐答案

正确的语法如下:

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

或

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

参考: http://www.electrictoolbox.com/run-single-mysql-查询命令行/

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

var_dump($test);

这篇关于如何使用php shell_exec和sql命令行创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！