more MySQL issues

[Craig White]

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