/SQL/Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux

Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

port 3306 =>3309 /*change the port number from 3306 to any of choice*/

service mysql restart

sudo mysql

select @@port /*to identify the new port running on*/

https://www.linkedin.com/pulse/how-change-mysql-default-port-3306-secure-piyush-diwakar/?trk=public_profile_article_view

Similar codes

0 vote138 views1 answer
Select in select sql
SQL
22 votes137 views3 answers
Join three tables sql
SQL
0 vote147 views1 answer
Ansi sql count duplicate rows
SQL
0 vote131 views1 answer
How to to get current date and time in sql
SQL
0 vote141 views1 answer
Contact mysql column field
SQL
0 vote143 views1 answer
Copying query result to excel
SQL
0 vote137 views1 answer
Mysql workbench format date
SQL
9 votes161 views3 answers
Where clause sql
SQL
7 votes156 views3 answers
Sql server reset auto increment
SQL
20 votes152 views3 answers
How to open postgresql in mac
SQL