How to get the database running on MySQL port 3307 Show Posted by: Srinivas S I don't know much about mysql.. hence requesting you to get me out of this situation As per our project documentation and with the result of the below command I assume there are two instances of mysql in the server but my problem is I could able to login into only one instance i.e. 3306 even if I login with -P 3307. From the OS/mysql level, I can see the databases are different [root@aaa root]# netstat -ntap|grep 330* [root@aaa root]# mysql -uroot -p -P 3306 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like '%port%'; mysql> exit Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like '%port%'; mysql> Suggest me what configuration changes I have to do in my.cnf to login to port 3307 Subject Written By Posted How to get the database running on MySQL port 3307 April 03, 2014 08:33AM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. 4.2.4 Connecting to the MySQL Server Using Command OptionsThis section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. For additional information if you are unable to connect, see Section 6.2.14, “Troubleshooting Problems Connecting to MySQL”. For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Each connection parameter has a default value, but you can override default values as necessary using program options specified either on the command line or in an option file. The examples here use the mysql client program, but the principles apply to other clients such as mysqldump, mysqladmin, or mysqlshow. This command invokes mysql without specifying any explicit connection parameters:
Because there are no parameter options, the default values apply:
To specify the host name and user name explicitly, as well as a password, supply appropriate options on the command line. To select a default database, add a database-name argument. Examples:
For password options, the password value is optional:
As just mentioned, including the password value on the command line is a security risk. To avoid this risk, specify the
When the On some systems, the library routine that MySQL uses to prompt for a password automatically limits the password to eight characters. That limitation is a property of the system library, not MySQL. Internally, MySQL does not have any limit for the length of the password. To work around the limitation on systems affected by it, specify your password in an option file (see Section 4.2.2.2, “Using Option Files”). Another workaround is to change your MySQL password to a value that has eight or fewer characters, but that has the disadvantage that shorter passwords tend to be less secure. Client programs determine what type of connection to make as follows:
The Only connection options that are relevant to the selected transport protocol are used or checked. Other connection options are ignored.
For example, with To ensure that the client makes a TCP/IP connection to the local
server, use
If the server is configured to accept IPv6 connections, clients can connect to the local server over IPv6 using On Windows, to force a MySQL client to use a named-pipe connection, specify the
Connections to remote servers use TCP/IP. This command connects to the server running on
To specify a port number explicitly, use the
You can specify a port number for connections to a local server, too. However, as indicated previously, connections
to For this command, the program uses a socket file on Unix and the
To cause the port number to be used, force a TCP/IP connection. For example, invoke the program in either of these ways:
For additional information about options that control how client programs establish connections to the server, see Section 4.2.3, “Command Options for Connecting to the Server”. It is possible to specify connection parameters without entering them on the command line each time you invoke a client program:
Can MySQL use port 3307?MySQL (or most/all other processes) can listen on just about any port (0-65535) though ports below 1024 are privileged and require special permissions (usually root/admin). There is no difference in port 3306, 3307 or 8279 for that matter other than that 3306 is the default port for MySQL.
How do I connect to a specific port in MySQL?How To Connect to MySQL Server on a Different Port? If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server.
How do I change MySQL port from 3306 to 3307?How do you change the MySQL port from 3306 to 3307? Change it to 3307.. Stop MySQL server.. Open "my.ini" file in MySQL server installation directory.. You will see the default port number "port=3306". Change it to desired port number.. After changing, save the "my.ini" file.. Restart MySQL server.. Is port 3307 free?TCP 3307 – Disclaimer
We do our best to provide you with accurate information on PORT 3307 and work hard to keep our database up to date. This is a free service and accuracy is not guaranteed.
|