MySQL Default Port 3306 | Credentials & Configuration

← Back to all services

🔌 Default Ports

3306

tcp

MySQL protocol

33060

tcp

MySQL X Protocol

📦 Installation Command

apt install mysql-server mysql-client

⚙️ Configuration Files

/etc/mysql/mysql.conf.d/mysqld.cnf
/etc/mysql/my.cnf
/etc/mysql/conf.d/
/etc/mysql/mysql.cnf

📂 Default Directories

config: /etc/mysql
data: /var/lib/mysql
logs: /var/log/mysql
socket: /var/run/mysqld/mysqld.sock

🔐 Default Credentials

Username:root

Password:N/A (auth_socket by default)

💡 Ubuntu uses auth_socket plugin - root login via sudo mysql. Run mysql_secure_installation to set password. Debian-sys-maint creds in /etc/mysql/debian.cnf

📌 Dependencies

mysql-commonlibmysqlclient21

⚠️ Conflicts

mariadb-server (same port, same data dir) Port: mariadb-serverPort: percona-server

✅ Works With

php-fpmnginxapache2phpmyadmin

🛡️ Security Notes

Run mysql_secure_installation, disable remote root login, use strong passwords, enable SSL for remote connections, regular backups with mysqldump or mysqlpump

❓ Frequently Asked Questions

What is MySQL default port?

MySQL uses port 3306 by default for client connections.

What is MySQL default username and password?

Default username is 'root'. On Ubuntu, root uses socket authentication with no password initially.

How to secure MySQL installation?

Run: sudo mysql_secure_installation to set root password and remove test databases.