And w/ a new install via homebrew, it all went smoothly as it could have
been the first time around, connected easily.
Happy Monday, everyone!
BirgitOn Sun, Aug 2, 2015 at 11:22 PM, Birgit Pauli-Haack <@Birgit_Pauli-Haack> wrote:
Hi Jon,
I decided to uninstall MySQL for now and let it sit for now. I’ll take
another stab at it again tomorrow.Kai, yet, that was a good thought regarding Firewall, but I switch the
firewall off during testing of this issue.Thanks for all your suggestions. I really appreciate it. I’ll report back
on my next round of it.Regards,
Birgit[image: photo]
Birgit Pauli-Haack
Web & Mobile Developer / Project Manager
m:239-595-3882 | e:@Birgit_Pauli-Haack | a:Naples, Florida
http://twitter.com/bph http://klout.com/#/bph
http://instagram.com/idx http://plus.google.com/+BirgitPauli-Haack/On Sun, Aug 2, 2015 at 6:15 PM, Jon Clausen <@Jon_Clausen> wrote:
There are so many ways to install MySQL on OSX so your binary may be
different, but if you installed it with Homebrew, the startup binary used
by homebrew is located at /usr/local/opt/mysql/bin/mysqld_safeYou can also start/stop/restart by loading and unloading the .plist file :
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
&&
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plistOn August 2, 2015 at 4:16:12 PM, Birgit Pauli-Haack ( @Birgit_Pauli-Haack) wrote:
Appreciate jumping this so fast. Thanks
But it’s still a not go…
the my.cnf file is location under /usr/local/mysql/my.cnf
looks now like this:
For advice on how to change settings please see
http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
Remove leading # and set to the amount of RAM for the most important
data
cache in MySQL. Start at 70% of total RAM for dedicated server, else
10%.
innodb_buffer_pool_size = 128M
Remove leading # to turn on a very important data integrity option:
logging
changes to the binary log between backups.
log_bin
These are commonly set, remove the # and set as required.
basedir = …
datadir = …
port = 3306
server_id = …
socket = …
bind-address = 127.0.0.1
Remove leading # to set options mainly useful for reporting servers.
The server defaults are faster for transactions and fast SELECTs.
Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
But now mysql doesn’t start any more
Birgits-MacBook-Pro:mysql birgit$ sudo -u root
/usr/local/mysql/support-files/mysql.server restartERROR! MySQL server PID file could not be found!
Starting MySQL
…
ERROR! The server quit without updating PID file
(/usr/local/mysql/data/Birgits-MacBook-Pro.local.pid).Birgits-MacBook-Pro:mysql birgit$
Some how this is jinx… I need to walk away for now…
If you have some other ideas, I’d appreciate it.
Birgit
On Sunday, August 2, 2015 at 2:46:02 PM UTC-4, Jon Clausen wrote:
Oops. Sorry for the typo below. That should be:
bind-address = 127.0.0.1
You can use 0.0.0.0 to bind to all interfaces, but I wouldn’t recommend
it.You might need to explicitly specify the IP in your GRANT statement as
well if your loopback doesn’t resolve localhost correctly (Airport on OS X
can have some weirdness with the loopback when not connected to WiFi):USE mysql;
GRANT ALL ON [dbname] TO ‘myuser’@‘127.0.0.1’;
FLUSH PRIVILEGES;You can use the ‘%’ option instead of the IP in your grant statement to
allow from all interfaces but, again, I wouldn’t recommend it.On August 2, 2015 at 2:37:57 PM, Jon Clausen (jon_c...@silowebworks.com) wrote:
You likely need to enable TCP/IP connections in your my.cnf file or
startup MySQL without the —skip-networking option (make sure it’s also
commented out in the [mysqld] section of your my.cnf:#adjust the config in this block:
[mysqld]
#leave the other config options above this alonebind-address = 127.0.0.0
skip-networking
You will also need to grant privileges in your user table to that
database:mysql -uroot -pmypassword
USE mysql;
GRANT ALL ON [dbname] TO ‘myuser’@‘localhost’;
FLUSH PRIVILEGES;On August 2, 2015 at 2:00:26 PM, Birgit Pauli-Haack (birgit...@gmail.com) wrote:
HI there,
I am bit in a bind, and don’t known how to troubleshoot it.
I installed MySQL via dmg defaults on MAC OS X 10.10.4
Lucee 4.5.1.022 is running on tomcat-8.0.24Now I need to create a datasource in Lucee to a db on mysql and it seem
that local host connnection only works via TCP/IP
But it seem mysql is only allowing only a connection via UNIX socketIn Lucee server admin I get this message: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server.When I try to connect MySQL Workbench to the server via Standard
(TCP/IP) - I get also an error
See scree shot.I successfully connect the work bench via “Local Socket/Pipe”
on command line mysql > status give me this read out:
Connection id: 23
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ‘’
Using delimiter: ;
Server version: 5.6.26 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 57 sec
I did a lot of reading but some how, I can’t find either how to change
MySQL configuration to accept TCP/IP connection or get Lucee to connect via
UNIX socket.Any help would be appreciated.
Birgit
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get
your ticket NOW - http://www.cfcamp.org/You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/0c4e2340-bd69-4afa-98f3-952f59eeb3ce%40googlegroups.com
https://groups.google.com/d/msgid/lucee/0c4e2340-bd69-4afa-98f3-952f59eeb3ce%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your
ticket NOW - http://www.cfcamp.org/
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/92e3e535-524e-42a8-9e35-a0ee70fce0df%40googlegroups.com
https://groups.google.com/d/msgid/lucee/92e3e535-524e-42a8-9e35-a0ee70fce0df%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your
ticket NOW - http://www.cfcamp.org/You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/etPan.55be9689.542ac125.39e9%40jonclausen-mbp.local
https://groups.google.com/d/msgid/lucee/etPan.55be9689.542ac125.39e9%40jonclausen-mbp.local?utm_medium=email&utm_source=footer
.For more options, visit https://groups.google.com/d/optout.
