Solved Unable to install MySQL

Hi,

I am new to FreeBSD. I was not able to install MySQL.

Code:
mysql-boost-8.0.0-dmr.tar.gz                  100% of   62 MB   41 kBps 25m52s
===> Fetching all distfiles required by mysql80-server-8.0.0_4 for building
===>  Extracting for mysql80-server-8.0.0_4
=> SHA256 Checksum OK for mysql-boost-8.0.0-dmr.tar.gz.
/usr/ports/databases/mysql80-server/work/mysql-8.0.0-dmr/sql/sql_hints.yy.cc
/usr/ports/databases/mysql80-server/work/mysql-8.0.0-dmr/sql/sql_hints.yy.h
===>  Patching for mysql80-server-8.0.0_4
===>  Applying FreeBSD patches for mysql80-server-8.0.0_4
No such line 938 in input file, ignoring
===>   mysql80-server-8.0.0_4 depends on executable: bison - not found
===>   bison-3.0.4,1 depends on package: m4>=1.4.16,1 - not found
===>   m4-1.4.18,1 depends on executable: makeinfo - not found
===>   texinfo-6.3_2,1 depends on executable: help2man - not found
===>   help2man-1.47.4 depends on package: p5-Locale-gettext>=0 - not found
===>   p5-Locale-gettext-1.07 depends on executable: msgfmt - found
===>   p5-Locale-gettext-1.07 depends on package: perl5>=5.24<5.25 - found
===>   p5-Locale-gettext-1.07 depends on shared library: libintl.so - found (/usr/local/lib/libintl.so)
===>  Configuring for p5-Locale-gettext-1.07
env: /usr/local/bin/perl5.24.1: No such file or directory
*** Error code 127

Stop.
make[10]: stopped in /usr/ports/devel/p5-Locale-gettext
*** Error code 1

Stop.
make[9]: stopped in /usr/ports/misc/help2man
*** Error code 1

Stop.
make[8]: stopped in /usr/ports/misc/help2man
*** Error code 1

Stop.
make[7]: stopped in /usr/ports/print/texinfo
*** Error code 1

Stop.
make[6]: stopped in /usr/ports/print/texinfo
*** Error code 1

Stop.
make[5]: stopped in /usr/ports/devel/m4
*** Error code 1

Stop.
make[4]: stopped in /usr/ports/devel/m4
*** Error code 1

Stop.
make[3]: stopped in /usr/ports/devel/bison
*** Error code 1

Stop.
make[2]: stopped in /usr/ports/devel/bison
*** Error code 1

Stop.
make[1]: stopped in /usr/ports/databases/mysql80-server
*** Error code 1

Stop.
make: stopped in /usr/ports/databases/mysql80-server
root@Tom's Server:/usr/ports/databases/mysql80-server #
 
Are you enabling specific options on MySQL or just building as default? If it's just default you may as well just use pkg().

Also if Tom's server is the hostname, that's probably asking for trouble.
 
Updating...

And this is the feedback after trying to start the mysql-server service:

Code:
root@Tom's Server:/usr/ports/databases/mysql80-client # service mysql-server start
mysql-server does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
root@Tom's Server:/usr/ports/databases/mysql80-client #
 
Have you actually managed to install MySQL yet? I've just tried it on one of my servers with pkg install mysql80-server. Took about 30 seconds to install 8.0.2 and the mysql-server startup script definitely exists.
 
And this is the feedback after trying to start the mysql-server service:
Did you actually enable MySQL? Because that's something you'll have to do yourself. You can check using: sysrc mysql_enable. It that doesn't mention YES then you'll need to enable it. I usually edit /etc/rc.conf manually but you can also use sysrc(8) to add the variable for you.
 
root@Tom's Server:/usr/ports/databases/mysql80-client # service mysql-server start

Just noticed the above path. You're trying to start MySQL, so I assume you think you have it installed, but is it the client you successfully installed and not the server?
 
