Running MySQL Server on a Specific Port in MySQL


How To Run MySQL Server on a Different Port in MySQL?



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-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)


Server Daemon mysqld Administration in MySQL

⇒⇒MySQL Database Tutorials

2017-11-29, 646👍, 0💬