Golang : What is the default port number for connecting to MySQL/MariaDB database ?
Problem :
How to determine which port number when trying to connect to a database with https://github.com/go-sql-driver/mysql and configuring the data source name.
conn, err := sql.Open("mysql", "db_username:db_password@protocol(address:port_num)/database_name")
Need to find out the port_num portion.
Solution :
The default port number to connect to MySQL or MariaDB is 3306
. Got this from looking at the PHPMyAdmin's configuration file.
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+10k Golang : Find smallest number in array
+4.4k Golang : Accept any number of function arguments with three dots(...)
+2.3k Golang : Humanize and Titleize functions
+31.8k Golang : Unmarshal JSON from http response
+3.7k Golang : Format numbers to nearest thousands such as kilos millions billions and trillions
+8k CodeIgniter : Import Linkedin data
+6.4k Golang : Save(pipe) HTTP response into a file
+6.6k Golang : calculate elapsed run time
+2k Golang : Calculate half life decay example
+9.5k Golang : Use regular expression to validate domain name
+4.5k Golang : How to determine a prime number?
+19.7k Golang : missing Git command