How to Create, Import, and Manage MySQL Databases Using phpMyAdmin and Navicat on a CentOS Server

1. Database

1.1 Create database – screenshots illustrate the process of creating a new MySQL database on the server.

1.2 Import database – supports .sql and .zip files; the article shows how to import using phpMyAdmin.

1.3 phpMyAdmin access – install phpMyAdmin, open port 888, and verify database access.

2. Navicat for MySQL

2.1 Installation – download the installer, disconnect from the internet, and run the setup.

2.2 Activation – copy the activation files to the installation directory, run as administrator, generate a license request, and apply the activation code.

3. Connecting to the database

To connect remotely, enable port 3306 in the server’s security group and create a remote user with appropriate privileges via phpMyAdmin.

Open phpMyAdmin → Accounts → Add New User.

Set username, password, and grant required permissions.

After configuring the port and user, both phpMyAdmin and Navicat can successfully connect to the MySQL instance.