Use command-line and GUI tools to administer MySQL and PostGreSQL databases.
Design and manage databases with software such as MySQL.
Please read the disclaimer before proceeding. We review and update guided solutions regularly. If you have suggestions or requests, please write support@kfocus.org.
If you install a database on your system, you should consider moving its data to a better location than the default. This helps reduce snapshot size, eases management, and improves performance. See the Big Data Management Guided Solution for detailed instructions.
Use the official MySQL client, mysql, or consider mycli which provides auto-complete and syntax highlighting. Install the latter by using sudo apt install mycli. It has Vim and Emacs modes, but may be slower in some situations. If you install MySQL on your system, see Big Data Management on how to best store its data.
Access MySQL databases with mycli.
Use official PostgreSQL client psql, or consider pgcli which provides auto-complete and syntax highlighting. Install the latter by using sudo apt install pgcli. It has Vim and Emacs modes, but may be slower in some situations. If you install PostgreSQL on your system, see Big Data Management on how to best store its data.
Access PostgreSQL databases with pgcli.
JetBrains provides the DataGrip suite of database tools with impressive visualization and design capabilities. If you are a professional database or application developer, an advanced tool like this can really help improve productivity, especially during design. Simpler tools such as those shown above are still preferred for remote administration or debugging where heavy IDE tools are impractical, clumsy, or impossible to install.
Visualize, design, and work with databases using DataGrip.
Content will be added as needed.
This is a partial revision history. See the git repository for all entries.
2025-07-24 b2d2ef80 Update documentation for moving bulk data2025-04-19 274c0ff1 Update grammar and content per audit2024-09-15 7c90ed72 Add database move instructions2024-09-10 73fcff02 Finalize Lightbox and doc update2024-09-05 14887652 Major Lightbox updates, fix some out-of-date documentation2024-08-19 57a2389d Add white theme2024-07-26 7814a97d Sync primary images between guided solutions slideshow and articles2023-11-18 e770b1c6 Add search and help bar2023-10-16 6c89ed71 Add instructions to move large databases2023-06-19 a7af817b Add 3 new images2021-10-25 9036f3fe Overhaul table and links2021-10-11 f726f2bf Secure links2021-10-10 5728326e Reformat to 2-column2021-09-22 dc862884 Update link and headline colors2021-08-23 681261b4 Review and update codeblocks2021-07-28 1b9cf29b Revise units to have a space after number2020-06-10 c4ed9299 Restructure layout2020-05-15 0684cd5c Proof reading and adjustment2020-01-31 70b4aa40 First publicationWe try hard to provide a useful solution validated by professionals. However, we cannot anticipate every situation, and therefore cannot guarantee this procedure will work for your needs. Always backup your data and test the solution to determine the correct procedure for you.
THIS SOLUTION IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOLUTION, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
HAVE QUESTIONS?Call 844-536-2871 or write
TellMeMore@kfocus.org | GET FOCUS MERCH