Laravel 5.6 MySQL 服务器已经消失

在使用 Laravel 5.6 开发项目时，你可能会遇到 MySQL 服务器已经消失的问题。这个问题的出现通常是由于配置错误、网络连接问题或服务器故障引起的。在本文中，我们将介绍如何解决这个问题，并提供一些案例代码以帮助你更好地理解。

php
'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => true,
    'engine' => null,
],

bash
telnet [数据库服务器地址] [数据库服务器端口]

bash
Trying [数据库服务器地址]...
Connected to [数据库服务器地址].
Escape character is '^]'.

bash
sudo service mysql status

bash
mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since [日期时间]
 Main PID: [PID]
    Tasks: [任务数]
   Memory: [内存占用]
      CPU: [CPU 占用]
   CGroup: /system.slice/mysql.service
           └─[PID] /usr/sbin/mysqld --daemonize --pid-file=[PID 文件路径]

php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class UserController extends Controller
{
    public function index()
    {
        try {
            $users = DB::table('users')->get();
            return response()->json($users);
        } catch (\Exception $e) {
            return response()->json(['error' => $e->getMessage()], 500);
        }
    }
}