Unless you specified --skipn-etworking (which turns off TCP/IP sockets) or specifically declared a different port with --port=, the default port is 3306. http://dev.mysql.com/doc/refman/4.1/en/server-options.html
Shawn Green Database Administrator Unimin Corporation - Spruce Pine untz <[EMAIL PROTECTED]> wrote on 12/03/2005 05:17:37 AM: > Michael, > > I would still appreciate it if someone could tell me what the default > port number is because I need that to set up a local JDBC connection. > > Kindest regards, > > Unnsse > > On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote: > > > untz wrote: > >> Hello there! > >> This is a continuation of a previous posting of mine... I noticed > >> that that > >> the CocoaMySQL v0.7b2 client lists the Database, Socket, and Port > >> fields as optional, > >> so I filled the other fields and when I clicked on "Connect", > >> I received this error message: > >> "Unable to connect to host localhost. > >> Be sure that the address is correct and that you have the > >> necessary privileges. > >> MySQL said: Client does not support authentication protocol > >> requested by server; consider upgrading MySQL client" > >> Has anyone used CocoaMySQL v0.7b2 with MySQL 5 on OS X Tiger? What > >> is the default port number? > >> Kindest regards, > >> Unnsse > > > > If you are connecting to the mysql server on localhost, the port is > > irrelevant as you are connecting via unix socket. > > > > The error message indicates that your client (CocoaMySQL v0.7b2) > > was compiled against the mysql 4.0 library. Authentication was > > changed to make it more secure in 4.1. See the manual for details > > and workarounds <http://dev.mysql.com/doc/refman/5.0/en/old- > > client.html>. > > > > Michael > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql? > > [EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
