Mailinglist Archive: opensuse (2912 mails)

["Robert A. Rawlinson" <rarawlinson@xxxxxxxxxx>]

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