Bug #60578 | Running Mysql internally on Mac OSx 10.6.6,problems opening configuration. | ||
---|---|---|---|
Submitted: | 22 Mar 2011 7:45 | Modified: | 19 May 2011 14:27 |
Reporter: | John McBeath | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Workbench: Administration | Severity: | S3 (Non-critical) |
Version: | 5.5.10 | OS: | MacOS (Snow Leopard10.6.6) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Problems with configuration file. |
[22 Mar 2011 7:45]
John McBeath
[22 Mar 2011 8:18]
Valeriy Kravchuk
Looks like we need more details: 1. Where is my.cnf really located? Is it possible to start server from command line using this my.cnf? 2. How exactly you had created server instance in Workbench and what path to my.cnf you set there. 3. Why do you think there is a bug in Workbench in this case?
[22 Mar 2011 20:27]
John McBeath
Will get back to you once I have another look and see if I did something wrong. Used same file that I used for 5.1.50 and it is located in/etc/my.cnf Bug report was sent as WB showed message to send with info. Not yet using for real hence on internal. Studying at the moment and college don,t give admin or root rights to 1st yrs. Have it running now but took out my.cnf. Will try with one of new ones from 5.5.10.
[25 Mar 2011 9:28]
John McBeath
Solved problem with starting and stopping Mysql. Created new my.cnf in workbench but it would't save. For some reason when created it has the wrong permissions. Workbench set permissions as 444 (everyone read only) Whilst waiting to save file in workbench used terminal (shell) to change permissions to 644 now workbench can write to file and problem solved. Initially although creating my.cnf and putting file in /etc/ there was nothing in it. Can now swap between whatever I like, Workbench,Terminal, or PHP scripts. Don't know why Workbench makes cnf file with 444 permissions as it can't be written. Only reason I can think of is to save mistakingly updating. Just checked to see if permissions at 440 work and cnf used but can't be altered. So if need new cnf file have to start making file try to save, change permissions in terminal, let file be written, change permissions back in terminal, hey presto! Bit long winded but it works. P.S Now running Snow Leopard 10.6.7.
[19 Apr 2011 14:27]
MySQL Verification Team
So the issue was resolved?. Thanks in advance.
[19 May 2011 23: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".