cannot find my.cnf file

Hello,=0AI want to log all sql queries made against a mysql db.=0AGoogled a=
nd found I should add a line to my.cnf. However I cannot find a my.cnf=
file=0A[root@radium init.d]# ps -ef | grep mysql=0Aroot 13614 1 0=
Sep24 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=3D/var/lib/=
mysql --pid-file=3D/var/lib/mysql/object01.pid=0Amysql 13669 13614 0 Se=
p24 ? 00:21:40 /usr/sbin/mysqld --basedir=3D/ --datadir=3D/var/lib/m=
ysql --user=3Dmysql --log-error=3D/var/lib/mysql/object01.err --pid-file=3D=
/var/lib/mysql/object01.pid=0Aroot 23050 22746 0 19:05 pts/0 00:00:=
00 grep mysql=0A[root@radium init.d]# locate cnf=0A/usr/share/doc/MySQL-ser=
ver-community-5.1.39/my-huge.cnf=0A/usr/share/doc/MySQL-serv er-community-5.=
1.39/my-innodb-heavy-4G.cnf=0A/usr/share/doc/MySQL-server-co mmunity-5.1.39/=
my-large.cnf=0A/usr/share/doc/MySQL-server-community-5.1.39/ my-medium.cnf=
=0A/usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf =0A/usr/share/m=
an/man8/cnfsheadconf.8.gz=0A/usr/share/man/man8/cnfsstat.8.g z=0A/usr/share/=
ssl/openssl.cnf=0A/usr/share/mysql/my-large.cnf=0A/usr/share /mysql/my-huge.=
cnf=0A/usr/share/mysql/my-innodb-heavy-4G.cnf=0A/usr/share/m ysql/my-medium.=
cnf=0A/usr/share/mysql/my-small.cnf=0AAny ideas?=0AI might add i did not in=
stall mysql and I did not start it and the guy who did is in holiday! =
TIA Syd

--
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: cannot find my.cnf file

should be in

/etc/my.cnf

or try the following at the command line

locate my.cnf

That should give you the location


On Thu, 2009-11-12 at 18:10 +0000, Sydney Puente wrote:
> Hello,
> I want to log all sql queries made against a mysql db.
> Googled and found I should add a line to my.cnf.
>
> However I cannot find a my.cnf file
> [root@radium init.d]# ps -ef | grep mysql
> root 13614 1 0 Sep24 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid
> mysql 13669 13614 0 Sep24 ? 00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid
> root 23050 22746 0 19:05 pts/0 00:00:00 grep mysql
> [root@radium init.d]# locate cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy -4G.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf
> /usr/share/man/man8/cnfsheadconf.8.gz
> /usr/share/man/man8/cnfsstat.8.gz
> /usr/share/ssl/openssl.cnf
> /usr/share/mysql/my-large.cnf
> /usr/share/mysql/my-huge.cnf
> /usr/share/mysql/my-innodb-heavy-4G.cnf
> /usr/share/mysql/my-medium.cnf
> /usr/share/mysql/my-small.cnf
> Any ideas?
> I might add i did not install mysql and I did not start it and the guy who did is in holiday!
>
> TIA
>
> Syd
>
>
>
>
>


--
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: cannot find my.cnf file

Also note that mysql doesn't need a my.cnf file and will happily run with d=
efault values. It's possible that there is none and you'll have to create =
it.

To see where your mysqld is configured to check for the config file do:
mysql --verbose --help | grep -C3 my.cnf

This will give you a list of paths it checks in order.

Regards,
Gavin Towey

-----Original Message-----
From: John Daisley [mailto:john.daisley@butterflysystems.co.uk]
Sent: Thursday, November 12, 2009 10:30 AM
To: Sydney Puente
Cc: mysql@lists.mysql.com
Subject: Re: cannot find my.cnf file

should be in

/etc/my.cnf

or try the following at the command line

locate my.cnf

That should give you the location


