not able to run mysql...

[robin1]

hello everybody,

I been playing with mysql for a month now and i cann't seem to successfull get it to work...

tried it on redhat9 and now i'm trying it on mandrake 9.2..
- using binary build..
./configure --prefix=/wwwroot/mysql --datadir=/var/mysqldata.

it seem to have installed successfully.. didn't see any err messages...

-at first.. the etc/my.cnf wasn't pressent.. so i copy and pasted this file from support file...(haven't confiremd if mysql is even reading this file my.cnf)

from the wwwroot/mysql/bin mysqld_safe &
[1] 3086
starting mysqld deamon with databses from /wwwroot/mysql/var.
mysqld ended
done mysqld_safe

-looked at the logfile which is located in /wwwroot/mysql/var/voyager.err(voyager is the hostname and assuming this is the logfile) and according to this file... "/wwwroot/mysql/libexec/mysqld: cann't read dir of '/root/tmp/' errcode: 13"

according to the instructions...i gaveall of the user, groups the correct access/permissinos...
typed top and no deamons are running thats related to mysql..

did it soooo many times its getting out of control...
when i installed mandrake 9.2.. ididn't install anyof these optoin... reason trying to learn this operating system and mysql php,apach...

Help....spending a month is enought on this... need this working...

[theN]

Hi

Post your my.cnf.

using binary build...Are you sure its a binary? I didn't know that one could configure a binary.

voyager is the hostname and assuming this is the logfile...yes that is the error file. IIRC The logfile naming convention is hostname.err

cann't read dir of '/root/tmp/' errcode: 13Any idea whats going into that directory? I mean is MySQL trying to put the sock file in that folder?

regards
akr

[robin1]

error log:
031119 06:07:39 mysqld started
/wwwroot/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
031119 6:07:39 InnoDB: Operating system error number 13 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html 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: 'create'.
InnoDB: Cannot continue operation.
031119 06:07:39 mysqld ended
-----------------------------------------------
copy and pasted parts of the my.cnf to explain
# The following options will be passed to all MySQL clients
[client]
#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
[mysqld_safe]
port = 3306
# socket = /tmp/mysql.sock --was
socket = /wwwroot/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M

[theN]

Hi

Are you using InnoDB? If so, post the part of your my.cnf relevant to InnoDB.

IIRC, you must specify the full path to where MySQL will finally put the InnoDB database types. In your case, something along the lines of /wwwroot/mysql/data/.

regards
akr

[crow2icedearth2]

i think i know why your getting that error from the wwwroot/mysql/bin mysqld_safe &
[1] 3086
starting mysqld deamon with databses from /wwwroot/mysql/var.
mysqld ended
done mysqld_safe

i have seen this many times and its 95% because u dont have the correct permissions on /var/mysql/data

as root change the permissions and add a group mysql and change that as well

then run mysqld_safe & again

good look