11 comment

1. Thank you. i need this command.

2. God tip.
   Thanks!

3. pls. i need more about mySQL method of setting and resetting

4. Appreciated.

5. As always, phenomenal tips from nixcraft. Every single problem I have ever had with freeBSD this site has solved! 5/5

6. Very useful info. Could you please tell me how to configure the MySQL server to work with PHP. I have just installed and started.

7. I had to add the following to /etc/rc.conf for this to work:

   mysql_enable=”YES”
   mysql_args=”–user=mysql”

8. Cool! It runned cool for me !

9. /usr/local/etc/rc.d/mysql-server restart

10. If you don’t like starting mysql from /usr/local/etc/rc.d/ and service won’t work like this :

    # service mysql status
    mysql does not exist in /etc/rc.d or the local startup
    directories (/usr/local/etc/rc.d)

    You can make symlink

    ln -s /usr/local/etc/rc.d/mysql-server mysql

    This way you can use

    # service mysql status
    mysql is running as pid 5023.

    # service mysql restart
    Stopping mysql.
    Waiting for PIDS: 5023.
    Starting mysql.

11. Assuming you are in /etc/rc.d

    Have a question? Post it on our forum!