How to Create, Import, and Manage MySQL Databases Using phpMyAdmin and Navicat on a CentOS Server
This article provides a step‑by‑step tutorial for setting up a MySQL database on a CentOS server, covering database creation, import, phpMyAdmin installation and configuration, Navicat installation and activation, opening required ports, and configuring remote user access for successful connections.
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.
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
php Courses
php中文网's platform for the latest courses and technical articles, helping PHP learners advance quickly.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.