Jostein Berntsen wrote:

On 14.02.05,11:56, Robert A. Rawlinson wrote:

...

I just installed mysql but when I tried to start it, it complained that it could not find priveledge tables. I found something that said I should run mysql_install_db. I did this and still I get the message. I am running on Suse 9.1. Has anyone else had this problem? Does anyone know how to solve it? Bob Rawlinson

Try to delete the /var/lib/mysql directory and run 'rcmysql start' as root to fix the permissions.

- Jostein

I just tried it and it did not work. Thanks though. Bob Rawlinson

Carl E. Hartung wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Robert A. Rawlinson wrote: <snip> | I just installed mysql but when I tried to start it, it complained | that it could not find priveledge tables. I found something that said | I should run mysql_install_db. I did this and still I get the message. | I am running on Suse 9.1. Has anyone else had this problem? | Does anyone know how to solve it?

Hi Bob,

Just for the record, since you didn't elaborate:

- - what version of MySQL? - - what is the full name of the installation package file? - - where did you get it from? (SuSE/mirror via ftp? SuSE CD/DVD?)

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

- - how did you install it? (rpm -???? or YaST Install & Remove Software?)

I used YaST to install it.

- - was there any feedback from the system when you installed it? If so, what was that feedback?

No. It looks like it ran OK. Just won't work but I can confirm it is running with ps ax | grep mysql.

- - do you see anything in /var/log/messages worth mentioning?

Just a duplicate of the error message.

Sorry to be a PITA stickler for detail :-) but knowing all this stuff might narrow the field of possibilities a bit.

Not a PITA. I am happy to get some answers and something new to try. I need to get it running correctly for a project I have to work on.

thanks,

- - 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)

iD8DBQFCEjphusxgymg5ZxMRAqQnAJ90BdrU6IHqOUrnvy3/hWt3qvIgrQCfaE5t fJrM7K51GzK5PN28bep0QkY= =j8Hs -----END PGP SIGNATURE-----

Thanks much for your help. Bob Rawlinson

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

steve wrote:

On Tuesday 15 February 2005 19:07, Carl E. Hartung wrote:

...

Robert A. Rawlinson wrote: <snip>

| I just installed mysql but when I tried to start it, it | complained that it could not find priveledge tables. I | found something that said I should run | mysql_install_db. I did this and still I get the | message. I am running on Suse 9.1. Has anyone else had | this problem? Does anyone know how to solve it?

Is it running?

rcmysql status

if not, start it:

rcmysql start

Just a thought. Steve.

Yes its running. I checked with "ps ax | grep mysql" However I tryed that command. Still running but when I try to do anything I get the can't connect message. Bob Rawlinson