Bug #31889 Cannot start MySQL from System Preferences
| Submitted: | 26 Oct 2007 18:57 | Modified: | 14 Mar 2008 18:31 |
|---|---|---|---|
| Reporter: | Matthew Brady | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL GUI Common | Severity: | S2 (Serious) |
| Version: | 5.0.41 | OS: | MacOS (10.5) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | 10.5, leopard, system preferences | ||
[26 Oct 2007 18:57]
Matthew Brady
[27 Oct 2007 7:22]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.45, and inform about the results.
[27 Oct 2007 19:28]
James White
I have the exact same issue on OSX Leopard (10.5) using MySQL 5.0.45.
[27 Oct 2007 20:12]
James White
I can confirm that MySQL will start from the command line using: sudo /usr/local/mysql/bin/mysqld_safe --user=mysql & But the service will not start from the applet in System Preferences.
[28 Oct 2007 14:18]
wild palms
Its far worse on PPC running Leopard. I've tried 5.0.41 and 5.1.x - whether .tar or package, each is failing. Permissions are not being set correctly and getting mysqld running is a real joyride of pain. After 2 reinstalls of Leopard and around 11 installs of mysql i am forced to roll back to another machine as running mysql on Leopard on PPC can NOT be considered ready at this point in time.
[28 Oct 2007 14:23]
wild palms
Seems like there is more fun.... MySQL tools are flakey on Leopard, particularly with InnoDB editing and table manipulation. This caused the MySQL admin tools to crash.
[28 Oct 2007 16:14]
Nick Trew
Is this perhaps because Leopard uses "_mysql" as the user, and the Preference Pane is using "mysql"?
[29 Oct 2007 20:16]
Andrew Hanna
For the sake of convenience, one can add these two lines to ~/.profile to more easily start/stop MySQL until this bug is fixed. alias start_mysql='sudo /usr/local/mysql/bin/mysqld_safe &' alias stop_mysql='mysqladmin shutdown -uroot -p' Start requires sudo password, stop requires root mysql password.
[29 Oct 2007 20:18]
Andrew Hanna
Sorry, forgot to quickly mention how to use the above lines (for those who might not know). Just open Terminal and type: % stop_mysql Enter password: (Enter your MySQL Root password here) % start_mysql Enter password: (Enter your OS X password here, you must be an Administrator)
[7 Nov 2007 0:29]
Andrew Otto
"Is this perhaps because Leopard uses "_mysql" as the user, and the Preference Pane is using "mysql"?" No, I don't think so, but it is something related. Starting mysqld from the command line fails also: $ mysqld 071106 18:29:15 [Warning] Can't create test file /usr/local/mysql-5.0.41-osx10.4-i686/data/qubit.lower-test 071106 18:29:15 [Warning] Can't create test file /usr/local/mysql-5.0.41-osx10.4-i686/data/qubit.lower-test 071106 18:29:15 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation.
[7 Nov 2007 0:44]
Andrew Otto
Also, the same thing happens for 5.0.45... $ mysqld 071106 18:38:44 [Warning] Can't create test file /usr/local/mysql-5.0.45-osx10.4-i686/data/qubit.lower-test 071106 18:38:44 [Warning] Can't create test file /usr/local/mysql-5.0.45-osx10.4-i686/data/qubit.lower-test mysqld: Can't change dir to '/usr/local/mysql-5.0.45-osx10.4-i686/data/' (Errcode: 13) 071106 18:38:44 [ERROR] Aborting 071106 18:38:44 [Note] mysqld: Shutdown complete
[10 Nov 2007 12:35]
Adam Penny
If you look at the _mysql user and group with dscl, they have 2 values for RecordName: _mysql and mysql. I deleted the RecordName _mysql on each and did sudo chown -R mysql /usr/local/mysql/data and automatic startup in the preference pane now works, although the start/stop button still doesn't work.
[11 Nov 2007 17:32]
Joannou Ng
Instead of manually starting MySQL between reboots, use launchd, as outlined here: http://blog.tomatocheese.com/archives/2007/11/1/migrating_mysql_to_mac_os_x_leopard/
[28 Nov 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[29 Jan 2008 20:35]
Nikos Dimitrakopoulos
Any news on this one?
[14 Mar 2008 18:31]
Sveta Smirnova
Thank you for the report and feedback. I'll mark this as duplicate of bug #25008 and 28854 which are fixed and will be available in next release.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.046 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.