installation - Local MYSQL won't start OS X 10.9.3 -
i have downloaded mysql via:
bash <(curl -ls http://git.io/eux7rg)
prior installing i've uninstalled previous components via:
http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x
i've had modify permissions in order see log file , see permissions errors. also, when try:
type mysql
the result, in terminal, points directory not exist on local system. when trace path executable (via finder) next error in terminal:
/usr/local/mysql-5.6.19-osx10.7-x86_64/bin/mysql ; exit; error 2002 (hy000): can't connect local mysql server through socket '/var/mysql/mysql.sock' (2) logout
also, when @ my.conf file, asterisked out:
# advice on how alter settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] # remove leading # , set amount of ram of import info # cache in mysql. start @ 70% of total ram dedicated server, else 10%. # innodb_buffer_pool_size = 128m # remove leading # turn on of import info integrity option: logging # changes binary log between backups. # log_bin # these commonly set, remove # , set required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... # socket = ..... # remove leading # set options useful reporting servers. # server defaults faster transactions , fast selects. # adjust sizes needed, experiment find optimal values. # join_buffer_size = 128m # sort_buffer_size = 2m # read_rnd_buffer_size = 2m sql_mode=no_engine_substitution,strict_trans_tables
had same problem. had switch machines week , installing mysql on "os x 10.9.3 (13d65)" not work. had wipe business relationship clean , reinitialize user going. apparently there still old mysql wasn't uninstalled completely. google "uninstall mysql manually"
the access denied happens sometime when grant given interface 127.0.0.1 not localhost.
try granting access %, 127.0.0.1, , localhost.
mysql installation
No comments:
Post a Comment