[Plug] Mysql installation

[Dave Dartnall]

On Wed, 14 Jul 2004 08:13 pm, William Kenworthy wrote:
> I cant remember if you mentioned it - but have you checked the mysql
> logs?  On gentoo they are in /var/log/mysql, not sure 'bout Mandrake.

No I didn't.

> rattus root # ls -al /var/log/mysql/
> total 1077989
> drwxr-xr-x   2 mysql mysql        112 Mar 20 12:46 .
> drwxr-xr-x  21 root  root        1256 Jul 14 07:03 ..
> -rw-rw----   1 mysql mysql      52836 Jul 14 07:03 mysql.err
> -rw-rw----   1 mysql mysql 1102726729 Jul 14 20:10 mysql.log
>
> (hmmm, I may need to check logrotate ...)
>
>
> There is also a /etc/mysql directory with some config files - did you
> remove them too?

Yes, I did that...

> rattus root # ls -al /etc/mysql
> total 15
> drwxr-xr-x    2 root root  104 Dec 22  2003 .
> drwxr-xr-x  112 root root 7256 Jul 14 07:03 ..
> -rw-r--r--    1 root root 1229 May 23 10:03 my.cnf
> -rw-r--r--    1 root root 1702 May 23 10:03 mysqlaccess.conf
>
> lastly, how are you starting the daemon?

As I understood the installation docs the server was to start at bootup but 
that didn't seem to happen.
Then I tried  'mysqld_safe --user=mysql &' as set out in the file 
'mysqlinstall' with the response to the effect that it couldn't find the 
socket....
Then I found a detailed series of explanation of various causes of access 
denied errors in 'MySQL-4.0.18 /manual.html#Common_errors' section 5.4.9 
which seemed to be putting me on the right track - but I got pissed off after 
spending the best part of a day and a half on it, got rid of mysql as far as 
possible and tried postgresql - with success!
So I apologise for wasting your time - please accept my thanks for trying to 
help.

regards
Dave D