Answers for "how to change port mysql in ubuntu"

SQL
11

check mysql port ubuntu

mysql -u root
mysql> SHOW GLOBAL VARIABLES LIKE 'PORT';
# Default port is 3306 for MySQL
Posted by: Guest on May-15-2021
0

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
Posted by: Guest on November-15-2021

Code answers related to "how to change port mysql in ubuntu"

Code answers related to "SQL"

Browse Popular Code Answers by Language