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@cehartung.com 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