To fix these problems, issue the command: sudo apt-get install -f That installation will error out ( Figure 1 ).įigure 1: The errors reported from the initial installation of MySQL Workbench. To run the initial installation, issue the command: sudo dpkg -i mysql-workbench-community-*.deb To start the installation, open up a terminal window and then change into the ~/Downloads directory with the command: cd ~/Downloads Don’t worry, that failure is easy to fix. The installation of MySQL isn’t challenging, but it will fail. Once logged in, your download should start. Head over to the official MySQL Workbench download page, select your platform, click Download, and then log into your Oracle account. Installing MySQL Workbenchīefore you continue, know that in order to download an installation file for this tool, you do have to register for an Oracle account (both the tool and the account are free). The same results can be had on different Linux distributions, only the steps may require alteration (depending upon your choice of platform). I’ll be demonstrating this on a Ubuntu 16.10 desktop connecting to a Ubuntu 16.04 server. I want to walk you through the installation of MySQL Workbench as well as the steps necessary on your MySQL servers to enable connection from the new tool. And with MySQL Workbench, you can also migrate Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects, and data to MySQL with ease. MySQL Workbench is a powerhouse tool for developers and administrators. With this tool you can get an at-a-glance for the database server’s status, client connections, and server variables manage users and privileges export/import data run queries create new schema inspect objects create tables create views create stored procedures and functions search table data and more. MySQL Workbench is a unified GUI for database architects, developers, and DBAs, that makes administering multiple databases (from multiple hosts) significantly more efficient. What if you could have a single point of entry for every MySQL database you administer? If that’s something you’re looking for, then you might want to give MySQL Workbench a try. Of course, you could always install phpMyAdmin on each server, but then you’re having to log into a different web interface for each machine. But when you have a number of databases to work with, running on multiple database servers, a GUI would certainly come in handy. If you’re a DBA, chances are you do most of your database administration via the command line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |