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

2012-02-29 Thread Elim Qiu
*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 apache. The installation went smoothly but the service just cannot be started.* **

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 elim@gmail.com 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

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 elim@gmail.com 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

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 dstepli...@gmail.com 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 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 elim@gmail.com 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 elim@gmail.com wrote:

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 elim@gmail.com 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 dstepli...@gmail.com wrote: Do you see a

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 larry.mart...@gmail.comwrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service

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 elim@gmail.com 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 larry.mart...@gmail.com wrote: On Wed, Feb 29,

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 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 elim@gmail.com wrote: -rw-r--r--   1 root    wheel  17987 Dec

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 elim@gmail.com 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

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 h.rei...@thelounge.net wrote: Am 29.02.2012 19:20, schrieb Larry Martell: Is the sudo succeeding? If it is, then there's no reason you

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

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 elim@gmail.com wrote: I created (or activated) the root account and

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 elim@gmail.com 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]