Re: mysql port number
I use freeBSD and like to use "sockstat -4". It tells you the user, the command that is used and the PID, Protocol local address and the foreign address it is connected to. - Original Message - From: "Brian P. Austin" <[EMAIL PROTECTED]> To: "Mike At Spy" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 5:06 PM Subject: RE: mysql port number > show variables > that will show you what you need. > > you can use a like statement, because there is a lot of stuff > hope that helps > > brian > > -Original Message- > From: Mike At Spy [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 9:51 AM > To: [EMAIL PROTECTED] > Subject: RE: mysql port number > > > > That, of course, isn't even getting into the point that you didn't answer my > question. I asked how I could tell, not what the default port was! > > Thank you to the others that did. :) > > -Mike > > > > > -Original Message- > > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 04, 2002 6:19 PM > > To: Mike At Spy > > Cc: [EMAIL PROTECTED] > > Subject: Re: mysql port number > > > > > > On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: > > > > > > How can I tell what port number mysql is running on? I need it > > for a chat > > > program. :) > > > > 3306 > > > > A google search would have found the answer in no time. > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
show variables that will show you what you need. you can use a like statement, because there is a lot of stuff hope that helps brian -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: RE: mysql port number That, of course, isn't even getting into the point that you didn't answer my question. I asked how I could tell, not what the default port was! Thank you to the others that did. :) -Mike > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 6:19 PM > To: Mike At Spy > Cc: [EMAIL PROTECTED] > Subject: Re: mysql port number > > > On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: > > > > How can I tell what port number mysql is running on? I need it > for a chat > > program. :) > > 3306 > > A google search would have found the answer in no time. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
That, of course, isn't even getting into the point that you didn't answer my question. I asked how I could tell, not what the default port was! Thank you to the others that did. :) -Mike > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 6:19 PM > To: Mike At Spy > Cc: [EMAIL PROTECTED] > Subject: Re: mysql port number > > > On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: > > > > How can I tell what port number mysql is running on? I need it > for a chat > > program. :) > > 3306 > > A google search would have found the answer in no time. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
Actually, I do google searches first before asking on any list - and it didn't turn up a darn thing. -Mike > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 6:19 PM > To: Mike At Spy > Cc: [EMAIL PROTECTED] > Subject: Re: mysql port number > > > On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: > > > > How can I tell what port number mysql is running on? I need it > for a chat > > program. :) > > 3306 > > A google search would have found the answer in no time. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql port number
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 4 Dec 2002, R. Hannes Niedner wrote: > On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote: > > > > How can I tell what port number mysql is running on? I need it for a chat > > program. :) > > > Default is 3306 And with -P=123 or --port=123 for mysqld you can specify any server port you'd like your server to run on. Regards, Iikka Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE97xG8CVGYZ+r4ZncRAkKuAJ9BlXVwcii5C/zep+g3kh3GTuu/3wCgl/H8 VCssqRZS8ggqiFdtqBI50is= =kbxs -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql port number
The default port for MySQL is TCP 3306. If the connection can't be established and you are sure that mysqld is running maybe check netstat -a whether MySql runs on an alternative port or only uses only UNIX sockets. HTH, Mike Bunzel - Original Message - From: "Mike At Spy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 6:04 PM Subject: mysql port number > > How can I tell what port number mysql is running on? I need it for a chat > program. :) > > Thanks, > > -Mike > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
mysql> show variables; 3306 is the default. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: mysql port number How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql port number
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: > > How can I tell what port number mysql is running on? I need it for a chat > program. :) 3306 A google search would have found the answer in no time. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql port number
Show Variables Like 'port'; PB - > How can I tell what port number mysql is running on? I need it for a chat > program. :) > > Thanks, > > -Mike > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql port number
On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote: > > How can I tell what port number mysql is running on? I need it for a chat > program. :) > > Thanks, > > -Mike > Default is 3306 /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Port number
I would suggest you obtain a book on the subject, or visit "mysql.com" and read the documents under "documentation." You are asking questions that have very large answers. To get you started, MySQL is accessed over the web by using a scripting language like PHP or Perl. -Ken At 07:35 PM 6/5/01 -0700, sanborn wrote: >How is MySQL used over a network? I assume there is a port involved, and >some kind of transaction server built into mysql? How do I configure, test >this? In the several documents I have read so far, I haven't found much on >the subject. Thanks for your input. > >Gene Sanborn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Port number
At 7:35 PM -0700 6/5/01, sanborn wrote: >How is MySQL used over a network? I assume there is a port involved, and >some kind of transaction server built into mysql? How do I configure, test >this? In the several documents I have read so far, I haven't found much on >the subject. Thanks for your input. What documents? You probably want to read the manual for this kind of information. The server listens on a UNIX domain socket for local connections and also on port 3306 for TCP/IP connections. > >Gene Sanborn -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Port number
On 6/5/01 7:35 PM, "sanborn" <[EMAIL PROTECTED]> wrote: > How is MySQL used over a network? I assume there is a port involved, and > some kind of transaction server built into mysql? How do I configure, test > this? In the several documents I have read so far, I haven't found much on > the subject. Thanks for your input. > > Gene Sanborn > Standard port is 3306 Hope that helps Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Port number
Default mysql port is 3306. Tyler > -Original Message- > From: sanborn [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 05, 2001 9:36 PM > To: MySQL Mailing List > Subject: MySQL Port number > > > How is MySQL used over a network? I assume there is a port involved, and > some kind of transaction server built into mysql? How do I > configure, test > this? In the several documents I have read so far, I haven't > found much on > the subject. Thanks for your input. > > Gene Sanborn > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php