On Thu, 2009-11-12 at 18:10 +0000, Sydney Puente wrote:
> Hello,
> I want to log all sql queries made against a mysql db.
> Googled and found I should add a line to my.cnf.
>
> However I cannot find a my.cnf file
> [root@radium init.d]# ps -ef | grep mysql
> root 13614 1 0 Sep24 ? 00:00:00 /bin/sh /usr/bin/mysqld_s=
afe --datadir=3D/var/lib/mysql --pid-file=3D/var/lib/mysql/object01.pid
> mysql 13669 13614 0 Sep24 ? 00:21:40 /usr/sbin/mysqld --basedi=
r=3D/ --datadir=3D/var/lib/mysql --user=3Dmysql --log-error=3D/var/lib/mysq=
l/object01.err --pid-file=3D/var/lib/mysql/object01.pid
> root 23050 22746 0 19:05 pts/0 00:00:00 grep mysql
> [root@radium init.d]# locate cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy -4G.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf
> /usr/share/man/man8/cnfsheadconf.8.gz
> /usr/share/man/man8/cnfsstat.8.gz
> /usr/share/ssl/openssl.cnf
> /usr/share/mysql/my-large.cnf
> /usr/share/mysql/my-huge.cnf
> /usr/share/mysql/my-innodb-heavy-4G.cnf
> /usr/share/mysql/my-medium.cnf
> /usr/share/mysql/my-small.cnf
> Any ideas?
> I might add i did not install mysql and I did not start it and the guy wh=
o did is in holiday!
>
> TIA
>
> Syd
>
>
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
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: cannot find my.cnf file

