我正在尝试用PHP5连接数据库，它与名为DB的测试连接良好，但它没有'；t具有不同的命名DB - i am trying to connect the database in PHP 5, it connects fine with Test named DB, but it doesn't with different named DB

i am trying to connect the database in PHP 5, it connects fine with Test named DB, but it doesn't with different named DB

本文关键字：连接 DB 数据库测试 PHP5 | 更新日期: 2023-09-27

我正在尝试用PHP连接数据库，我有一个名为TEST的数据库，它成功连接，但当我连接到不同的命名数据库时，它没有。我使用的是PHP 5，语法遵循

<?php
$connection = mysqli_connect("localhost", "$user_name", "$password") or die(mysql_error());
echo "Connected to MySQL<br />";
mysqli_select_db($connection,"$db_name") or die(mysql_error());
echo "Connected to DB <br />";
?>

有什么建议吗？

也许是因为mysql权限？

也许您创建了一个mysql用户，它只能连接到"测试"数据库？

这是一个关于mysql用户和权限的教程。https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql