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
Let's step back a moment.
Initially the discovery came when trying to install postnuke and getting
the "connect" not defined problem.

Wrote a quick test script for phpinfo. (point to 63.231.43.237/test.php)
No MySQL section per Mr. Young.

I then did "up2date php-mysql" and it updated a bunch of stuff.

I restarted httpd and mysql.

Ran test.php and still no mysql section.

And all this after the login issues, which seem to be ok now.

I must be missing a step (at least!). Been looking thru "PHP and MySQL
Web Development" by Sams for some guidance but it's not much at this stage.

My next inclination is to remove all the php and mysql packages, stop
httpd and re-install them from up2date. (RH8 btw)
pete


Craig White wrote:
> Just out of curiousity
> What command are your running and what did you expect that you're not
> getting?
>
> Craig
>
> On Fri, 2003-02-07 at 16:21, mazdaracer wrote:
>
>>Getting there! Now I have this installed:
>>[pete@rotor installed]$ rpm -qa | grep -i php
>>asp2php-0.76.2-3
>>php-odbc-4.2.2-8.0.5
>>php-4.2.2-8.0.5
>>php-mysql-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
>>php-snmp-4.2.2-8.0.5
>>asp2php-gtk-0.76.2-3
>>php-pgsql-4.2.2-8.0.5
>>[pete@rotor installed]$
>>
>>I've restarted httpd. Looks like I need to do something else yet to get
>>php - mysql to talk. phpinfo still doesn't come up with any mysql data.
>>pete
>>
>>
>>
>>
>>mazdaracer wrote:
>>
>>>I thought I had things figured out from the last msg from George. But
>>>when I got back on this morning, I see I can get into the mysql DB
>>>without a password as a regular user (me, pete). Also, in webmin, I can
>>>easily see everything too. The password for the DB is different from my
>>>regular root password, but still no prompting. Here's the output from
>>>this morning:
>>>
>>>[pete@rotor pete]$ mysqlshow
>>>+-----------+
>>>| Databases |
>>>+-----------+
>>>| Phoenix   |
>>>| mysql     |
>>>| test      |
>>>+-----------+
>>>[pete@rotor pete]$ mysql
>>>Welcome to the MySQL monitor.  Commands end with ; or \g.
>>>Your MySQL connection id is 22 to server version: 3.23.55

>>>
>>>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>
>>>mysql> use Phoenix
>>>Database changed
>>>mysql> show tables;
>>>Empty set (0.00 sec)
>>>
>>>mysql> use mysql
>>>Reading table information for completion of table and column names
>>>You can turn off this feature to get a quicker startup with -A
>>>
>>>Database changed
>>>mysql> show tables;
>>>+-----------------+
>>>| Tables_in_mysql |
>>>+-----------------+
>>>| columns_priv    |
>>>| db              |
>>>| func            |
>>>| host            |
>>>| tables_priv     |
>>>| user            |
>>>+-----------------+
>>>6 rows in set (0.00 sec)

>>>
>>>mysql> select User,Host,Password from user;
>>>+------+--------------------------+------------------+
>>>| User | Host                     | Password         |
>>>+------+--------------------------+------------------+
>>>| root | localhost                | 77f55a9e14442c8f |
>>>| root | rotor.byerlyelectric.com | 77f55a9e14442c8f |
>>>+------+--------------------------+------------------+
>>>2 rows in set (0.01 sec)

>>>
>>>mysql>
>>>
>>>
>>>With only root in the DB I would think I'd be prompted each and every time.
>>>
>>>pete