/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

4 votes298 views1 answer
Mysql copy table with new name
SQL
0 vote279 views1 answer
Find number of entries sql
SQL
5 votes301 views3 answers
Mysql remove unique constraint
SQL
0 vote246 views1 answer
How to set field to null in sql
SQL
0 vote237 views0 answer
How to connect to datbase in springboot
SQL
20 votes283 views5 answers
Reset auto increment mysql
SQL
0 vote290 views2 answers
How to use aggregate functions in sql
SQL
1 vote282 views2 answers
String to date postgres
SQL
10 votes296 views1 answer
Oracle dependencies table
SQL
2 votes300 views1 answer
Sqlite3 show columns name
SQL