Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Running MySQL Server on a Specific Port

By: FYIcenter.com

(Continued from previous topic...)

How To Run MySQL Server on a Different Port?

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)

(Continued on next topic...)

1. What Is the MySQL Server Daemon - mysqld?
2. What Are the "mysqld" Command Line Options?
3. How To Start MySQL Server Daemon mysqld?
4. How To Properly Shutdown MySQL Server Daemon mysqld?
5. How Much Memory Does the Server Take?
6. How To Turn on Query Logs?
7. How To Turn on Error Logs?
8. What Is Binary Log File?
9. How To Turn on Binary Logs?
10. How To Use mysqlbinlog to View Binary Logs?
11. How To Run MySQL Server on a Different Port?
12. How To Connect to MySQL Server on a Different Port?