Hello,

It seems that the installation of MySQL server failed.

Code:
root@Tom's Server:/usr/ports/databases/mysql80-client # pkg install mysql80-server
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Updating database digests format: 100%
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    mysql80-server: 8.0.2

Number of packages to be installed: 1

The process will require 124 MiB more space.
12 MiB to be downloaded.

Proceed with this action? [y/N]: y
[1/1] Fetching mysql80-server-8.0.2.txz: 100%   12 MiB  78.9kB/s    02:41   
Checking integrity... done (0 conflicting)
[1/1] Installing mysql80-server-8.0.2...
===> Creating groups.
Using existing group 'mysql'.
===> Creating users
Using existing user 'mysql'.
Extracting mysql80-server-8.0.2: 100%
Message from mysql80-server-8.0.2:

*****************************************************************************

WARNING: THIS IS STILL-IN-DEV PROJECT! USE WITH CAUTION ON PRODUCTION ENVS!

*****************************************************************************
*****************************************************************************

Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.

There is no initial password for first time use of MySQL.
Keep in mind to reset it to a secure password.

MySQL80 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.

*****************************************************************************
root@Tom's Server:/usr/ports/databases/mysql80-client # sysrc mysql-server
mysql-server: server
root@Tom's Server:/usr/ports/databases/mysql80-client # sysrc mysql_enable      mysql_enable: YES
root@Tom's Server:/usr/ports/databases/mysql80-client # service mysql_enabled start
mysql_enabled does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
root@Tom's Server:/usr/ports/databases/mysql80-client #
 
Did you run:-
Code:
sysrc mysql_enable=yes
service mysql status
service mysql-server start

?

Could you show the output?
 
Code:
# sysrc mysql_enable=yes
# service mysql-server start

You might find things easier if you put some effort into trying to understand what you are doing and following instructions/guides.
 
Did you run:-
Code:
sysrc mysql_enable=yes
service mysql status
service mysql-server start

?

Could you show the output?

Thanks for the reply, here is what I got.

Code:
root@Tom's Server:/usr/home/tomsserver # service mysql status
mysql does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
root@Tom's Server:/usr/home/tomsserver # service mysql-server start
eval: 1: Syntax error: Unterminated quoted string
eval: 1: Syntax error: Error in command substitution
root@Tom's Server:/usr/home/tomsserver #

Among various OS, I prefer macOS and FreeBSD as both are Unix. I read some textbooks for Unix but they discuss Unix itself, not the MySQL.

Tom
 
Code:
root@Tom's Server:/usr/home/tomsserver # service mysql-server start eval: 1: Syntax error: Unterminated quoted string eval: 1: Syntax error: Error in command substitution
Check /etc/rc.conf, it's likely you've made a mistake there.
 
Here is the contents of /etc/rc.conf

Code:
root@Tom's Server:/ # cat /etc/rc.conf
hostname="Tom's Server"
ifconfig_nfe0="DHCP"
ifconfig_nfe0_ipv6="inet6 accept_rtadv"
local_unbound_enable="YES"
sshd_enable="YES"
moused_enable="YES"
ntpd_enable="YES"
powerd_enable="YES"
# Set dumpdev to "AUTO" to enable crash dumps, "NO" to disable
dumpdev="AUTO"
apache24_enable="YES"
mysql_enable="YES"
mysql_args="-usr=mysql"
nfs_server_enable="YES"
nfs_server_flags="-u -t -n 4"
rpcbind_enable="YES"
mountd_flags="-r"
mountd_enable="YES"
root@Tom's Server:/ #
 
Not that it's the cause of the latest problem, but where did mysql_args="-usr=mysql" come from? It's not the right argument name and not needed anyway as it runs as mysql by default.
 
Not only MySQL, transmission has the same issue. See below

Code:
root@Tom's Server:/ # service transmission-daemon start
transmission-daemon does not exist in /etc/rc.d or the local startup
directories (/usr/local/etc/rc.d), or is not executable
root@Tom's Server:/ #

