Find the answer to your Linux question:
Results 1 to 5 of 5

Thread: MySQL Problems

Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Oct 2004

    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:
    root@server:~# Starting mysqld daemon with databases from /usr/var
    STOPPING server from pid file /usr/var/
    041004 18:38:48  mysqld ended
    I looked in the mysql server error file and this is what it stated:
    041003 17:00:08  mysqld started
    041003 17:00:08  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: '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.

  2. #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/
    041005 08:03:33 mysqld ended

  3. #3
    Linux Engineer Giro's Avatar
    Join Date
    Jul 2003
    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
    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.

  4. $spacer_open
  5. #4

    this is what im doing

    ok this is exactly what i did

    # 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/
    041006 04:33:39  mysqld ended

  6. #5
    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 Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts