It looks like something is being installed. Having nothing to lose, and always having in mind my boss who wanted that ER diagram at all costs, I open a terminal and run this command, in the hope that it doesn’t destroy everything: sudo /Applications/XAMPP/bin/mysql_upgrade And this time I find another StackOverflow thread where it strangely says that MySQL needs to be updated. Sigh, even the second attempt, unfortunately, failed miserably … Third Attempt 😌īut I don’t lose heart. Tables could not be fetched - Error loading schema content I can see all databases stored on my SQL server, but when I try to access individual tables, it tells me that it is unable to load them: I click on Continue Anyway and everything seems to work fine. This time I try the connection and … the MySQL Workbench gives me a Warning (see side). This time I have configured all the required SSL parameters, in the appropriate spaces indicated in the SSL tab. I then went back to MySQL Workbench and created a new connection. I restarted the SQL server, which started quietly.
I replaced with the path to my directory. The text in question is this: ssl-ca=/ca-cert.pem ssl-cert=/client-cert.pem ssl-key=/client-key.pem ssl-ca=/ca-cert.pem ssl-cert=/server-cert.pem ssl-key=/server-key.pem I copied the files to my local folder and then moved on to the Maria DB server configuration.įrom the XAMPP menu, I selected the MySQL server, and then I clicked on Configure, then on Open Conf File, and at the bottom, I pasted the text that is inside the my.conf.sample file, generated together with the certificates. Once the procedure is completed, you can access the files by clicking the Files button, located immediately below the Wizard button. I have put the checkmark in the Use Default Parameters item. I started MariaDB from the XAMPP control panel:īy following the wizard procedure, it is possible to generate the various certificates. My first attempt was to have MariaDB speak directly to MySQL Workbench. I downloaded the latest version of MySQL Workbench (8.0.27 at the time of writing this article) and installed it.
MYSQL WORKBENCH FOR MAC MAC
But I want to eventually make it.įirst of all, I had already pre-installed on my computer (a Mac OS) the latest version of XAMPP (7.3.33 at the time of writing this article), so I had no desire to downgrade to a previous version with MySQL DB installed, as suggested in some posts on StackOverflow. Getting MariaDB (database provided by new versions of XAMPP) to talk with MySQL Workbench was not a very simple operation. The tool in question is called Reverse Engineering.Īnd here the problems arose. I remembered from distant reminiscences that MySQL Workbench provides a very powerful tool for the automatic conversion of SQL schemas into ER diagrams. However, since my boss had asked me to produce this blessed ER diagram, and not have the desire to manually move the tables one by one in the graph, I thought about using MySQL Workbench. Furthermore, the PhpMyAdmin Designer is a very basic tool, which does not allow you to automatically align the tables to make them more readable. My database had over 20 tables and the Designer showed them all stuck on top of each other. I usually use XAMPP to work in SQL so I told myself to try using the Designer tool provided by PhpMyAdmin. I happened to have to extract the Entity-Relationship diagram starting from the SQL schema.
0 kommentar(er)
