Hi:

I've worked with MySQL 4.1 since the alpha release (4.1.0). I always
download the latest rpms from mysql.com and install them with rpm. Until
version 4.1.4 every thing was just fine.

However, when I tried to install 4.1.5 rpms in my fully updated Mandrake
10.0, I got an error telling me that mysql didn't have permissions to
access /root/tmp. MySQL was installed but couldn't be started.

Humm, something wrong with this rpms. I post a message in the mysql list
and they told me to give, temporarily, 777 access to /root/tmp to start
the service, which I did. The service started but I couldn't work with
the database after settings /root/tmp permissions back to the original
ones (700).

I went back to install 4.1.4, which I had working before, and I got the
same error. My conclusion was that something was wrong with my box. I
modified the mysql init script in /etc/init.d to start mysql as user
root and the database started working nicely. After that I installed
4.1.5 which is now working without problem. However, running mysql as
root is not considered a good security practice.

Then, one of my coworker, who uses Mandrake 9.2, told me that he was
facing the same problem with 4.1.5. After modifying mysql init script as
I did the data base started to work.

Then I decided to go to a different computer and installed 10.1 CE. The
same problem with mysql. Again, modifying mysql init script solved the
situation.

Decided to go deeper into it, I installed mysql in a box running Debian
3.0r2 using the generic Linux installer. No problem whatsoever. Then I
tried installing mysql in 10.0 using the same binary and I got the same
problem. BTW, Debian has no /root/tmp at all.

At this point, I believe that there is something in Mandrake causing the
problem but I have no idea where to start looking at.

Can I just remove /root/tmp and try to start mysql again? Has anybody in
this list tried to install MySQL 4.1.4 or 4.1.5 in 9.2 or 10 fully
updated or in 10.1 CE without update?

Can some body give me a hint about where the problem might be?

Any help would be highly appreciated.

Adolfo


____________________________________________________
Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
____________________________________________________

Reply via email to