Use command-line and GUI tools to administer MySQL and PostGreSQL databases.
Please read the disclaimer before proceeding. We review and update guided solutions like this regularly. If you have suggestions or requests, please write support@kfocus.org.
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.
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.
JetBrains IDEs, such as PyCharm, IntelliJ, and Webstorm, include 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.
Content will be added as needed.
This is a partial revision history. See the git repository for all entries.
2023-11-18 e770b1c6 Add search and help bar2023-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 GEAR