Carl E. Hartung wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi Bob,
That means the server was *not* running in spite of ps ax | grep mysql
linux:/home/carlh # rcmysql stop Shutting down service mysql---------------------------->done linux:/home/carlh # ps ax | grep mysql ~ 7017 pts/2 S+ 0:00 grep mysql
- --> ps reports that my "grep mysql" process is running :-) - --> I restart mysqld and try ps again:
linux:/home/carlh # rcmysql start Starting service MySQL--------------------------------->done
You were dead on on this. It wasn't running.
Here is the subtle, but not hidden "gotcha!":
- --> When you run "mysql_install_db " this is what happens:
linux:/home/(you) # mysql_install_db Installing all prepared tables 050215 18:34:16 /usr/sbin/mysqld: **Shutdown Complete**
- --> You need to restart the server first before creating your password. - --> The correct sequence: install_db->restart->password:
(all as root) rcmysql start ----------------------------------------->done
This all works as described
- --> check it's status:
rcmysql status ----------------------------------------->running
Here is were it goes wrong. I get unused once more.
- --> set up the server's root password:
mysqladmin -u root password "my-password" (no quotes)
mysqladmin -u root -h linux password "my-password" (ditto)
- --> "linux" is the host name in the second example, as you gathered.
Verify the password has been set up by requesting an extended status report from the server:
mysqladmin -u root -h linux -p extended-status
- --> You should be prompted for the password before it displays the report.
This is where I wish to be :-)
regards,
- - Carl
Carl you have been a great help. Do you have any idea how to find out why it did not start? Thanks Bob Rawlinson