在CentOS上配置PHP的数据库连接,通常涉及以下几个步骤:
安装PHP和数据库服务器:
sudo yum install php php-mysqlnd
sudo yum install mysql-server
或 sudo yum install mariadb-server
启动并启用数据库服务:
sudo systemctl start mysqld
或 sudo systemctl start mariadb
sudo systemctl enable mysqld
或 sudo systemctl enable mariadb
安全配置数据库:
sudo mysql_secure_installation
创建数据库和用户:
mysql -u root -p
CREATE DATABASE your_database_name;
CREATE USER 'your_username'@'localhost' IDENTIFIED BY 'your_password'; GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'localhost'; FLUSH PRIVILEGES;
配置PHP连接数据库:
index.php
),使用PDO或mysqli扩展来连接数据库。使用PDO连接:
<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// 设置PDO错误模式为异常
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>
使用mysqli连接:
<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
测试连接:
配置防火墙(如果需要):
sudo firewall-cmd --permanent --zone=public --add-service=http
sudo firewall-cmd --permanent --zone=public --add-service=mysql
sudo firewall-cmd --reload
通过以上步骤,你应该能够在CentOS上成功配置PHP的数据库连接。