WW91IG11c3QgY29weSAvdXNyL3NoYXJlL2RvYy9NeVNRTC1zZXJ2ZXItY29t bXVuaXR5LTUuMS4z
OS9teS1zb21lZmlsZS5jbmYNCmZpbGUgaW50byAvZXRjL215LmNuZg0KDQpJ ZiBubyAuY25mIGZp
bGUgaW4gL2V0Yw0KTXlTUUwgdXNlIGRlZmF1bHQgY29uZmlnLg0KDQppZiBz ZXJ2ZXIgaGFzIDJH
IFJBTSANCnRoZW4gdXNlIG15LWh1Z2UuY25mDQoNCkdvb2QgbHVjay4NCg0K LS0tLS0gT3JpZ2lu
YWwgTWVzc2FnZSAtLS0tLSANCkZyb206ICJTeWRuZXkgUHVlbnRlIiA8c3lk bmV5cHVlbnRlQHlh
aG9vLmNvbT4NClRvOiA8bXlzcWxAbGlzdHMubXlzcWwuY29tPg0KU2VudDog RnJpZGF5LCBOb3Zl
bWJlciAxMywgMjAwOSAzOjEwIEFNDQpTdWJqZWN0OiBjYW5ub3QgZmluZCBt eS5jbmYgZmlsZQ0K
DQoNCj4gSGVsbG8sDQo+IEkgd2FudCB0byBsb2cgYWxsIHNxbCBxdWVyaWVz IG1hZGUgYWdhaW5z
dCBhIG15c3FsIGRiLg0KPiBHb29nbGVkIGFuZCBmb3VuZCBJIHNob3VsZCBh ZGQgYSBsaW5lIHRv
IG15LmNuZi4NCj4gDQo+IEhvd2V2ZXIgSSBjYW5ub3QgZmluZCBhIG15LmNu ZiBmaWxlDQo+IFty
b290QHJhZGl1bSBpbml0LmRdIyBwcyAtZWYgfCBncmVwIG15c3FsDQo+IHJv b3QgICAgIDEzNjE0
ICAgICAxICAwIFNlcDI0ID8gICAgICAgIDAwOjAwOjAwIC9iaW4vc2ggL3Vz ci9iaW4vbXlzcWxk
X3NhZmUgLS1kYXRhZGlyPS92YXIvbGliL215c3FsIC0tcGlkLWZpbGU9L3Zh ci9saWIvbXlzcWwv
b2JqZWN0MDEucGlkDQo+IG15c3FsICAgIDEzNjY5IDEzNjE0ICAwIFNlcDI0 ID8gICAgICAgIDAw
OjIxOjQwIC91c3Ivc2Jpbi9teXNxbGQgLS1iYXNlZGlyPS8gLS1kYXRhZGly PS92YXIvbGliL215
c3FsIC0tdXNlcj1teXNxbCAtLWxvZy1lcnJvcj0vdmFyL2xpYi9teXNxbC9v YmplY3QwMS5lcnIg
LS1waWQtZmlsZT0vdmFyL2xpYi9teXNxbC9vYmplY3QwMS5waWQNCj4gcm9v dCAgICAgMjMwNTAg
MjI3NDYgIDAgMTk6MDUgcHRzLzAgICAgMDA6MDA6MDAgZ3JlcCBteXNxbA0K PiBbcm9vdEByYWRp
dW0gaW5pdC5kXSMgbG9jYXRlIGNuZg0KPiAvdXNyL3NoYXJlL2RvYy9NeVNR TC1zZXJ2ZXItY29t
bXVuaXR5LTUuMS4zOS9teS1odWdlLmNuZg0KPiAvdXNyL3NoYXJlL2RvYy9N eVNRTC1zZXJ2ZXIt
Y29tbXVuaXR5LTUuMS4zOS9teS1pbm5vZGItaGVhdnktNEcuY25mDQo+IC91 c3Ivc2hhcmUvZG9j
L015U1FMLXNlcnZlci1jb21tdW5pdHktNS4xLjM5L215LWxhcmdlLmNuZg0K PiAvdXNyL3NoYXJl
L2RvYy9NeVNRTC1zZXJ2ZXItY29tbXVuaXR5LTUuMS4zOS9teS1tZWRpdW0u Y25mDQo+IC91c3Iv
c2hhcmUvZG9jL015U1FMLXNlcnZlci1jb21tdW5pdHktNS4xLjM5L215LXNt YWxsLmNuZg0KPiAv
dXNyL3NoYXJlL21hbi9tYW44L2NuZnNoZWFkY29uZi44Lmd6DQo+IC91c3Iv c2hhcmUvbWFuL21h
bjgvY25mc3N0YXQuOC5neg0KPiAvdXNyL3NoYXJlL3NzbC9vcGVuc3NsLmNu Zg0KPiAvdXNyL3No
YXJlL215c3FsL215LWxhcmdlLmNuZg0KPiAvdXNyL3NoYXJlL215c3FsL215 LWh1Z2UuY25mDQo+
IC91c3Ivc2hhcmUvbXlzcWwvbXktaW5ub2RiLWhlYXZ5LTRHLmNuZg0KPiAv dXNyL3NoYXJlL215
c3FsL215LW1lZGl1bS5jbmYNCj4gL3Vzci9zaGFyZS9teXNxbC9teS1zbWFs bC5jbmYNCj4gQW55
IGlkZWFzPw0KPiBJIG1pZ2h0IGFkZCBpIGRpZCBub3QgaW5zdGFsbCBteXNx bCBhbmQgSSBkaWQg
bm90IHN0YXJ0IGl0IGFuZCB0aGUgZ3V5IHdobyBkaWQgaXMgaW4gaG9saWRh eSENCj4gDQo+IFRJ
QQ0KPiANCj4gU3lkDQo+IA0KPiANCj4gDQo+ICAgICAgIA0KPiANCj4gLS0g DQo+IE15U1FMIEdl
bmVyYWwgTWFpbGluZyBMaXN0DQo+IEZvciBsaXN0IGFyY2hpdmVzOiBodHRw Oi8vbGlzdHMubXlz
cWwuY29tL215c3FsDQo+IFRvIHVuc3Vic2NyaWJlOiAgICBodHRwOi8vbGlz dHMubXlzcWwuY29t
L215c3FsP3Vuc3ViPW9sZGJveUBwb3NiYW5rLmNvLmtyDQo+IA0KPiA=

Re: cannot find my.cnf file

Sydney Puente schrieb:
> Hello,
> I want to log all sql queries made against a mysql db.
> Googled and found I should add a line to my.cnf.
>
> However I cannot find a my.cnf file
> [root@radium init.d]# ps -ef | grep mysql
> root 13614 1 0 Sep24 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid
> mysql 13669 13614 0 Sep24 ? 00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid
> root 23050 22746 0 19:05 pts/0 00:00:00 grep mysql
> [root@radium init.d]# locate cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy -4G.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf
> /usr/share/man/man8/cnfsheadconf.8.gz
> /usr/share/man/man8/cnfsstat.8.gz
> /usr/share/ssl/openssl.cnf
> /usr/share/mysql/my-large.cnf
> /usr/share/mysql/my-huge.cnf
> /usr/share/mysql/my-innodb-heavy-4G.cnf
> /usr/share/mysql/my-medium.cnf
> /usr/share/mysql/my-small.cnf
> Any ideas?
> I might add i did not install mysql and I did not start it and the guy who did is in holiday!
>

