Re: Can't Bind to Port

[Drew Jenkins]

----- Original Message ----
From: ed <etharp@stripped>
To: Drew Jenkins <drewjenkinsjr@stripped>
Sent: Saturday, March 3, 2007 1:06:16 PM
Subject: Re: Can't Bind to Port

None of those directories existed on my system. So I decided to try and find the ones to
which you referred. The matches were inexact. Now, before I go changing permissions and
regret a mistake, please advise me according to the following:

# find / -name mysqld
/usr/local/libexec/mysqld
# find / -name mysql
/usr/local/bin/mysql
/usr/local/include/mysql
/usr/local/lib/mysql
/usr/local/libdata/ldconfig/mysql
/usr/local/share/mysql
/var/db/mysql
/var/db/mysql/mysql
# ls -al /usr/local/libexec/mysqld
-r-xr-xr-x  1 root  wheel  5035236 Mar  1 06:53 /usr/local/libexec/mysqld
# ls -al /usr/local/bin/mysql
-r-xr-xr-x  1 root  wheel  65644 Mar  1 06:37 /usr/local/bin/mysql
# ls -al /usr/local/include/mysql
total 348
drwxr-xr-x   2 root  wheel   1024 Mar  1 06:37 .
drwxr-xr-x  10 root  wheel   1536 Mar  1 06:37 ..
-r--r--r--   1 root  wheel   3785 Mar  1 06:37 errmsg.h
-r--r--r--   1 root  wheel   6778 Mar  1 06:37 keycache.h
-r--r--r--   1 root  wheel  20593 Mar  1 06:37 m_ctype.h
-r--r--r--   1 root  wheel   7683 Mar  1 06:37 m_string.h
-r--r--r--   1 root  wheel   1859 Mar  1 06:37 my_alloc.h
-r--r--r--   1 root  wheel  31704 Mar  1 06:37 my_config.h
-r--r--r--   1 root  wheel   4496 Mar  1 06:37 my_dbug.h
-r--r--r--   1 root  wheel   3509 Mar  1 06:37 my_dir.h
-r--r--r--   1 root  wheel   3000 Mar  1 06:37 my_getopt.h
-r--r--r--   1 root  wheel  46625 Mar  1 06:37 my_global.h
-r--r--r--   1 root  wheel   1515 Mar  1 06:37 my_list.h
-r--r--r--   1 root  wheel   3611 Mar  1 06:37 my_net.h
-r--r--r--   1 root  wheel   1591 Mar  1 06:37 my_no_pthread.h
-r--r--r--   1 root  wheel  23125 Mar  1 06:37 my_pthread.h
-r--r--r--   1 root  wheel   1784 Mar  1 06:37 my_semaphore.h
-r--r--r--   1 root  wheel  36574 Mar  1 06:37 my_sys.h
-r--r--r--   1 root  wheel   2710 Mar  1 06:37 my_xml.h
-r--r--r--   1 root  wheel  33180 Mar  1 06:37 mysql.h
-r--r--r--   1 root  wheel  17215 Mar  1 06:37 mysql_com.h
-r--r--r--   1 root  wheel   1224 Mar  1 06:37 mysql_embed.h
-r--r--r--   1 root  wheel   2184 Mar  1 06:37 mysql_time.h
-r--r--r--   1 root  wheel    800 Mar  1 06:37 mysql_version.h
-r--r--r--   1 root  wheel  20111 Mar  1 06:37 mysqld_ername.h
-r--r--r--   1 root  wheel  20166 Mar  1 06:37 mysqld_error.h
-r--r--r--   1 root  wheel   9766 Mar  1 06:37 plugin.h
-r--r--r--   1 root  wheel   1751 Mar  1 06:37 sql_common.h
-r--r--r--   1 root  wheel  11049 Mar  1 06:37 sql_state.h
-r--r--r--   1 root  wheel   1055 Mar  1 06:37 sslopt-case.h
-r--r--r--   1 root  wheel   2212 Mar  1 06:37 sslopt-longopts.h
-r--r--r--   1 root  wheel   1156 Mar  1 06:37 sslopt-vars.h
-r--r--r--   1 root  wheel   1265 Mar  1 06:37 typelib.h
# ls -al /usr/local/lib/mysql
total 5770
drwxr-xr-x   2 root  wheel      512 Mar  1 06:52 .
drwxr-xr-x  12 root  wheel     2560 Mar  1 06:37 ..
-r--r--r--   1 root  wheel    13338 Mar  1 06:52 libdbug.a
-r--r--r--   1 root  wheel    42044 Mar  1 06:52 libheap.a
-r--r--r--   1 root  wheel   320090 Mar  1 06:52 libmyisam.a
-r--r--r--   1 root  wheel    24866 Mar  1 06:52 libmyisammrg.a
-rw-r--r--   1 root  wheel  1331032 Mar  1 06:37 libmysqlclient.a
-rwxr-xr-x   1 root  wheel      896 Mar  1 06:37 libmysqlclient.la
lrwxr-xr-x   1 root  wheel       20 Mar  1 06:37 libmysqlclient.so ->
libmysqlclient.so.15
-rwxr-xr-x   1 root  wheel  1030523 Mar  1 06:37 libmysqlclient.so.15
-rw-r--r--   1 root  wheel  1338384 Mar  1 06:37 libmysqlclient_r.a
-rwxr-xr-x   1 root  wheel      928 Mar  1 06:37 libmysqlclient_r.la
lrwxr-xr-x   1 root  wheel       22 Mar  1 06:37 libmysqlclient_r.so ->
libmysqlclient_r.so.15
-rwxr-xr-x   1 root  wheel  1036507 Mar  1 06:37 libmysqlclient_r.so.15
-r--r--r--   1 root  wheel   299208 Mar  1 06:52 libmystrings.a
-r--r--r--   1 root  wheel   268090 Mar  1 06:52 libmysys.a
-r--r--r--   1 root  wheel    12290 Mar  1 06:52 libvio.a
# ls -al /usr/local/libdata/ldconfig/mysql
-rw-r--r--  1 root  wheel  21 Mar  1 06:37 /usr/local/libdata/ldconfig/mysql
# ls -al /usr/local/share/mysql
total 936
drwxr-xr-x  26 root  wheel    1024 Mar  1 06:53 .
drwxr-xr-x  24 root  wheel    1024 Mar  1 06:37 ..
-r--r--r--   1 root  wheel     801 Mar  1 06:53 binary-configure
drwxr-xr-x   2 root  wheel    1024 Mar  1 06:53 charsets
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 czech
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 danish
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 dutch
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 english
-r--r--r--   1 root  wheel  356623 Mar  1 06:53 errmsg.txt
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 estonian
-r--r--r--   1 root  wheel  399219 Mar  1 06:53 fill_help_tables.sql
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 french
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 german
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 greek
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 hungarian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 italian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 japanese
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 korean
-r--r--r--   1 root  wheel    4702 Mar  1 06:52 mi_test_all
-r--r--r--   1 root  wheel    1517 Mar  1 06:52 mi_test_all.res
-r--r--r--   1 root  wheel    4901 Mar  1 06:53 my-huge.cnf
-r--r--r--   1 root  wheel   20902 Mar  1 06:53 my-innodb-heavy-4G.cnf
-r--r--r--   1 root  wheel    4878 Mar  1 06:53 my-large.cnf
-r--r--r--   1 root  wheel    4885 Mar  1 06:53 my-medium.cnf
-r--r--r--   1 root  wheel    2454 Mar  1 06:53 my-small.cnf
-r--r--r--   1 root  wheel     805 Mar  1 06:53 mysql-log-rotate
-r-xr-xr-x   1 root  wheel    8840 Mar  1 06:53 mysql.server
-r--r--r--   1 root  wheel   31693 Mar  1 06:37 mysql_fix_privilege_tables.sql
-r--r--r--   1 root  wheel     589 Mar  1 06:53 ndb-config-2-node.ini
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 norwegian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 norwegian-ny
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 polish
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 portuguese
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 romanian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 russian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 serbian
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 slovak
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 spanish
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 swedish
drwxr-xr-x   2 root  wheel     512 Mar  1 06:53 ukrainian
# ls -al /var/db/mysql
total 102
drwx------  15 mysql  mysql       512 Mar  3 11:21 .
drwxr-xr-x  10 root   wheel       512 Mar  1 07:48 ..
drwx------   2 mysql  mysql       512 Mar  2 15:05 authdaemon
drwx------   2 mysql  mysql       512 Mar  2 15:09 autodepot
drwx------   2 mysql  mysql       512 Mar  2 15:09 botBase
drwx------   2 mysql  mysql       512 Feb 28 02:06 cluster
drwx------   2 mysql  mysql       512 Mar  2 15:09 emerald
drwx------   2 mysql  mysql       512 Mar  2 15:09 foxyslager
drwx------   2 mysql  mysql       512 Mar  2 15:09 grandjewelers
-rw-r--r--   1 mysql  mysql         0 Feb 27 11:34 ibdata1
drwx------   2 mysql  mysql       512 Mar  2 15:09 larimarmountain
-rw-rw----   1 mysql  mysql  10485760 Mar  3 11:18 log.0000000001
drwx------   2 mysql  mysql      1536 Mar  2 15:09 mango
drwx------   2 mysql  mysql      1536 Mar  2 15:09 mothersrings
drwx------   2 mysql  mysql       512 Mar  2 15:09 mrtablecloth
drwx------   2 mysql  mysql      2048 Feb 28 02:06 mysql
-rw-rw----   1 mysql  mysql     21388 Mar  3 11:21 .web.vi.err
-rw-rw----   1 mysql  mysql         4 Mar  3 11:21 .web.vi.pid
drwx------   2 mysql  mysql       512 Feb 28 02:06 test
# ls -al /var/db/mysql/mysql
total 698
drwx------   2 mysql  mysql    2048 Feb 28 02:06 .
drwx------  15 mysql  mysql     512 Mar  3 11:21 ..
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 columns_priv.MYD
-rw-rw----   1 mysql  mysql    4096 Feb 28 02:06 columns_priv.MYI
-rw-rw----   1 mysql  mysql    8820 Feb 28 02:06 columns_priv.frm
-rw-rw----   1 mysql  mysql     880 Feb 28 02:06 db.MYD
-rw-rw----   1 mysql  mysql    5120 Feb 28 02:06 db.MYI
-rw-rw----   1 mysql  mysql    9582 Feb 28 02:06 db.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 event.MYD
-rw-rw----   1 mysql  mysql    4096 Feb 28 02:06 event.MYI
-rw-rw----   1 mysql  mysql    9817 Feb 28 02:06 event.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 func.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 func.MYI
-rw-rw----   1 mysql  mysql    8665 Feb 28 02:06 func.frm
-rw-rw----   1 mysql  mysql      35 Mar  3 11:21 general_log.CSM
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 general_log.CSV
-rw-rw----   1 mysql  mysql    8776 Feb 28 02:06 general_log.frm
-rw-rw----   1 mysql  mysql   21497 Mar  1 16:10 help_category.MYD
-rw-rw----   1 mysql  mysql    3072 Mar  1 16:10 help_category.MYI
-rw-rw----   1 mysql  mysql    8700 Feb 28 02:06 help_category.frm
-rw-rw----   1 mysql  mysql   76436 Mar  1 16:10 help_keyword.MYD
-rw-rw----   1 mysql  mysql   14336 Mar  1 16:10 help_keyword.MYI
-rw-rw----   1 mysql  mysql    8612 Feb 28 02:06 help_keyword.frm
-rw-rw----   1 mysql  mysql    6759 Mar  1 16:10 help_relation.MYD
-rw-rw----   1 mysql  mysql   13312 Mar  1 16:10 help_relation.MYI
-rw-rw----   1 mysql  mysql    8630 Feb 28 02:06 help_relation.frm
-rw-rw----   1 mysql  mysql  257428 Mar  1 16:10 help_topic.MYD
-rw-rw----   1 mysql  mysql   18432 Mar  1 16:10 help_topic.MYI
-rw-rw----   1 mysql  mysql    8770 Feb 28 02:06 help_topic.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 host.MYD
-rw-rw----   1 mysql  mysql    2048 Feb 28 02:06 host.MYI
-rw-rw----   1 mysql  mysql    9510 Feb 28 02:06 host.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 plugin.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 plugin.MYI
-rw-rw----   1 mysql  mysql    8586 Feb 28 02:06 plugin.frm
-rw-rw----   1 mysql  mysql     576 Feb 28 02:06 proc.MYD
-rw-rw----   1 mysql  mysql    4096 Feb 28 02:06 proc.MYI
-rw-rw----   1 mysql  mysql    9691 Feb 28 02:06 proc.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 procs_priv.MYD
-rw-rw----   1 mysql  mysql    4096 Feb 28 02:06 procs_priv.MYI
-rw-rw----   1 mysql  mysql    8875 Feb 28 02:06 procs_priv.frm
-rw-rw----   1 mysql  mysql      35 Mar  3 11:21 slow_log.CSM
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 slow_log.CSV
-rw-rw----   1 mysql  mysql    8976 Feb 28 02:06 slow_log.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 tables_priv.MYD
-rw-rw----   1 mysql  mysql    4096 Feb 28 02:06 tables_priv.MYI
-rw-rw----   1 mysql  mysql    8955 Feb 28 02:06 tables_priv.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 time_zone.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 time_zone.MYI
-rw-rw----   1 mysql  mysql    8636 Feb 28 02:06 time_zone.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 time_zone_leap_second.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 time_zone_leap_second.MYI
-rw-rw----   1 mysql  mysql    8624 Feb 28 02:06 time_zone_leap_second.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 time_zone_name.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 time_zone_name.MYI
-rw-rw----   1 mysql  mysql    8606 Feb 28 02:06 time_zone_name.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 time_zone_transition.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 time_zone_transition.MYI
-rw-rw----   1 mysql  mysql    8686 Feb 28 02:06 time_zone_transition.frm
-rw-rw----   1 mysql  mysql       0 Feb 28 02:06 time_zone_transition_type.MYD
-rw-rw----   1 mysql  mysql    1024 Feb 28 02:06 time_zone_transition_type.MYI
-rw-rw----   1 mysql  mysql    8748 Feb 28 02:06 time_zone_transition_type.frm
-rw-rw----   1 mysql  mysql     216 Feb 28 02:06 user.MYD
-rw-rw----   1 mysql  mysql    2048 Feb 28 02:06 user.MYI
-rw-rw----   1 mysql  mysql   10466 Feb 28 02:06 user.frm

TIA,
Drew






 
____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091