/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 vote209 views4 answers
Rownum in sql
SQL
4 votes224 views1 answer
Refresh postgres config
SQL
0 vote228 views1 answer
Show mysql account privilleges
SQL
1 vote338 views3 answers
Create table from existing table in sql
SQL
1 vote229 views1 answer
Oracle grant select on schema
SQL
1 vote199 views2 answers
How to drop a unique constraint in sql
SQL
0 vote205 views1 answer
Add column in sql server ubuntu
SQL
1 vote225 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote221 views1 answer
Create tables from xsd to sql server database c#
SQL
3 votes221 views1 answer
How to find names includes in sql
SQL