RHEL 5 安装Mysql

安装：

[root@localhost Server]# ls mysql*
mysql-5.0.22-2.1.i386.rpm                  mysql-devel-5.0.22-2.1.i386.rpm
mysql-bench-5.0.22-2.1.i386.rpm            mysql-server-5.0.22-2.1.i386.rpm
mysql-connector-odbc-3.51.12-2.2.i386.rpm  mysql-test-5.0.22-2.1.i386.rpm
[root@localhost Server]# rpm -ivh mysql-5.0.22-2.1.i386.rpm 
warning: mysql-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
error: Failed dependencies:
        perl(DBI) is needed by mysql-5.0.22-2.1.i386
[root@localhost Server]# rpm -ivh perl-DBI-1.52-1.fc6.i386.rpm 
warning: perl-DBI-1.52-1.fc6.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:perl-DBI               ########################################### [100%]
[root@localhost Server]# rpm -ivh mysql-5.0.22-2.1.i386.rpm 
warning: mysql-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:mysql                  ########################################### [100%]
[root@localhost Server]# rpm -ivh mysql-server-5.0.22-2.1.i386.rpm 
warning: mysql-server-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
error: Failed dependencies:
        perl-DBD-MySQL is needed by mysql-server-5.0.22-2.1.i386
[root@localhost Server]# rpm -ivh perl-DBD-MySQL-3.0007-1.fc6.i386.rpm 
warning: perl-DBD-MySQL-3.0007-1.fc6.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:perl-DBD-MySQL         ########################################### [100%]
[root@localhost Server]# rpm -ivh mysql-server-5.0.22-2.1.i386.rpm 
warning: mysql-server-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
1:mysql-server           ########################################### [100%]
[root@localhost Server]# 

　　安装完成后，执行msqld start，第一次启动数据库，会提示建库之类的，属于初始建立。

利用mysql -uroot对数据库进行测试，一切OK.

但是，写了如下一个php程序，测试php与数据库的连接，却出现问题

<?php
$host="localhost";
$user="root";
$pass="";

$conn=mysql_connect($host,$user,$pass);

?>

　　总是说什么T_VAR之类的错误。以为是php与mysql之间缺少rpm模块呢，就又装了php-sql.rpm模块。但还是不行。

仔细检查了/etc/php.d下面，已经有了mysql的配置，说明php与数据库的关联已经正常了，试了很多办法，无效。最后，重新启动机器，再试，一切OK!

在/var/www/html下写了一个index.php,测试了一下,OK!

<?php
$host="localhost";
$user="reader";
$pass="eader";

$conn=mysql_connect($host,$user,$pass);
if (!$conn)
die ("COnnect error");
echo "MYsql $host is ok";

?>

　　

转载于:https://www.cnblogs.com/peterhu318/archive/2011/09/08/2171127.html