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
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
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>