Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Larry Martell
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote: > I created (or activated) the root account and now I see the error log: > > sh-3.2# cat miniMac.local.err > 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from > /usr/local/mysql/data > 120229 10:36:09 [Warning] Setting lower_cas

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
Looks like 5.1.61 mac installer messed up the privilege setting... But how to fix it? I remember the server account is mysql, not _mysql What do you got? And how to fix it? Thanks On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote: > I created (or activated) the root account and now I see the erro

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
I created (or activated) the root account and now I see the error log: sh-3.2# cat miniMac.local.err 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Darryle Steplight
If you are going to use "su" to officially switch to the root users just make sure you do "su -" with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald wrote: > > > Am 29.02.2012 19:20, schrieb Larry Martell: >> Is the sudo succeeding? If it is, then there's no reason you shouldn't >> be

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Larry Martell
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu wrote: > > -rw-r--r--   1 root    wheel  17987 Dec 17 09:01 COPYING > -rw-r--r--   1 root    wheel   7371 Dec 17 09:01 INSTALL-BINARY > -rw-r--r--   1 root    wheel   2552 Dec 17 09:01 README > drwxr-xr-x  46 root    wheel   1564 Dec 17 09:01 bin > drwxr-

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Darryle Steplight
Are you looking in /usr/local/mysql/data ? You should see a username.err file. You might have to sudo to open the file just do "sudo tail -f FILENAME" or "sudo taill -f /path/to/filename/ ". On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu wrote: > -rw-r--r--   1 root    wheel  17987 Dec 17 09:01 COPYI

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING -rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY -rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data drwxr-xr-x 4

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Larry Martell
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu wrote: > Thanks Larry and Darryle for your help > > Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html > > On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell > wrote: >> >> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
Thanks Larry and Darryle for your help Where the error log should be? On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell wrote: > On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote: > > Yes, there is an icon. I can open the preference but the start service > > button cannot do the job > > What is in t

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Larry Martell
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote: > Yes, there is an icon. I can open the preference but the start service > button cannot do the job What is in the mysql error log? > > On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight > wrote: > >> Do you see a MySql icon under  System Prefer

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Darryle Steplight
I have version 5.5.17 MySQL Community Server (GPL) on my Mac. On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu wrote: > The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* > mac at mysql.com) > > On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote: > >> *I downloaded **Mac OS X ver.

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
Yes, there is an icon. I can open the preference but the start service button cannot do the job On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight wrote: > Do you see a MySql icon under System Preferences > Other ? That's how > I start MySql on my Mac. > > ** > > > >

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Elim Qiu
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* mac at mysql.com) On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote: > *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed > to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started > apach

Re: mysql for os x 10.6 (64bit) cannot start service

2012-02-29 Thread Darryle Steplight
Do you see a MySql icon under System Preferences > Other ? That's how I start MySql on my Mac. On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu wrote: > *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to > my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apac