DeveloperSide.NET Forums
October 20, 2019, 07:27:21 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: not able to start mysql server  (Read 18699 times)
0 Members and 1 Guest are viewing this topic.
robin
Member
*
Posts: 13


View Profile
« 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
Logged
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #1 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.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
robin
Member
*
Posts: 13


View Profile
« Reply #2 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/
Logged
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #3 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)
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
robin
Member
*
Posts: 13


View Profile
« Reply #4 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...
Logged
VelvetRaven
Member
*
Posts: 1


View Profile
« Reply #5 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... :)
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!