CODEWITHSUNDEEP
mysqlubuntu
Manpreet
Manpreet

Reputation: 81

How to change mysql port number in ubuntu

How can i can change port number of mysql from 3306 to mychoice number(1023) in ubuntu 13.10. I tried by editing the port nuber in file: /etc/mysql/my.cnf. But after this change mysql never start . Please guide me how can i do this .

Upvotes: 1

Views: 8236

Answers (2)

Raju Rathore
Raju Rathore

Reputation: 149

Open /etc/mysql/my.cnf in vi editor

# vi /etc/mysql/my.cnf

change port

port=1023

Save and close the file. Finally, restart mysqld:

# service mysqld restart

Upvotes: 1

Manpreet
Manpreet

Reputation: 81

Just Posted Question in askubuntu.com .. The Ans is 1023 is reserved for TCP UPD . I changed to 9999 It worked for me .. Thanks Everyone Here 's link https://askubuntu.com/questions/407847/how-to-change-mysql-port-number-in-ubuntu

Upvotes: 0

Related Questions