more MySQL issues

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: mazdaracer
Date:  
Subject: more MySQL issues
[ bunch of PHP info
Attempting to connect...
Fatal error: Call to undefined function: mysql_connect() in
/var/www/html/test.php on line 4

using:
<?
phpinfo();
echo "Attempting to connect...";
mysql_connect("localhost", "root", "password");
mysql_select_db("mysql");
exit;
?>

Like I'm missing a module.

[root@rotor html]# rpm -qa | grep -i php
asp2php-0.76.2-3
php-4.2.2-8.0.5
php-manual-4.2.2-8.0.5
php-imap-4.2.2-8.0.5
php-devel-4.2.2-8.0.5
php-ldap-4.2.2-8.0.5
asp2php-gtk-0.76.2-3
php-pgsql-4.2.2-8.0.5

[root@rotor html]# rpm -qa | grep -i sql
MySQL-devel-3.23.55-1
postgresql-libs-7.2.3-5.73
postgresql-server-7.2.3-5.73
mod_auth_pgsql-0.9.12-11
mod_auth_mysql-1.11-10
MySQL-shared-3.23.55-1
MySQL-3.23.55-1
postgresql-devel-7.2.3-5.73
postgresql-7.2.3-5.73
php-pgsql-4.2.2-8.0.5
MySQL-client-3.23.55-1
[root@rotor html]#

Slowly going wacko :)

pete


Liberty Young wrote:
> What happens if you write a quick test script to access your mySQL
> server?
>
>
> On Fri, 2003-02-07 at 14:53, mazdaracer wrote:
>
>>Very interesting. That did indeed work! Not I have to use a uid/pwd!
>>
>>What precipitated all this was my wanting to install postnuke. I've had
>>similar problems before and ended up having to remove sql and re-install.
>>
>>So now I'm getting the infamous "undefined function mysql_connect" when
>>trying to get postnuke installed. I haven't touched the php.ini and I've
>>created the database but can't get past that. I've searched the forums
>>but haven't found anything yet that I've been able to use.
>>
>>I saw an apt-get but that's for Debian and I'm running RH8.
>>
>>I really have to document all these little fixes!
>>
>>pete
>>
>>
>>Liberty Young wrote:
>>
>>>On Fri, 2003-02-07 at 12:31, mazdaracer wrote:
>>>
>>>
>>>>There's all of it. The gist is that only 2 users are listed.
>>>>
>>>
>>>That's what i was afraid of. Add instead a default user with NO
>>>privlages
>>>
>>>INSERT INTO user (Host, User, Password) VALUES("", "Nobody", "");
>>>INSERT INTO user (Host, User, Password) VALUES("localhost", "%", "");
>>>
>>>Then you can add more users with various access privs from different
>>>hosts, and access to specific DBs
>>>
>>>Definitely go rent/read the Mysql and Msql book from Oreilly.
>>>They have a chapter that talks about how MySQL queries the mysql db when
>>>determing log-ins.
>>>
>>>---------------------------------------------------
>>>PLUG-discuss mailing list -
>>>To subscribe, unsubscribe, or to change you mail settings:
>>>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>>>
>>
>>
>>---------------------------------------------------
>>PLUG-discuss mailing list -
>>To subscribe, unsubscribe, or to change you mail settings:
>>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>