max allowed packets on Mac

Hi,

I found this page on the wiki regarding max allowed packets.
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html


However, on my Mac OSX when I try to run the following from terminal window
I get "Permission Denied"

shell> mysqld --max_allowed_packet=16M

And if I try to run as sudo but I again get "Permission Denied" even though
I am logged in as Admin on my machine.

So I tried to chmod 777 on mysqld but again received an error:

"chmod: Unable to change file mode on mysqld: Operation not permitted"

Any help on how I can rectify this would be appreciated.

Thanks,
Greg


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: max allowed packets on Mac

I'm not nuts about deploying MySQL on macs, but I think you need to
assume root. As your mac admin user, try
$ sudo su -
and give your admin password when asked. You should now be root and
can expect permissions to behave as you would expect.

- michael dykman

On Fri, Dec 17, 2010 at 12:16 PM, greg@noiseunit.com w=
rote:
> Hi,
>
> I found this page on the wiki regarding max allowed packets.
> http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
>
>
> However, on my Mac OSX when I try to run the following from terminal wind=
ow
> I get "Permission Denied"
>
> shell> mysqld --max_allowed_packet=3D16M
>
> And if I try to run as sudo but I again get "Permission Denied" even thou=
gh
> I am logged in as Admin on my machine.
>
> So I tried to chmod 777 on mysqld but again received an error:
>
> "chmod: Unable to change file mode on mysqld: Operation not permitted"
>
> Any help on how I can rectify this would be appreciated.
>
> Thanks,
> Greg
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: max allowed packets on Mac

--20cf3054a7cf9db8fe0497e85e68
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I agree with michael dykman.
杨涛
我博å®=A21:http://yueliangdao0608.cublog.c n
My 我博å®=A22:http://yueliangdao0608.blog.51c to.com


2010/12/18 Michael Dykman

> I'm not nuts about deploying MySQL on macs, but I think you need to
> assume root. As your mac admin user, try
> $ sudo su -
> and give your admin password when asked. You should now be root and
> can expect permissions to behave as you would expect.
>
> - michael dykman
>
> On Fri, Dec 17, 2010 at 12:16 PM, greg@noiseunit.com
> wrote:
> > Hi,
> >
> > I found this page on the wiki regarding max allowed packets.
> > http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
> >
> >
> > However, on my Mac OSX when I try to run the following from terminal
> window
> > I get "Permission Denied"
> >
> > shell> mysqld --max_allowed_packet=3D16M
> >
> > And if I try to run as sudo but I again get "Permission Denied" even
> though
> > I am logged in as Admin on my machine.
> >
> > So I tried to chmod 777 on mysqld but again received an error:
> >
> > "chmod: Unable to change file mode on mysqld: Operation not permitted"
> >
> > Any help on how I can rectify this would be appreciated.
> >
> > Thanks,
> > Greg
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail.c=
om
> >
> >
>
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Dyueliangdao0608@gmail.c om
>
>

--20cf3054a7cf9db8fe0497e85e68--

Re: max allowed packets on Mac

