如何修复数据库连接错误

爱被打了一巴掌 2022-12-06 15:38 152阅读 0赞

You use PHP and [MySQL][] together seamlessly on your website. This one day, out of the blue, you get a database connection error. Although a database [connection][] error could indicate a bigger problem, it is usually a result of one of a few scenarios:

您可以在网站上无缝地同时使用PHP和[MySQL][] 。 这一天，出乎意料的是，您遇到数据库连接错误。 尽管数据库[连接][connection]错误可能表明存在更大的问题，但这通常是以下几种情况之一的结果：

## 昨天一切都很好 **(** Everything Was Fine Yesterday **)** ##

You could connect yesterday and haven't changed any code in your script. Suddenly today, it's not working. This problem probably lies with your web host. Your hosting provider may have the databases offline for maintenance or because of an error. Contact your web server to see if that is the case and, if so, when they are expected to be back up.

您可以在昨天连接，并且未更改脚本中的任何代码。 今天突然，它不起作用。 此问题可能出在您的虚拟主机上。 您的托管服务提供商可能使数据库脱机以进行维护或由于错误。 请与您的Web服务器联系，以查看是否存在这种情况，如果是，则应在何时进行备份。

## 糟糕！ **(** Oops! **)** ##

If your database is on a different URL than the PHP file you are using to connect to it, it could be that you let your domain name expire. Sounds silly, but it happens a lot.

如果您的数据库使用的URL与用于连接数据库PHP文件位于不同的URL，则可能是因为您的域名过期了。 听起来很傻，但是它经常发生。

## 我无法连接到本地主机 **(** I Can't Connect to Localhost **)** ##

Localhost doesn't always work, so you need to point directly to your database. Often it's something like mysql.yourname.com or mysql.hostingcompanyname.com. Replace "localhost" in your file with the direct address. If you need help, your web host can point you in the right direction.

Localhost并非总能正常工作，因此您需要直接指向数据库。 通常它类似于mysql.yourname.com或mysql.hostingcompanyname.com。 用直接地址替换文件中的“ localhost”。 如果您需要帮助，您的虚拟主机可以为您指明正确的方向。

## 我的主机名不起作用 **(** My Host Name Won't Work **)** ##

Double-check your username and password. Then, triple-check them. This is one area people often overlook, or they check so quickly they don't even notice their mistake. Not only do you need to check that your credentials are correct, you should also make sure you have the correct permissions required by the script. For example, a read-only user can't add data to the database; write privileges are necessary.

仔细检查您的用户名和密码。 然后，对它们进行三重检查。 这是人们经常忽略的领域，或者他们检查得如此之快，甚至没有注意到自己的错误。 您不仅需要检查凭据是否正确，还应确保您具有脚本所需的正确权限。 例如，一个只读用户不能将数据添加到数据库中。 写特权是必要的。

## 数据库损坏 **(** The Database Is Corrupt **)** ##

It happens. Now we're entering the territory of a bigger problem. Of course, if you keep your database backed up regularly, you're going to be all right. If you know how to restore your database from a backup, by all means, go ahead and do it. However, if you've never done this, contact your web host for help.

它发生了。 现在我们进入一个更大的问题领域。 当然，如果定期备份数据库，一切都会好起来的。 如果您一定知道如何从备份还原数据库，请继续进行。 但是，如果您从未这样做过，请与您的网络主机联系以寻求帮助。

## 在phpMyAdmin中修复数据库 **(** Repairing a Database in phpMyAdmin **)** ##

If you use [phpMyAdmin][] with your database, you can repair it. Before you begin, make a backup of the database—just in case.

如果对数据库使用[phpMyAdmin][] ，则可以修复它。 在开始之前，请备份数据库，以防万一。

1.  Log in to your web server.
    
    登录到您的Web服务器。
2.  Click the phpMyAdmin icon
    
    单击phpMyAdmin图标
3.  Choose the affected database. If you only have one database, it should be chosen it by default.
    
    选择受影响的数据库。 如果只有一个数据库，则默认情况下应选择它。
4.  In the main panel, you should see a list of the database tables. Click **Check All**.
    
    在主面板中，您应该看到数据库表的列表。 单击**全部检查** 。
5.  Choose **Repair Table** from the drop-down menu.
    
    从下拉菜单中选择**修复表** 。

> 翻译自: [https://www.thoughtco.com/fix-database-connection-error-2694192][https_www.thoughtco.com_fix-database-connection-error-2694192]

[MySQL]: https://www.thoughtco.com/mysql-tutorial-managing-mysql-data-2693880
[connection]: https://www.thoughtco.com/mysql-connect-files-in-php-2694111
[phpMyAdmin]: https://www.thoughtco.com/use-phpmyadmin-for-your-database-2693965
[https_www.thoughtco.com_fix-database-connection-error-2694192]: https://www.thoughtco.com/fix-database-connection-error-2694192