Wednesday, 15 February 2012

installation - Local MYSQL won't start OS X 10.9.3 -



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