Egor Egorov <[EMAIL PROTECTED]> wrote: >>> Then temporary give a+rw on /root/tmp (don't forget to +x /root) >>> and see what's mysqld_safe gonna write there. Maybe it's a bug in the >>> script. >>> Also please check the environment for TMPDIR. >> >> After this mysql started successfully but it didn't write anything in >> /root/tmp. > [] >> Does MySQL need rights to /root/tmp to work well? > > No. It's a weird behavior. I will investigate and get back to you.
Igor, First, does the "mysql" user exists? Second, here is what Marko Makela told me about your situation: > It's probably from innobase_mysql_tmpfile(), which is called two or three > times at startup. That function relies on create_temp_file(). Has > the MySQL configuration parameter tmpdir or the environment variable TMPDIR > been set incorrectly, or is the default value somehow incorrect? Could > it be that the directory /var/mysqltmp does not exist, and the fall-back > value is incorrect? Maybe $HOME is pointing to /root, but mysqld is being > run as a non-privileged user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]