5L2g5Ye6546w55qE5aSq6aKR57mB5LqG77yM5YWE5byfCgpZb3UgcG9zdCB0 b28gZnJlcXVlbnRs
eSBpbiB0aGUgbGlzdC4gCgrmnajmtpvmtpsgPGRhdmlkLnlhbmdAYWN0aW9u c2t5LmNvbT7nvJbl
hpnvvJoKCj5JIGFncmVlIHdpdGggbWljaGFlbCBkeWttYW4uCj7mnajmtpsK PuaIkeWNmuWuojE6
aHR0cDovL3l1ZWxpYW5nZGFvMDYwOC5jdWJsb2cuY24KPk15IOaIkeWNmuWu ojI6aHR0cDovL3l1
ZWxpYW5nZGFvMDYwOC5ibG9nLjUxY3RvLmNvbQo+Cj4KPjIwMTAvMTIvMTgg TWljaGFlbCBEeWtt
YW4gPG1keWttYW5AZ21haWwuY29tPgo+Cj4+IEknbSBub3QgbnV0cyBhYm91 dCBkZXBsb3lpbmcg
TXlTUUwgb24gbWFjcywgYnV0IEkgdGhpbmsgeW91IG5lZWQgdG8KPj4gYXNz dW1lIHJvb3QuICBB
cyB5b3VyIG1hYyBhZG1pbiB1c2VyLCB0cnkKPj4gJCBzdWRvIHN1IC0KPj4g YW5kIGdpdmUgeW91
ciBhZG1pbiBwYXNzd29yZCB3aGVuIGFza2VkLiAgWW91IHNob3VsZCBub3cg YmUgcm9vdCBhbmQK
Pj4gY2FuIGV4cGVjdCBwZXJtaXNzaW9ucyB0byBiZWhhdmUgYXMgeW91IHdv dWxkIGV4cGVjdC4K
Pj4KPj4gIC0gbWljaGFlbCBkeWttYW4KPj4KPj4gT24gRnJpLCBEZWMgMTcs IDIwMTAgYXQgMTI6
MTYgUE0sIGdyZWdAbm9pc2V1bml0LmNvbSA8Z3JlZ0Bub2lzZXVuaXQuY29t Pgo+PiB3cm90ZToK
Pj4gPiBIaSwKPj4gPgo+PiA+IEkgZm91bmQgdGhpcyBwYWdlIG9uIHRoZSB3 aWtpIHJlZ2FyZGlu
ZyBtYXggYWxsb3dlZCBwYWNrZXRzLgo+PiA+IGh0dHA6Ly9kZXYubXlzcWwu Y29tL2RvYy9yZWZt
YW4vNS4wL2VuL3BhY2tldC10b28tbGFyZ2UuaHRtbAo+PiA+Cj4+ID4KPj4g PiBIb3dldmVyLCBv
biBteSBNYWMgT1NYIHdoZW4gSSB0cnkgdG8gcnVuIHRoZSBmb2xsb3dpbmcg ZnJvbSB0ZXJtaW5h
bAo+PiB3aW5kb3cKPj4gPiBJIGdldCAiUGVybWlzc2lvbiBEZW5pZWQiCj4+ ID4KPj4gPiBzaGVs
bD4gbXlzcWxkIC0tbWF4X2FsbG93ZWRfcGFja2V0PTE2TQo+PiA+Cj4+ID4g QW5kIGlmIEkgdHJ5
IHRvIHJ1biBhcyBzdWRvIGJ1dCBJIGFnYWluIGdldCAiUGVybWlzc2lvbiBE ZW5pZWQiIGV2ZW4K
Pj4gdGhvdWdoCj4+ID4gSSBhbSBsb2dnZWQgaW4gYXMgQWRtaW4gb24gbXkg bWFjaGluZS4KPj4g
Pgo+PiA+IFNvIEkgdHJpZWQgdG8gY2htb2QgNzc3IG9uIG15c3FsZCBidXQg YWdhaW4gcmVjZWl2
ZWQgYW4gZXJyb3I6Cj4+ID4KPj4gPiAiY2htb2Q6IFVuYWJsZSB0byBjaGFu Z2UgZmlsZSBtb2Rl
IG9uIG15c3FsZDogT3BlcmF0aW9uIG5vdCBwZXJtaXR0ZWQiCj4+ID4KPj4g PiBBbnkgaGVscCBv
biBob3cgSSBjYW4gcmVjdGlmeSB0aGlzIHdvdWxkIGJlIGFwcHJlY2lhdGVk Lgo+PiA+Cj4+ID4g
VGhhbmtzLAo+PiA+IEdyZWcKPj4gPgo+PiA+Cj4+ID4gLS0KPj4gPiBNeVNR TCBHZW5lcmFsIE1h
aWxpbmcgTGlzdAo+PiA+IEZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlz dHMubXlzcWwuY29t
L215c3FsCj4+ID4gVG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5t eXNxbC5jb20vbXlz
cWw/dW5zdWI9bWR5a21hbkBnbWFpbC5jb20KPj4gPgo+PiA+Cj4+Cj4+Cj4+ Cj4+IC0tCj4+ICAt
IG1pY2hhZWwgZHlrbWFuCj4+ICAtIG1keWttYW5AZ21haWwuY29tCj4+Cj4+ ICBNYXkgdGhlIFNv
dXJjZSBiZSB3aXRoIHlvdS4KPj4KPj4gLS0KPj4gTXlTUUwgR2VuZXJhbCBN YWlsaW5nIExpc3QK
Pj4gRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20v bXlzcWwKPj4gVG8g
dW5zdWJzY3JpYmU6Cj4+IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWw/ dW5zdWI9eXVlbGlh
bmdkYW8wNjA4QGdtYWlsLmNvbQo+Pgo+Pgo=