Systemwide config files are always in /etc/ (see: man hier).

re,
wh




--
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: cannot find my.cnf file

UGxlYXNlIGxvb2sgaW4gL2V0Yy9teS5jbmYgDQpJZiBub3QgZm91bmQgY3Jl YXRlIG9uZS4gT2Yg
Y2F1c2UsIE15U1FMIGNhbiBzdGFydCBhbmQgcnVuIHdpdGhvdXQgYSAnbXku Y25mJyBmaWxlIHRo
YXTigJlzIHdoeSB5b3UgY291bGRuJ3QgIGZpbmQgb25lLiAgSW4gdGhlIGFi c2VuY2Ugb2YgdGhl
IG15LmNuZiBmaWxlLCBNeVNRTCB3aWxsIHVzZSBkZWZhdWx0IGZvciBldmVy eSBwYXJhbWV0ZXIg
Lg0KDQpDaGFybGVzLA0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t LS0NCkZyb206IHdh
bHRlciBoYXJtcyBbbWFpbHRvOndoYXJtc0BiZnMuZGVdIA0KU2VudDogRnJp ZGF5LCBOb3ZlbWJl
ciAxMywgMjAwOSAyOjQ0IEFNDQpUbzogU3lkbmV5IFB1ZW50ZQ0KQ2M6IG15 c3FsQGxpc3RzLm15
c3FsLmNvbQ0KU3ViamVjdDogUmU6IGNhbm5vdCBmaW5kIG15LmNuZiBmaWxl DQoNCg0KDQpTeWRu
ZXkgUHVlbnRlIHNjaHJpZWI6DQo+IEhlbGxvLA0KPiBJIHdhbnQgdG8gbG9n IGFsbCBzcWwgcXVl
cmllcyBtYWRlIGFnYWluc3QgYSBteXNxbCBkYi4NCj4gR29vZ2xlZCBhbmQg Zm91bmQgSSBzaG91
bGQgYWRkIGEgbGluZSB0byBteS5jbmYuDQo+IA0KPiBIb3dldmVyIEkgY2Fu bm90IGZpbmQgYSBt
eS5jbmYgZmlsZQ0KPiBbcm9vdEByYWRpdW0gaW5pdC5kXSMgcHMgLWVmIHwg Z3JlcCBteXNxbA0K
PiByb290ICAgICAxMzYxNCAgICAgMSAgMCBTZXAyNCA/ICAgICAgICAwMDow MDowMCAvYmluL3No
IC91c3IvYmluL215c3FsZF9zYWZlIC0tZGF0YWRpcj0vdmFyL2xpYi9teXNx bCAtLXBpZC1maWxl
PS92YXIvbGliL215c3FsL29iamVjdDAxLnBpZA0KPiBteXNxbCAgICAxMzY2 OSAxMzYxNCAgMCBT
ZXAyNCA/ICAgICAgICAwMDoyMTo0MCAvdXNyL3NiaW4vbXlzcWxkIC0tYmFz ZWRpcj0vIC0tZGF0
YWRpcj0vdmFyL2xpYi9teXNxbCAtLXVzZXI9bXlzcWwgLS1sb2ctZXJyb3I9 L3Zhci9saWIvbXlz
cWwvb2JqZWN0MDEuZXJyIC0tcGlkLWZpbGU9L3Zhci9saWIvbXlzcWwvb2Jq ZWN0MDEucGlkDQo+
IHJvb3QgICAgIDIzMDUwIDIyNzQ2ICAwIDE5OjA1IHB0cy8wICAgIDAwOjAw OjAwIGdyZXAgbXlz
cWwNCj4gW3Jvb3RAcmFkaXVtIGluaXQuZF0jIGxvY2F0ZSBjbmYNCj4gL3Vz ci9zaGFyZS9kb2Mv
TXlTUUwtc2VydmVyLWNvbW11bml0eS01LjEuMzkvbXktaHVnZS5jbmYNCj4g L3Vzci9zaGFyZS9k
b2MvTXlTUUwtc2VydmVyLWNvbW11bml0eS01LjEuMzkvbXktaW5ub2RiLWhl YXZ5LTRHLmNuZg0K
PiAvdXNyL3NoYXJlL2RvYy9NeVNRTC1zZXJ2ZXItY29tbXVuaXR5LTUuMS4z OS9teS1sYXJnZS5j
bmYNCj4gL3Vzci9zaGFyZS9kb2MvTXlTUUwtc2VydmVyLWNvbW11bml0eS01 LjEuMzkvbXktbWVk
aXVtLmNuZg0KPiAvdXNyL3NoYXJlL2RvYy9NeVNRTC1zZXJ2ZXItY29tbXVu aXR5LTUuMS4zOS9t
eS1zbWFsbC5jbmYNCj4gL3Vzci9zaGFyZS9tYW4vbWFuOC9jbmZzaGVhZGNv bmYuOC5neg0KPiAv
dXNyL3NoYXJlL21hbi9tYW44L2NuZnNzdGF0LjguZ3oNCj4gL3Vzci9zaGFy ZS9zc2wvb3BlbnNz
bC5jbmYNCj4gL3Vzci9zaGFyZS9teXNxbC9teS1sYXJnZS5jbmYNCj4gL3Vz ci9zaGFyZS9teXNx
bC9teS1odWdlLmNuZg0KPiAvdXNyL3NoYXJlL215c3FsL215LWlubm9kYi1o ZWF2eS00Ry5jbmYN
Cj4gL3Vzci9zaGFyZS9teXNxbC9teS1tZWRpdW0uY25mDQo+IC91c3Ivc2hh cmUvbXlzcWwvbXkt
c21hbGwuY25mDQo+IEFueSBpZGVhcz8NCj4gSSBtaWdodCBhZGQgaSBkaWQg bm90IGluc3RhbGwg
bXlzcWwgYW5kIEkgZGlkIG5vdCBzdGFydCBpdCBhbmQgdGhlIGd1eSB3aG8g ZGlkIGlzIGluIGhv
bGlkYXkhDQo+IA0KDQpTeXN0ZW13aWRlIGNvbmZpZyBmaWxlcyBhcmUgYWx3 YXlzIGluIC9ldGMv
IChzZWU6IG1hbiBoaWVyKS4NCg0KcmUsDQogd2gNCg0KDQoNCg0KLS0gDQpN eVNRTCBHZW5lcmFs
IE1haWxpbmcgTGlzdA0KRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0 cy5teXNxbC5jb20v
bXlzcWwNClRvIHVuc3Vic2NyaWJlOiAgICBodHRwOi8vbGlzdHMubXlzcWwu Y29tL215c3FsP3Vu
c3ViPWNicm93bkBibWkuY29tDQoNCg0KKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqKioqKioqKioNClRoaXMgbWVzc2FnZSBpcyBpbnRlbmRlZCBvbmx5IGZv ciB0aGUgdXNlIG9m
IHRoZSBBZGRyZXNzZWUgYW5kDQptYXkgY29udGFpbiBpbmZvcm1hdGlvbiB0 aGF0IGlzIFBSSVZJ
TEVHRUQgYW5kIENPTkZJREVOVElBTC4NCg0KSWYgeW91IGFyZSBub3QgdGhl IGludGVuZGVkIHJl
Y2lwaWVudCwgeW91IGFyZSBoZXJlYnkgbm90aWZpZWQNCnRoYXQgYW55IGRp c3NlbWluYXRpb24g
b2YgdGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQu DQoNCklmIHlvdSBo
YXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxl YXNlIGVyYXNlDQph
bGwgY29waWVzIG9mIHRoZSBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMg YW5kIG5vdGlmeSB1
cw0KaW1tZWRpYXRlbHkuDQoNClRoYW5rIHlvdS4NCioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqDQo=

