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
/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
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?