Mailinglist Archive: opensuse (2912 mails)

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

Carl E. Hartung wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Bob,
>
> Thanks for the answers -- that certainly narrows things down.
>
> |> it was on the Suse 9.1 cd. I can't get it to tell me what version 
> as it
> |> just tells me it can't connect
>
> The version in question came off the CD is all I really need to know.
>
> |> I used YaST to install it.
>
> Great.
>
> |> No. It looks like it ran OK. Just won't work but I can confirm it is
> |> running with ps ax | grep mysql.
>
> Also great.
>
> | - do you see anything in /var/log/messages worth mentioning?
> |> Just a duplicate of the error message.
>
> Ok, from a post mid-year last year, another SuSE user had this problem.
>
> Have you seen this message?:
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> linux:/home/(you) # mysql_install_db
> Installing all prepared tables
> ~   040602 5:54:02 /usr/sbin/mysqld: Shutdown Complete
>
> ~   PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> ~   To do so, start the server, then issue the following commands:
> ~   /usr/bin/mysqladmin -u root password 'new-password'
> ~   /usr/bin/mysqladmin -u root -h linux password 'new-password'
> ~   See the manual for more instructions.
>
> ~  NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
> ~  the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
> ~  able to use the new GRANT command!
>
> ~  You can test the MySQL daemon with the benchmarks in the 'sql-bench'
> directory:
> ~  cd sql-bench ; perl run-all-tests
>
> ~  Please report any problems with the /usr/bin/mysqlbug script!

Yes I did get this the first time. It was when I started to handle the 
root password that the problems
began. I started getting the "Can't connect to local mysql server 
through socket '/var/lib/mysql/mysql.sock'"
the first time I tried
Some trouble shooting sugestions said to look for the mysql.sock file. 
Locate could not find it anywhere.
I ran the mysql_install_db again as it said to do and then this endless 
circle started of trying a lot of things.

> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> - - Carl
>
>
>
> - --
> ____________________________________________________________________
> C. E. Hartung                Business Development & Support Services
> http://www.cehartung.com/                        carlh@xxxxxxxxxxxxx
> Dover Foxcroft, Maine, USA                    Public Key #0x68396713
> Reg. Linux User #350527                       http://counter.li.org/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.5 (GNU/Linux)
>
> iD8DBQFCEkyFusxgymg5ZxMRAghNAJ0b/0TB1k8FhXM4XkQe0/OCUu10cACeM89E
> OIJrLsUtzQUkuHD35ACtnq4=
> =7Rzi
> -----END PGP SIGNATURE-----
Thanks again for you suggestions and help.
Bob Rawlinson