https://docs.n99panel.com/ 2026-04-17T12:58:27+00:00 https://docs.n99panel.com/ https://docs.n99panel.com/lib/exe/fetch.php?media=wiki:logo.png text/html 2024-04-07T04:44:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.n99panel.com/doku.php?id=mysql:foreign-key-contraints&rev=1712465056&do=diff MySQL DB Importation error w.r.t. Foreign Key Constraints failure When importing a MySQL DB in N99panel, via MySQL DB import functionality, and if you see any error under N99panel tasks pertaining to ‘Cannot add or update a child row: a foreign key constraint fails’ or any similar errors w.r.t. foreign key constraints failure, please do the following action. text/html 2024-04-07T04:52:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.n99panel.com/doku.php?id=mysql:phpmyadmin&rev=1712465523&do=diff How to use phpMyAdmin How to make a MySQL DB/User Pair Step 1 : Log into N99panel. From under N99panel dashboard, click 'MySQL' Step 2 : From under MySQL section, click 'MySQL Pairs' Step 3 : Then click on 'phpMyAdmin' The login credentials of N99panel console would work with phpMyAdmin also unless you have changed the password. text/html 2025-11-05T00:43:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.n99panel.com/doku.php?id=mysql:ssh_tunnel&rev=1762303403&do=diff Accessing MySQL server remotely using SSH Tunnel Step 1 Allow DB access to the hosts 172.16.%.% - refer - <https://docs.n99panel.com/doku.php?id=nodejs:mysql> Step 2 On the Linux machine from where you are trying to access the DB remotely, you need to run the SSH command with the following format text/html 2024-07-15T04:52:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.n99panel.com/doku.php?id=mysql:standalone&rev=1721019157&do=diff Accessing MySQL server remotely or using N99panel VPS as a standalone MySQL server Step 1 : Create a MySQL DB/User Pair Step 2 : Click 'MySQL' on the Dashboard Step 3 : Then Click 'MySQL Pairs' Step 4 : Now against the appropriate pair, click 'Additional Access Hosts' text/html 2024-04-07T04:40:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.n99panel.com/doku.php?id=mysql:unicode&rev=1712464826&do=diff Solving unicode characters visibility issue At times, when a database is restored under N99panel, the unicode characters in certain field/columns of a table, may not handle the way you had expect it would be handled. The primary reason for this is the difference in collation of the field/column viz-a-viz the old setup.