/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 vote216 views1 answer
Convert excel into sqllite db using python
SQL
0 vote216 views2 answers
How to drop mili second in sql
SQL
5 votes208 views1 answer
Oracle asynchronous update
SQL
12 votes190 views4 answers
SQL Where
SQL
4 votes212 views3 answers
Drop Table Oracle
SQL
0 vote245 views2 answers
Check if sql temp table exists
SQL
0 vote197 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote193 views1 answer
Show function mysql
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL
0 vote208 views2 answers
SQL FROM
SQL