thinkphp连接不上mysql

return [
    // 数据库类型
    'type' => 'mysql',
    // 服务器地址
    'hostname' => '127.0.0.1',
    // 数据库名
    'database' => 'your_database_name',
    // 用户名
    'username' => 'your_username',
    // 密码
    'password' => 'your_password',
    // 端口
    'hostport' => '3306',
    // 其他配置...
];

GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'localhost';
FLUSH PRIVILEGES;

sudo systemctl status mysql

sudo systemctl start mysql

ping your_mysql_server_ip

<?php
namespace app\index\controller;

use think\Controller;
use think\Db;

class Index extends Controller
{
    public function index()
    {
        try {
            $data = Db::table('your_table_name')->select();
            return json($data);
        } catch (\Exception $e) {
            return json(['error' => $e->getMessage()], 500);
        }
    }
}