MySQL Problems - Linux Forums

10-04-2004	#1 (permalink)
garv Just Joined! Join Date: Oct 2004 Location: VA Posts: 5	MySQL Problems 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:~# Starting mysqld daemon with databases from /usr/var STOPPING server from pid file /usr/var/server.pid 041004 18:38:48 mysqld ended I looked in the mysql server error file and this is what it stated: Code: 041003 17:00:08 mysqld started 041003 17:00:08 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.php 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. 041003 17:00: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.
	Looking for Linux Hosting? Click Here

10-04-2004	#2 (permalink)
exodus Just Joined! Join Date: Oct 2004 Posts: 2	same problem 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

10-05-2004	#3 (permalink)
Giro Linux Engineer Join Date: Jul 2003 Location: England Posts: 1,219	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: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.

10-05-2004

#4 (permalink)

exodus

Just Joined!

Join Date: Oct 2004

Posts: 2

this is what im doing

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:33:39  mysqld ended

05-10-2006	#5 (permalink)
mabus10110 Just Joined! Join Date: May 2006 Posts: 2	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 ?

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 On

HTML code is Off

Trackbacks are Off

Pingbacks are Off

Refbacks are Off

Are you a Linux Guru who is willing to share your in-depth Linux knowledge? Try our new Article submission system.