DeveloperSide.NET Forums

DeveloperSide.NET => Building a Web Server, for Linux => Topic started by: robin on October 04, 2004, 02:13:48 AM



Title: not able to start mysql server
Post by: robin on October 04, 2004, 02:13:48 AM
hello everybody,
getting the following error when i start mysql server.

[root@comgen mysql]# bin/mysqld_safe --user=mysql &
[1] 6284
[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
041003 22:10:15  mysqld ended

any ideas to how to fix this problems


Title: not able to start mysql server
Post by: admin on October 04, 2004, 02:23:56 AM
First, check mysql's error log.  There should be a file named something.err under the MySQL/data dir. Post the contents here.

Also, do an "ls -al" on your MySQL dir and post the output here, you could have the wrong user/group/access file permission set.


Title: not able to start mysql server
Post by: robin on October 04, 2004, 11:16:34 PM
hello,

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@comgen local]# ls -al mysql
lrwxrwxrwx  1 root root 35 Oct  3 21:20 mysql -> mysql-standard-4.0.21-pc-linux-i686/


Title: not able to start mysql server
Post by: admin on October 04, 2004, 11:45:13 PM
Well, the problem looks like it cannot create the temp file it needs under /root/tmp/ .

This could be a dir/file permission problem.

Make sure that /root/tmp/ exists and that it's permissions are set right.

Read up on "chmod" and "chown". (using the 'man xxxxx' command)


Title: not able to start mysql server
Post by: robin on October 07, 2004, 02:35:00 AM
i create a folder under var and gave it full access to mysql user but problem still remains.

i also changed the my.cnf socket line to point to the new folder /var/mysqldata but problem still remains...


Title: not able to start mysql server
Post by: VelvetRaven on October 20, 2004, 07:21:37 PM
Quote from: "robin"
i create a folder under var and gave it full access to mysql user but problem still remains.

i also changed the my.cnf socket line to point to the new folder /var/mysqldata but problem still remains...



Simply because I find it terribly frustrating to come across unresolved problems for issues that I myself am having difficulty with (and consequently arrived here via google), here's what I did to resolve this issue.

export TMPDIR=/path/to/chosen/dir;   (eg /tmp/)

Hopefully, that might help someone else in future... :)