Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    fl
    Posts
    2

    Unanswered: mySQL - rebooting and re-initializing

    alright gentlemen, im super new at this deal. i installed mysql with the php lib a couple of weeks ago, and the first day it worked fine. but now, for some reason everytime i reboot my computer i have to manually restart apache to be able to run the testing server.

    sudo apachectl graceful

    then it tells me [warn] module mod_php4.c has already started...

    then when i run my phpadmin i get a:

    ---
    Error

    MySQL said:
    #2002 - Can't connect to local MySQL server through socket '/Private/tmp/mysql.sock' (2)

    ---

    do i always have to start up apache every time i boot in order to be able and start running php?

    maybe im not wording myself very well...
    silly questions of a begginer. all help is very thanked for.
    Last edited by miguelarias; 02-21-04 at 22:50.

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: mySQL - rebooting and re-initializing

    Originally posted by miguelarias
    alright gentlemen, im super new at this deal. i installed mysql with the php lib a couple of weeks ago, and the first day it worked fine. but now, for some reason everytime i reboot my computer i have to manually restart apache to be able to run the testing server.

    sudo apachectl graceful

    then it tells me [warn] module mod_php4.c has already started...

    then when i run my phpadmin i get a:

    ---
    Error

    MySQL said:
    #2002 - Can't connect to local MySQL server through socket '/Private/tmp/mysql.sock' (2)

    ---

    do i always have to start up apache every time i boot in order to be able and start running php?

    maybe im not wording myself very well...
    silly questions of a begginer. all help is very thanked for.
    Your mysql is not running.

  3. #3
    Join Date
    Feb 2004
    Location
    fl
    Posts
    2
    well, mySQL runs, but i have to start the db server everytime i reboot
    cd /local/mysql/ ;
    sudo echo
    sudo ./bin/mysqld_safe &

    then it starts...but i have to do it everytime i restart. (im on mac)

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by miguelarias
    well, mySQL runs, but i have to start the db server everytime i reboot
    cd /local/mysql/ ;
    sudo echo
    sudo ./bin/mysqld_safe &

    then it starts...but i have to do it everytime i restart. (im on mac)
    Copy mysql.server file from /path/where/is/mysql/support-scripts/ to /etc/init.d/
    Then create symlink from rc3.d or rc5.d on /etc/init.d/mysql.server
    I don't know mac structure but on linux is as above.
    Last edited by ika; 02-23-04 at 04:34.

  5. #5
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137
    Originally posted by ika
    Copy mysql.server file from /path/where/is/mysql/support-scripts/ to /etc/init.d/
    Then create symlink from rc3.d or rc5.d on /etc/init.d/mysql.server
    I don't know mac structure but on linux and bsd (macosX is derived from bsd) is as above.
    It is not as above for BSD. BSD does not use init.d nor does Mac OS X (at least not Jaguar). BSD uses rc. I could get into starting MySQL on *BSD, but Mac OS X uses a different startup architecture. You should create a directory /Library/StartupItems/MySQL/. Then you need to create two files in that directory. One is the actual startup script. The other is a property list file. I won't get into the details here, but you can follow this link to a description of the solution http://www.macosxhints.com/article.p...31212142956308 .

  6. #6
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by aus
    It is not as above for BSD. BSD does not use init.d nor does Mac OS X (at least not Jaguar). BSD uses rc. I could get into starting MySQL on *BSD, but Mac OS X uses a different startup architecture. You should create a directory /Library/StartupItems/MySQL/. Then you need to create two files in that directory. One is the actual startup script. The other is a property list file. I won't get into the details here, but you can follow this link to a description of the solution http://www.macosxhints.com/article.p...31212142956308 .
    Oooops sorry, my fault. There is no system V init implemented on BSD.
    Last edited by ika; 02-23-04 at 03:49.

Posting Permissions

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