MySQL on RedHat 9 GUI, can't access database
 

I finally got MySQL and PHP Installed using the RPM's from my RedHat installation CD-ROM's

After I installed those, I ran Up2Date to get the latest patches

I got PHP working through Apache, by finding the services GUI and restarting the httpd program

Then I went to install MyPHPAdmin so I could administer MySQL


But I can't access the localhost MySQL server as root, and I don't know if the RPM gave it a password.

So I tried to start mysqld without the grant tables so I could reset the password, but I can't find the mysqld executable.

I don't know where the RPM's installed it.

I did a search for files using the GUI
mysqld starting in /

here are the results
/var/lock/subsys 0 bytes
/var/run folder
/etc/rc.d/init.d
/etc/logrotate.d
/usr/libexec 2.6 MB binary program

the last entry sounds like the best bet...


so I opened a command prompt
[root@redhat root]# cd /usr/libexec
[root@redhat libexec]# mysqld
bash: mysqld: command not found
[root@redhat libexec]#

so it acts like it can't find it ???

Then i type mysqladmin
it returns the help screen

so I try mysqladmin --skip-grant-tables

mysqladmin: unrecognized option `--skip-grant-tables'
mysqladmin Ver 8.23 Distrib 3.23.58, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB

what would be the option to use for the RedHat RPM installed version?




#