Sounds like you only installed the MySQL Client Tools (MySQL Workbench). You have to install the MySQL Database server, configure and start it. http://dev.mysql.com/downloads/ You probably want the MySQL Community Server download.
Could it replace phpmyadmin completely? Yes it can. Actually you get much more control in Workbench, especially on the administration side. Probably the main advantage of phpMyAdmin is in its web user interface, which in some cases can be more convenient than the Workbench client.
In the Edit > Preferences… > Appearance > Fonts section of the mentioned version, you can edit the font but you have to slowly double click, as its very wonky (or press enter) and then you manually have to type in the font name followed by a space and font size for example mine states: … Read more
I’m using MySQL version 5.5.9 on MAC. I fixed this problem by running: mysql_upgrade -uroot -p
Here is the correct solution for version +8.0.x. When the program starts, the edited configuration files are changed again. Therefore, you need to add useSSL=1 in advanced.
I recently had this problem as well after exporting my database from MySQL Workbench 6.1 CE and then trying to import it into a newer version of MySQL WorkBench 8.0.11. Each were installed with the community server installer msi. After doing some searching I came across this bug report on the MySQL website: Restaure dump … Read more
In the Alter Table dialog of MySQL Workbench: Go to Indexes tab. Double-click on a blank row to create a new index. Choose ‘UNIQUE’ as the index type. Check the columns that you want to be unique together. There’s some discussion as to whether this is weird, since an index is not the same as … Read more
Under Server Administration on the Home window select the server instance you want to restore database to (Create New Server Instance if doing it first time). Click on Manage Import/Export Click on Data Import/Restore on the left side of the screen. Select Import from Self-Contained File radio button (right side of screen) Select the path … Read more
It is possible to change the query result row limit, or remove the limit entirely. Go to Edit → Preferences → SQL Editor (tab). If you can’t find Query Results, go to SQL Queries(tab) instead. Locate the Query Results section and untick the Limit Rows checkbox Click OK. Re-run your query.
Done it. Query Menu -> Reconnect to Server