Collections:
Running MySQL Server on a Specific Port in MySQL
How To Run MySQL Server on a Different Port in MySQL?
✍: FYIcenter.com
By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start the server to listen to a different port number:
>cd \mysql\bin >mysqld --log=\mysql\logs\query.log --log-bin=\mysql\logs\binary.log --log-error=\mysql\logs\error.log --console --port=8888 21:30:33 InnoDB: Started; log sequence number 0 43665 21:30:33 [Note] mysqld: ready for connections. Version: '5.0.24-community-log' socket: '' port: 8888 MySQL Community Edition (GPL)
⇒ Connecting to MySQL Server on a Specific Port in MySQL
⇐ Viewing Log File with "mysqlbinlog" in MySQL
2017-11-29, 1311🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...