Changes between Version 4 and Version 5 of ChefNotes

Timestamp:

May 15, 2014 2:26:37 PM (10 years ago)

Author:

Geoff Lawler

Comment:

--

ChefNotes

@@ -29 +29 @@
            * tbdb is running "skip-grant-tables" so anyone on the localhost can assess it.
            * doing "mysql -h myboss -P 7777" gives cryptic error {{{ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0}}}. 
+           * Found the DB startup script: /usr/local/etc/rc.d/2.mysql-server.sh
+             * Options passed to mysql: "--pid-file=/var/db/mysql/mysqld.pid --skip-grant-tables --skip-networking --user=mysql --log=/usr/testbed/log/mysql/base --log-bin=/usr/testbed/log/mysql/update --log-slow-queries=/usr/testbed/log/mysql/slowqueries --max_connections=500"
+             * That --skip-networking is troubling. Yeah, we need to change that: {{{Do not listen for TCP/IP connections at all. All interaction with mysqld must be made using named pipes or shared memory (on Windows) or Unix socket files (on Unix). This option is highly recommended for systems where only local clients are permitted.}}}
+             * I'll restart mysql on myboss without that argument, then I'll investigate secure remote access. 
 
 === Scratch ===