Hello everybody,

just installed mysql and the installation seem to go ok..
according to research it looks like a permission err msg but i'm not sure how to correct the problem.

do i give permission to the tmp folder or do i modify the my.cnf file to correct this issue

one of the research i ran inot said to created a folder /var/mysqldata/ to fix this problem but how do i tell it to store the mysql.sock into tis folder..
i also gave group and user mysql rights to this folder.
or am i on the wrong path to resolving this issue?

any help u can give me would be greatly appreciated.


and this is the error i received:
[root@comgen mysql]# bin/mysqld_safe --user=mysql &
[1] 29804
[root@comgen mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/comgen.ca.pid
041007 21:41:03 mysqld ended
[1]+ Done bin/mysqld_safe --user=mysql

log file
mysql started
warning: asked for 196608 thread stack, but got 126976
usr/local/mysql/bin/mysql: can't read dir of '/root/tmp/' errcode 13
usr/local/mysql/bin/mysql: can't create/write to file '/root/tmp/ibwnkdan
/usr/local/mysql/bin/mysql: shutdown complete
mysql ended

Hi, I'm no mysql expert, but I found that you need to change the ownership of the directories mysql created when you issued the command 'mysql_install_db' from root:root to mysql:mysql. Try (as root)

chown -R mysql:mysql /usr/local/mysql

still getting the same problems...i'm lost on this one..
where can i go to have this point to a different folder..
mysql started
warning: asked for 196608 thread stack, but got 126976
usr/local/mysql/bin/mysql: can't read dir of '/root/tmp/' errcode 13
usr/local/mysql/bin/mysql: can't create/write to file '/root/tmp/ibwnkdan
/usr/local/mysql/bin/mysql: shutdown complete
mysql ended

...mmmm looks like mysql is trying to write to /root/tmp. Instead of just /tmp

I've had a look at /etc/my.cnf on my machine and I see a line that's commented out

#tmpdir = /tmp/

you might want to uncomment that line and see what happens !

I am using Slackware 8.0 with MySQL v3.23.39

I installed the binary Slackware package and ran the 'mysql_install_db' as 'root'. When I ran '/usr/bin/safe_mysqld --user=mysql &' the message "mysql ended" appeared. To resolve this I browsed to the '/var/lib/mysql' directory and removed the directories "mysql" and "test".

Then, I created a password for the 'mysql' user (slackware was kind enough to create a password-less user 'mysql' for me). Then, I logged in as 'mysql' and ran 'mysql_install_db'. I then was able to successfully execute '/usr/bin/safe_mysqld --user=mysql &' to start the mysql daemon.

I hope this helps!

Yes, after some time I found the same.
The DB only starts from Linux user mysql.

Also if you install 4.1.7 from RPM the db starts on boot.
Pick up the pid from /var/lib/localhost.pid
ps -ef | grep ThePidFromFile
You can then check the startup command with datadir, basedir, etc that is used at boot.

Hope this helps
The Oracle

I know this is an old thread, but the solution I'll post may help someone with the same problem as Robin01.[list=1][*]Copy /usr/local/mysql/share/mysql/my-large.cnf to /usr/local/mysql/data.my.cnf[*]Edit /usr/local/mysql/data/my.cnf and add the line tmpdir = /tmp/ to the section called [mysqld] [*]Start mysql by doing "/usr/local/mysql/bin/mysqld_safe --user=mysql &" and it should work fine.[/list=1]
Make sure that the user mysql owns /usr/local/mysql.