I list the files under /etc/rc.d directory and there are not mysql and transmission subdirectories. See below

Code:
root@Tom's Server:/ # ls -li /etc/rc.d
total 712
8346978 -r-xr-xr-x  1 root  wheel    242 Jul 21 10:11 DAEMON
8347011 -r-xr-xr-x  1 root  wheel    415 Jul 21 10:11 FILESYSTEMS
8346996 -r-xr-xr-x  1 root  wheel    404 Jul 21 10:11 LOGIN
8346878 -r-xr-xr-x  1 root  wheel    366 Jul 21 10:11 NETWORKING
8346888 -r-xr-xr-x  1 root  wheel    263 Jul 21 10:11 SERVERS
8346939 -r-xr-xr-x  1 root  wheel   1269 Jul 21 10:11 abi
8346865 -r-xr-xr-x  1 root  wheel   1309 Jul 21 10:11 accounting
8346937 -r-xr-xr-x  1 root  wheel    382 Jul 21 10:11 addswap
8346928 -r-xr-xr-x  1 root  wheel    284 Jul 21 10:11 adjkerntz
8346953 -r-xr-xr-x  1 root  wheel    871 Jul 21 10:11 amd
8346926 -r-xr-xr-x  1 root  wheel    654 Jul 21 10:11 apm
8346922 -r-xr-xr-x  1 root  wheel    668 Jul 21 10:11 apmd
8346997 -r-xr-xr-x  1 root  wheel    671 Jul 21 10:11 archdep
8346905 -r-xr-xr-x  1 root  wheel   4158 Jul 21 10:11 atm1
8346870 -r-xr-xr-x  1 root  wheel   2635 Jul 21 10:11 atm2
8346969 -r-xr-xr-x  1 root  wheel   2413 Jul 21 10:11 atm3
8347002 -r-xr-xr-x  1 root  wheel    603 Jul 21 10:11 auditd
8347015 -r-xr-xr-x  1 root  wheel    450 Jul 21 10:11 auditdistd
8346895 -r-xr-xr-x  1 root  wheel    464 Jul 21 10:11 automount
8346949 -r-xr-xr-x  1 root  wheel    380 Jul 21 10:11 automountd
8346936 -r-xr-xr-x  1 root  wheel    364 Jul 21 10:11 autounmountd
8346891 -r-xr-xr-x  1 root  wheel   1030 Jul 21 10:11 bgfsck
8346961 -r-xr-xr-x  1 root  wheel   1765 Jul 21 10:11 blacklistd
8346984 -r-xr-xr-x  1 root  wheel   9424 Jul 21 10:11 bluetooth
8346973 -r-xr-xr-x  1 root  wheel    369 Jul 21 10:11 bootparams
8346886 -r-xr-xr-x  1 root  wheel   2337 Jul 21 10:11 bridge
8346992 -r-xr-xr-x  1 root  wheel    405 Jul 21 10:11 bsnmpd
8346955 -r-xr-xr-x  1 root  wheel    688 Jul 21 10:11 bthidd
8346960 -r-xr-xr-x  1 root  wheel    358 Jul 21 10:11 ccd
8346983 -r-xr-xr-x  1 root  wheel   1270 Jul 21 10:11 cleanvar
8346892 -r-xr-xr-x  1 root  wheel   1912 Jul 21 10:11 cleartmp
8346954 -r-xr-xr-x  1 root  wheel    428 Jul 21 10:11 cron
8347009 -r-xr-xr-x  1 root  wheel    436 Jul 21 10:11 ctld
8346945 -r-xr-xr-x  1 root  wheel    530 Jul 21 10:11 ddb
8346946 -r-xr-xr-x  1 root  wheel   1526 Jul 21 10:11 defaultroute
8346981 -r-xr-xr-x  1 root  wheel    744 Jul 21 10:11 devd
8346855 -r-xr-xr-x  1 root  wheel   1454 Jul 21 10:11 devfs
8346968 -r-xr-xr-x  1 root  wheel   1327 Jul 21 10:11 dhclient
8346989 -r-xr-xr-x  1 root  wheel    473 Jul 21 10:11 dmesg
8346864 -r-xr-xr-x  1 root  wheel   1194 Jul 21 10:11 dumpon
8346998 -r-xr-xr-x  1 root  wheel   1597 Jul 21 10:11 fsck
8346947 -r-xr-xr-x  1 root  wheel   2421 Jul 21 10:11 ftp-proxy
8346929 -r-xr-xr-x  1 root  wheel    436 Jul 21 10:11 ftpd
8346913 -r-xr-xr-x  1 root  wheel   2212 Jul 21 10:11 gbde
8346889 -r-xr-xr-x  1 root  wheel   2714 Jul 21 10:11 geli
8347001 -r-xr-xr-x  1 root  wheel   1985 Jul 21 10:11 geli2
8346900 -r-xr-xr-x  1 root  wheel   2582 Jul 21 10:11 gptboot
8346879 -r-xr-xr-x  1 root  wheel   2858 Jul 21 10:11 growfs
8346871 -r-xr-xr-x  1 root  wheel    273 Jul 21 10:11 gssd
8346988 -r-xr-xr-x  1 root  wheel    566 Jul 21 10:11 hastd
8347014 -r-xr-xr-x  1 root  wheel    525 Jul 21 10:11 hcsecd
8346924 -r-xr-xr-x  1 root  wheel    685 Jul 21 10:11 hostapd
8346863 -r-xr-xr-x  1 root  wheel   3824 Jul 21 10:11 hostid
8346934 -r-xr-xr-x  1 root  wheel    654 Jul 21 10:11 hostid_save
8346965 -r-xr-xr-x  1 root  wheel   2593 Jul 21 10:11 hostname
8346930 -r-xr-xr-x  1 root  wheel    405 Jul 21 10:11 inetd
8346873 -r-xr-xr-x  1 root  wheel    511 Jul 21 10:11 iovctl
8346897 -r-xr-xr-x  1 root  wheel   2647 Jul 21 10:11 ip6addrctl
8346952 -r-xr-xr-x  1 root  wheel   2092 Jul 21 10:11 ipfilter
8346882 -r-xr-xr-x  1 root  wheel   1116 Jul 21 10:11 ipfs
8346898 -r-xr-xr-x  1 root  wheel   2448 Jul 21 10:11 ipfw
8346881 -r-xr-xr-x  1 root  wheel    764 Jul 21 10:11 ipmon
8346919 -r-xr-xr-x  1 root  wheel    583 Jul 21 10:11 ipnat
8346994 -r-xr-xr-x  1 root  wheel    772 Jul 21 10:11 ipropd_master
8346910 -r-xr-xr-x  1 root  wheel    577 Jul 21 10:11 ipropd_slave
8346944 -r-xr-xr-x  1 root  wheel   1168 Jul 21 10:11 ipsec
8346971 -r-xr-xr-x  1 root  wheel    399 Jul 21 10:11 iscsictl
8346956 -r-xr-xr-x  1 root  wheel    371 Jul 21 10:11 iscsid
8346909 -r-xr-xr-x  1 root  wheel  14288 Jul 21 10:11 jail
8346985 -r-xr-xr-x  1 root  wheel    581 Jul 21 10:11 kadmind
8347016 -r-xr-xr-x  1 root  wheel    529 Jul 21 10:11 kdc
8346957 -r-xr-xr-x  1 root  wheel    474 Jul 21 10:11 keyserv
8346908 -r-xr-xr-x  1 root  wheel    356 Jul 21 10:11 kfd
8347000 -r-xr-xr-x  1 root  wheel   1758 Jul 21 10:11 kld
8346904 -r-xr-xr-x  1 root  wheel    709 Jul 21 10:11 kldxref
8346901 -r-xr-xr-x  1 root  wheel    562 Jul 21 10:11 kpasswdd
8346987 -r-xr-xr-x  1 root  wheel   2429 Jul 21 10:11 ldconfig
8346868 -r-xr-xr-x  1 root  wheel    587 Jul 21 10:11 local
8346877 -r-xr-xr-x  1 root  wheel   2705 Jul 21 10:11 local_unbound
8347007 -r-xr-xr-x  1 root  wheel   1436 Jul 21 10:11 localpkg
8346902 -r-xr-xr-x  1 root  wheel    686 Jul 21 10:11 lockd
8346950 -r-xr-xr-x  1 root  wheel    475 Jul 21 10:11 lpd
8346860 -r-xr-xr-x  1 root  wheel   5162 Jul 21 10:11 mdconfig
8346972 -r-xr-xr-x  1 root  wheel   6070 Jul 21 10:11 mdconfig2
8346884 -r-xr-xr-x  1 root  wheel   2518 Jul 21 10:11 mixer
8346941 -r-xr-xr-x  1 root  wheel   1037 Jul 21 10:11 motd
8346853 -r-xr-xr-x  1 root  wheel   1299 Jul 21 10:11 mountcritlocal
8346872 -r-xr-xr-x  1 root  wheel   1928 Jul 21 10:11 mountcritremote
8346899 -r-xr-xr-x  1 root  wheel   1004 Jul 21 10:11 mountd
8347008 -r-xr-xr-x  1 root  wheel    789 Jul 21 10:11 mountlate
8346893 -r-xr-xr-x  1 root  wheel   1703 Jul 21 10:11 moused
8346903 -r-xr-xr-x  1 root  wheel    456 Jul 21 10:11 msgs
8346890 -r-xr-xr-x  1 root  wheel    818 Jul 21 10:11 natd
8346858 -r-xr-xr-x  1 root  wheel   5935 Jul 21 10:11 netif
8346977 -r-xr-xr-x  1 root  wheel   2836 Jul 21 10:11 netoptions
8346915 -r-xr-xr-x  1 root  wheel   3139 Jul 21 10:11 netwait
8346880 -r-xr-xr-x  1 root  wheel    524 Jul 21 10:11 newsyslog
8346896 -r-xr-xr-x  1 root  wheel    346 Jul 21 10:11 nfscbd
8346966 -r-xr-xr-x  1 root  wheel   1122 Jul 21 10:11 nfsclient
8346980 -r-xr-xr-x  1 root  wheel   1085 Jul 21 10:11 nfsd
8346976 -r-xr-xr-x  1 root  wheel    578 Jul 21 10:11 nfsuserd
8346861 -r-xr-xr-x  1 root  wheel   1867 Jul 21 10:11 nisdomain
8347013 -r-xr-xr-x  1 root  wheel   1121 Jul 21 10:11 nscd
8346974 -r-xr-xr-x  1 root  wheel   2631 Jul 21 10:11 nsswitch
8346948 -r-xr-xr-x  1 root  wheel   4062 Jul 21 10:11 ntpd
8346975 -r-xr-xr-x  1 root  wheel    759 Jul 21 10:11 ntpdate
8346869 -r-xr-xr-x  1 root  wheel    350 Jul 21 10:11 othermta
8346940 -r-xr-xr-x  1 root  wheel   1434 Jul 21 10:11 pf
8347010 -r-xr-xr-x  1 root  wheel   2355 Jul 21 10:11 pflog
8346986 -r-xr-xr-x  1 root  wheel    855 Jul 21 10:11 pfsync
8346874 -r-xr-xr-x  1 root  wheel   2174 Jul 21 10:11 power_profile
8346885 -r-xr-xr-x  1 root  wheel    491 Jul 21 10:11 powerd
8346993 -r-xr-xr-x  1 root  wheel   2390 Jul 21 10:11 ppp
8346958 -r-xr-xr-x  1 root  wheel    647 Jul 21 10:11 pppoed
8346933 -r-xr-xr-x  1 root  wheel    491 Jul 21 10:11 pwcheck
8347003 -r-xr-xr-x  1 root  wheel    637 Jul 21 10:11 quota
8346951 -r-xr-xr-x  1 root  wheel   3118 Jul 21 10:11 random
8346925 -r-xr-xr-x  1 root  wheel    396 Jul 21 10:11 rarpd
8346866 -r-xr-xr-x  1 root  wheel    529 Jul 21 10:11 rctl
8346967 -r-xr-xr-x  1 root  wheel   2030 Jul 21 10:11 resolv
8346854 -r-xr-xr-x  1 root  wheel   2440 Jul 21 10:11 rfcomm_pppd_server
8346982 -r-xr-xr-x  1 root  wheel    784 Jul 21 10:11 root
8346912 -r-xr-xr-x  1 root  wheel    428 Jul 21 10:11 route6d
8346883 -r-xr-xr-x  1 root  wheel    453 Jul 21 10:11 routed
8346856 -r-xr-xr-x  1 root  wheel   7920 Jul 21 10:11 routing
8346931 -r-xr-xr-x  1 root  wheel    394 Jul 21 10:11 rpcbind
8346867 -r-xr-xr-x  1 root  wheel   1715 Jul 21 10:11 rtadvd
8347006 -r-xr-xr-x  1 root  wheel    488 Jul 21 10:11 rtsold
8346935 -r-xr-xr-x  1 root  wheel    307 Jul 21 10:11 rwho
8346979 -r-xr-xr-x  1 root  wheel   1366 Jul 21 10:11 savecore
8346943 -r-xr-xr-x  1 root  wheel    525 Jul 21 10:11 sdpd
8346927 -r-xr-xr-x  1 root  wheel    595 Jul 21 10:11 securelevel
8346970 -r-xr-xr-x  1 root  wheel   6446 Jul 21 10:11 sendmail
8346964 -r-xr-xr-x  1 root  wheel   5169 Jul 21 10:11 serial
8346962 -r-xr-xr-x  1 root  wheel    895 Jul 21 10:11 sppp
8346999 -r-xr-xr-x  1 root  wheel   1596 Jul 21 10:11 sshd
8346906 -r-xr-xr-x  1 root  wheel    648 Jul 21 10:11 statd
8346862 -r-xr-xr-x  1 root  wheel   2259 Jul 21 10:11 static_arp
8346942 -r-xr-xr-x  1 root  wheel   2226 Jul 21 10:11 static_ndp
8346963 -r-xr-xr-x  1 root  wheel   1932 Jul 21 10:11 stf
8346916 -r-xr-xr-x  1 root  wheel    284 Jul 21 10:11 swap
8346907 -r-xr-xr-x  1 root  wheel    325 Jul 21 10:11 swaplate
8346914 -r-xr-xr-x  1 root  wheel   8031 Jul 21 10:11 syscons
8346857 -r-xr-xr-x  1 root  wheel    654 Jul 21 10:11 sysctl
8347004 -r-xr-xr-x  1 root  wheel   1582 Jul 21 10:11 syslogd
8346923 -r-xr-xr-x  1 root  wheel    314 Jul 21 10:11 timed
8346938 -r-xr-xr-x  1 root  wheel   2202 Jul 21 10:11 tmp
8346932 -r-xr-xr-x  1 root  wheel    829 Jul 21 10:11 ubthidhci
8346859 -r-xr-xr-x  1 root  wheel   1054 Jul 21 10:11 ugidfw
8346875 -r-xr-xr-x  1 root  wheel    325 Jul 21 10:11 utx
8346995 -r-xr-xr-x  1 root  wheel   3291 Jul 21 10:11 var
8346959 -r-xr-xr-x  1 root  wheel   1649 Jul 21 10:11 virecover
8347005 -r-xr-xr-x  1 root  wheel   1745 Jul 21 10:11 watchdogd
8346894 -r-xr-xr-x  1 root  wheel    887 Jul 21 10:11 wpa_supplicant
8346991 -r-xr-xr-x  1 root  wheel    566 Jul 21 10:11 ypbind
8347012 -r-xr-xr-x  1 root  wheel    423 Jul 21 10:11 ypldap
8346917 -r-xr-xr-x  1 root  wheel    649 Jul 21 10:11 yppasswdd
8346920 -r-xr-xr-x  1 root  wheel    646 Jul 21 10:11 ypserv
8346911 -r-xr-xr-x  1 root  wheel    605 Jul 21 10:11 ypset
8346887 -r-xr-xr-x  1 root  wheel    563 Jul 21 10:11 ypupdated
8346918 -r-xr-xr-x  1 root  wheel    602 Jul 21 10:11 ypxfrd
8346990 -r-xr-xr-x  1 root  wheel    931 Jul 21 10:11 zfs
8346921 -r-xr-xr-x  1 root  wheel   1470 Jul 21 10:11 zfsbe
8347017 -r-xr-xr-x  1 root  wheel    273 Jul 21 10:11 zfsd
8346876 -r-xr-xr-x  1 root  wheel    815 Jul 21 10:11 zvol
root@Tom's Server:/ #
 