Re: cannot find my.cnf file

Yes I enter the password manually into the remote mysql client (actually Or=
acle's SQL developer) when I login. I thought I would restart mysql wi=
th the /etc/init.d/mysql script and go back to the original "default" setti=
ngs without any my.cnf present. Just to check it was some setting in my.cnf=
that caused the log in problem. # ./mysql status=0AMySQL is running b=
ut PID file could not be found [FAILED]=0A# ./mysql stop=0AMySQL =
manager or server PID file could not be found! [FAILED] In fact =
I cannot find a pid file anywhere on the box.=0A# ps -ef | grep mysql=0Aroo=
t 6517 1 0 10:10 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe -=
-datadir=3D/var/lib/mysql --pid-file=3D/var/lib/mysql/radium01.pid=0Amysql =
6623 6517 0 10:10 pts/0 00:00:24 /usr/sbin/mysqld --basedir=3D/ --=
datadir=3D/var/lib/mysql --user=3Dmysql --log-error=3D/var/lib/mysql/object=
01.err --pid-file=3D/var/lib/mysql/object01.pid --socket=3D/var/lib/mysql/m=
ysql.sock --port=3D3306=0A# locate pid | grep mysql=0A/usr/share/man/man1/m=
ysql_waitpid.1.gz=0A/usr/bin/mysql_waitpid I have no idea why a pid fi=
le would be missing! any ideas Syd =0A

--
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: cannot find my.cnf file

RGlkIHlvdSByZW1vdmUgdGhlIG15LmNuZiBmaWxlIGFuZCB0aGVuIHJ1biAv ZXRjL2luaXQuZC9t
eXNxbCBzdG9wPyAgVGhlIG15LmNuZiBwcm9iYWJseSBoYWQgbm9uLWRlZmF1 bHQgcGF0aHMgZm9y
IHRoZSBwaWQgZmlsZSwgc28gaWYgeW91IHJlbW92ZSB0aGUgY29uZmlnIGZp bGUsIG5vdyB0aGUg
c3RhcnR1cCBzY3JpcHQgaXMgbG9va2luZyBpbiB0aGUgd3JvbmcgbG9jYXRp b24uDQoNCg0KQWxz
byBmb3IgeW91ciBwYXNzd29yZCBpc3N1ZSwgcGxlYXNlIHNob3cgdXNlIHRo ZSBleGFjdCBjb21t
YW5kIHlvdSdyZSB1c2luZyB0byB0cnkgdG8gbG9nIGluLCBhbmQgdGhlIGV4 YWN0IGVycm9yIG1l
c3NhZ2UgeW91IGdldC4NCg0KUmVnYXJkcw0KR2F2aW4gVG93ZXkNCg0KLS0t LS1PcmlnaW5hbCBN
ZXNzYWdlLS0tLS0NCkZyb206IFN5ZG5leSBQdWVudGUgW21haWx0bzpzeWRu ZXlwdWVudGVAeWFo
b28uY29tXQ0KU2VudDogRnJpZGF5LCBOb3ZlbWJlciAxMywgMjAwOSA1OjMx IEFNDQpUbzogbXlz
cWxAbGlzdHMubXlzcWwuY29tDQpTdWJqZWN0OiBSZTogY2Fubm90IGZpbmQg bXkuY25mIGZpbGUN
Cg0KWWVzIEkgZW50ZXIgdGhlIHBhc3N3b3JkIG1hbnVhbGx5IGludG8gdGhl IHJlbW90ZSBteXNx
bCBjbGllbnQgKGFjdHVhbGx5IE9yYWNsZSdzIFNRTCBkZXZlbG9wZXIpIHdo ZW4gSSBsb2dpbi4N
Cg0KSSB0aG91Z2h0IEkgd291bGQgcmVzdGFydCBteXNxbCB3aXRoIHRoZSAv ZXRjL2luaXQuZC9t
eXNxbCBzY3JpcHQgYW5kIGdvIGJhY2sgdG8gdGhlIG9yaWdpbmFsICJkZWZh dWx0IiBzZXR0aW5n
cyB3aXRob3V0IGFueSBteS5jbmYgcHJlc2VudC4gSnVzdCB0byBjaGVjayBp dCB3YXMgc29tZSBz
ZXR0aW5nIGluIG15LmNuZiB0aGF0IGNhdXNlZCB0aGUgbG9nIGluIHByb2Js ZW0uDQoNCiMgLi9t
eXNxbCBzdGF0dXMNCk15U1FMIGlzIHJ1bm5pbmcgYnV0IFBJRCBmaWxlIGNv dWxkIG5vdCBiZSBm
b3VuZCAgICAgICAgICAgW0ZBSUxFRF0NCiMgLi9teXNxbCBzdG9wDQpNeVNR TCBtYW5hZ2VyIG9y
IHNlcnZlciBQSUQgZmlsZSBjb3VsZCBub3QgYmUgZm91bmQhICAgICAgIFtG QUlMRURdDQoNCklu
IGZhY3QgSSBjYW5ub3QgZmluZCBhIHBpZCBmaWxlIGFueXdoZXJlIG9uIHRo ZSBib3guDQojIHBz
IC1lZiB8IGdyZXAgbXlzcWwNCnJvb3QgICAgICA2NTE3ICAgICAxICAwIDEw OjEwIHB0cy8wICAg
IDAwOjAwOjAwIC9iaW4vc2ggL3Vzci9iaW4vbXlzcWxkX3NhZmUgLS1kYXRh ZGlyPS92YXIvbGli
L215c3FsIC0tcGlkLWZpbGU9L3Zhci9saWIvbXlzcWwvcmFkaXVtMDEucGlk DQpteXNxbCAgICAg
NjYyMyAgNjUxNyAgMCAxMDoxMCBwdHMvMCAgICAwMDowMDoyNCAvdXNyL3Ni aW4vbXlzcWxkIC0t
YmFzZWRpcj0vIC0tZGF0YWRpcj0vdmFyL2xpYi9teXNxbCAtLXVzZXI9bXlz cWwgLS1sb2ctZXJy
b3I9L3Zhci9saWIvbXlzcWwvb2JqZWN0MDEuZXJyIC0tcGlkLWZpbGU9L3Zh ci9saWIvbXlzcWwv
b2JqZWN0MDEucGlkIC0tc29ja2V0PS92YXIvbGliL215c3FsL215c3FsLnNv Y2sgLS1wb3J0PTMz
MDYNCiMgbG9jYXRlIHBpZCB8IGdyZXAgbXlzcWwNCi91c3Ivc2hhcmUvbWFu L21hbjEvbXlzcWxf
d2FpdHBpZC4xLmd6DQovdXNyL2Jpbi9teXNxbF93YWl0cGlkDQoNCkkgaGF2 ZSBubyBpZGVhIHdo
eSBhIHBpZCBmaWxlIHdvdWxkIGJlIG1pc3NpbmchDQoNCmFueSBpZGVhcw0K DQpTeWQNCg0KDQoN
Cg0KLS0NCk15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0DQpGb3IgbGlzdCBh cmNoaXZlczogaHR0
cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KVG8gdW5zdWJzY3JpYmU6ICAg IGh0dHA6Ly9saXN0
cy5teXNxbC5jb20vbXlzcWw/dW5zdWI9Z3Rvd2V5QGZmbi5jb20NCg0KDQpU aGUgaW5mb3JtYXRp
b24gY29udGFpbmVkIGluIHRoaXMgdHJhbnNtaXNzaW9uIG1heSBjb250YWlu IHByaXZpbGVnZWQg
YW5kIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbi4gSXQgaXMgaW50ZW5kZWQg b25seSBmb3IgdGhl
IHVzZSBvZiB0aGUgcGVyc29uKHMpIG5hbWVkIGFib3ZlLiBJZiB5b3UgYXJl IG5vdCB0aGUgaW50
ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0 IGFueSByZXZpZXcs
IGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiBvciBkdXBsaWNhdGlvbiBv ZiB0aGlzIGNvbW11
bmljYXRpb24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGFyZSBu b3QgdGhlIGludGVu
ZGVkIHJlY2lwaWVudCwgcGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBieSBy ZXBseSBlbWFpbCBh
bmQgZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmlnaW5hbCBtZXNzYWdl Lg0K