hello everybody,

i cann't seem to start up mysql, getting the following:

[root@voyager mysql]# bin/mysqld_safe --user=mysql &

[1] 6284
[root@voyager mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/voyager.pid
041003 22:10:15 mysqld ended

* the tmp folder does exist..
err log has the following:
I copied/paseted the last part of or the point of start in thelog for mysql server:

041003 22:10:15 mysqld started
041003 22:10:15 Warning: Asked for 196608 thread stack, but got 126976
/usr/local/mysql/bin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
/usr/local/mysql/bin/mysqld: Can't create/write to file '/root/tmp/ibw7TWlD' (Errcode: 13)
041003 22:10:15 InnoDB: Error: unable to create temporary file; errno: 13
041003 22:10:15 Can't init databases
041003 22:10:15 Aborting

041003 22:10:15 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
041003 22:10:15 /usr/local/mysql/bin/mysqld: Shutdown Complete

041003 22:10:15 mysqld ended
-------------------------------------------
[root@voyager local]# ls -al mysql
lrwxrwxrwx 1 root root 35 Oct 3 21:20 mysql -> mysql-standard-4.0.21-pc-linux-i686/

Well it's a permissions issue, obviously only root can read/write to /root. Not too familiar with mysql so I couldn't tell you how to change where it puts the .tmp directory, but that's what you need to do. Maybe try starting mysql as a user other than root, see what happens.

First, if you haven't done this already, set the root password for MySQL. You can do this by typing:

mysqladmin -u root password 'passwordyouwant'

Now that the root password is set, connect to your MySQL server:

mysql -u root -p

To give credit where credit is due:
http://www.linuxhelp.net/guides/mysql/


Hope this helps.
alar

i'm still having the same problems.

i created a folder under var and gave full perm. to mysql group and user but problem still remains.

any ideas in how i could resolve this issue

This is how it worked for me. After I had the same/similar error you did.
Maybe you will spot something (like who you are logged in as) if
you look it over....

cheers,
alar

shell> bin/mysqld_safe --user=mysql &

# bin/mysqld_safe --user=mysql &
[1] 1350
# Starting mysqld daemon with databases from /var/lib/mysql
040512 15:15:42 mysqld ended

$ su - mysql
Password:
$

[mysql@frodo mysql]$ cd /usr/local/mysql/bin
[mysql@frodo bin]$ ./mysqld
040512 15:39:37 Warning: Can't create test file /
/var/lib/mysql/frodo.lower-test
./mysqld: Can't change dir to '/var/lib/mysql/' /
(Errcode: 13)
040512 15:39:37 Aborting

040512 15:39:37 ./mysqld: Shutdown Complete


cd /var/lib/
[root@frodo lib]# chown -R mysql.mysql mysql/

[mysql@frodo bin]$ ./mysqld
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040512 15:42:23 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040512 15:42:25
InnoDB: Log file ./ib_logfile0 did not exist:
new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040512 15:42:26 InnoDB: Log file ./ib_logfile1 did not exist:
new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040512 15:42:29 InnoDB: Started
./mysqld: ready for connections.
Version: '4.0.18-standard'
socket: '/var/lib/mysql/mysql.sock' port: 3306