MySQL Problems

**garv** · 10-04-2004

I just recently installed Mysql-4.0.21 on my Slackware 10 box. I compiled it from source and everything went fine and dandy with that. When I tried to fire it up it just didn't function correctly

Here is what I got in the console:

Code:

root@server&#58;~# Starting mysqld daemon with databases from /usr/var
STOPPING server from pid file /usr/var/server.pid
041004 18&#58;38&#58;48  mysqld ended

I looked in the mysql server error file and this is what it stated:

Code:

041003 17&#58;00&#58;08  mysqld started
041003 17&#58;00&#58;08  InnoDB&#58; Operating system error number 13 in a file operation.
InnoDB&#58; See http&#58;//www.innodb.com/ibman.php for installation help.
InnoDB&#58; The error means mysqld does not have the access rights to
InnoDB&#58; the directory.
InnoDB&#58; File name ./ibdata1
InnoDB&#58; File operation call&#58; 'create'.
InnoDB&#58; Cannot continue operation.
041003 17&#58;00&#58;08  mysqld ended

I've been browsing around the internet for the past two days and I haven't been able to find much that might help my situation. The search here didn't turn out much that seemed to fit my problem. Any help is greatly appreciated. Thanks for your time.

**exodus** · 10-05-2004

man i got the same exact problem right now

exsept mines :

[root@localhost mysql]# Starting mysqld daemon with databases from /var/www/html/mysql/data
STOPPING server from pid file /var/www/html/mysql/data/localhost.localdomain.pid
041005 08:03:33 mysqld ended

**Giro** · 10-05-2004

Your error log has told you the problem you do not have read/write access to the mysql directory. Also who did you run mysql_install_db as? if it was root you will have to

Code:

chown -R mysql&#58;mysql /var/mysql

Replacing the mysql:mysql with the user who mysqld is running as.

ps, If you search the forum there is a post where someone had this exact same problem and i answerd it.

**exodus** · 10-05-2004

ok this is exactly what i did

Code:

# su -
# gunzip mysql-standard-4.0.21-pc-linux-i686.tar.gz
# tar xvf mysql-standard-4.0.21-pc-linux-i686.tar
# ln -s mysql-standard-4.0.21-pc-linux-i686 mysql
# cd mysql
# chown -R mysql /var/www/html/mysql
# scripts/mysql_install_db --user=mysql
# su -
# cd /var/www/html/mysql
# bin/mysqld_safe --user=mysql &
# Starting mysqld daemon with databases from /var/www/html/mysql/data
STOPPING server from pid file /var/www/html/mysql/data/localhost.localdomain.pid
041006 04&#58;33&#58;39  mysqld ended

**mabus10110** · 05-10-2006

I am also having this problem right now, running on a whitebox linux system. I am a new member to this forum, and I will be on my way to finding the solution that you gave.

So, why does this happen anyway? what causes it to end ?

Thread Tools

Display

MySQL Problems

same problem

this is what im doing

Posting Permissions