Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 11-20-2003, 07:09 PM   #1
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
problems with running mysql

Hello everybody, HELP..........................

I been trying to get mysql to run on mandrake 9.2 and its just not working.
used the following ./configure --prefix=/wwwroot/mysql --datadir=/var/mysqldata.
from what i can see the installation was successfull except for the fact that the dataase isn't saving it to datadir insted its saving it t mysql/var..
but problem is getting mysql to start....
[root@voyager bin]# mysqld_safe &
[1] 2936
[root@voyager bin]# Starting mysqld daemon with databases from /var/mysqldata
031120 08:01:21 mysqld ended

err log has the following:
031120 07:24:51 mysqld started
/wwwroot/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
031120 7:24:51 InnoDB: Operating system error number 13 in a file operation.
InnoDB: See for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
031120 07:24:51 mysqld ended
*****by default innodb is disabled in my.cfg
parts of the my.cfg

# The following options will be passed to all MySQL clients
#password = your_password
port = 3306
# socket = /tmp/mysql.sock --was
socket = /wwwroot/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
port = 3306
# socket = /tmp/mysql.sock --was
socket = /wwwroot/mysql/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
Old 08-29-2005, 06:18 PM   #2
LQ Guru
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
The solution is in my reply in this thread.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-07-2008 11:48 PM
MySQL , is it running? is it there? Raggit Fedora 7 09-14-2005 02:02 PM
mysql problems running?? kahn Linux - Software 1 02-24-2005 11:35 AM
running mysql ?? shaahul Linux - Software 1 09-03-2003 02:45 AM
problem running mysql jumper Linux - Software 0 11-16-2001 10:00 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:45 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration