douhao9203 2017-02-01 05:23
浏览 33

无法在服务器上使用PHP创建MySQL数据库?

I am just trying to create database using PHP but not creating.It giving me following error :

Access denied for user 'user'@'localhost'

I am using cPanel ,where i created a user with all privileges & this user assigned to a specific database

I am working on SaaS Application (i.e. multiple database & single codebase).

Please help me to solve this problem.

Code I am using

   $dbhost = 'localhost:3306';
   $dbuser = 'xyz';
   $dbpass = 'xyz123';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);

   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   echo 'Connected successfully';

   $sql = 'CREATE Database test_db';
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die('Could not create database: ' . mysql_error());
   }

   echo "Database test_db created successfully
";
   mysql_close($conn);
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 关于URL获取的参数,无法执行二选一查询
    • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
    • ¥15 marlin编译错误,如何解决?
    • ¥15 有偿四位数,节约算法和扫描算法
    • ¥15 VUE项目怎么运行,系统打不开
    • ¥50 pointpillars等目标检测算法怎么融合注意力机制
    • ¥20 Vs code Mac系统 PHP Debug调试环境配置
    • ¥60 大一项目课,微信小程序
    • ¥15 求视频摘要youtube和ovp数据集
    • ¥15 在启动roslaunch时出现如下问题