MySQL Admin - How To Run MySQL Server on a Different Port

How To Run MySQL Server on a Different Port

Q

How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration

✍: FYIcenter.com

A

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)

2007-05-11, 4395👍, 0💬

How To Turn on Binary Logs
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option: >cd \mysql\bi... 2007-05-11, 4509👍, 0💬

How To Run MySQL Server on a Different Port
How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration 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 t... 2007-05-11, 4396👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration 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. The tutorial exercise... 2007-05-11, 4274👍, 0💬

What Is SQL
What Is SQL? - MySQL FAQs - Introduction to SQL Basics SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. 2007-05-11, 4122👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.