Not only MySQL, transmission has the same issue

It's not the same issue. It's saying it can't find a transmission-daemon script. It won't be in /etc/rc.d as that directory contains built-in services only. Have a look in /usr/local/etc/rc.d. This is where the start up scripts for 3rd party software are.

The MySQL script is complaining about a script error somewhere but I'm not quite sure what could be causing that. Installing and starting MySQL should literally be a 60 second process and it's not obvious why you are getting a script error.

Edit: scratch that, it uses the hostname for the pidfile location so I wouldn't be surprised if your choice of hostname is causing the problem. I said it was asking for trouble...
 
Subtle mistake. It's your hostname. Hostnames cannot contain spaces and certainly cannot contain quotes. Hostnames are always lower-case and can consist of letters (a-z), numbers (0-9) or a dash (-). It cannot start or end with a dash (-).
 
It sounds as though something has got messed up. Personally, if you are not familiar with FreeBSD and have not yet done much with your current installation it may be better to delete everything and start again from scratch... Install FreeBSD and then install MySQL. It should be relatively straightforward.
 
MySQL is under the directory of /usr/local/etc/rc.d

Code:
root@Tom's Server:/ # ls -li /usr/local/etc/rc.d
total 52
23851211 -r-xr-xr-x  1 root  wheel  6230 Jan  2 09:53 apache24
23851563 -r-xr-xr-x  1 root  wheel   881 Jan  2 14:01 avahi-daemon
23851564 -r-xr-xr-x  1 root  wheel  1129 Jan  2 14:01 avahi-dnsconfd
23851565 -r-xr-xr-x  1 root  wheel   539 Jan  2 14:03 cupsd
23851560 -r-xr-xr-x  1 root  wheel   796 Jan  2 09:29 dbus
23851212 -r-xr-xr-x  1 root  wheel  1834 Jan  2 09:53 htcacheclean
23854072 -r-xr-xr-x  1 root  wheel   691 Dec 10 12:52 miniupnpc
23854071 -r-xr-xr-x  1 root  wheel  2547 Jan  3 19:52 mysql-server
23851575 -r-xr-xr-x  1 root  wheel  1081 Dec 21 09:08 rsyncd
23851561 -r-xr-xr-x  1 root  wheel  1239 Jan  2 10:02 tcsd
23851558 -r-xr-xr-x  1 root  wheel   628 Jan  2 10:00 tpmd
23854073 -r-xr-xr-x  1 root  wheel  2878 Jan  3 05:09 transmission
 
Back
Top