Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How to Change Default Port used by MySQL via MySQL Admin? I want to use other ports, such as 3307, instead of the default one, 3306.

How to do it via MySQL Administrator GUI program? If it's not possible then it will be helpful if have the instruction for the console program.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

The default port for MySQL is 3306. If you need to change it, you can add the following line

port = 3307

to your /etc/my.cnf config file. After changing this you'll need to restart you mysql server to pickup the change

service mysqld restart
share|improve this answer

I don't think you can change it via MySQL Admin. Here's a post that explains how to do it via conf file in *nix.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.