In Lucee server admin I get this message: Communications link failure
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.
--
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.
For more options, visit https://groups.google.com/d/optout.
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 alone
bind-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;
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.
Birgits-MacBook-Pro:mysql birgit$ sudo -u root /usr/local/mysql/support-files/mysql.server restart
ERROR! 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
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_safe
You 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.plist
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/92e3e535-524e-42a8-9e35-a0ee70fce0df%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/etPan.55be9689.542ac125.39e9%40jonclausen-mbp.local.