#Connect mysql workbench to ampps password
#Connect mysql workbench to ampps mac

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.

#Connect mysql workbench to ampps 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. 3306 is default as MySQL/Maria the database port, but I left it here in case someone, sometime, have to use a different port.I happened to have to extract the Entity-Relationship diagram starting from the SQL schema. I tested the connection with some PHP-code, which I included here and might come handy for someone. Now you should be able to access that database. Grant all privileges on test_db.* to your Xampp IP-adress which tends to default to '192.168.64.2' and port 3306. Enter the following in any SQL prompt (which normally can be executed by pressing + ): create user userbob identified by 'Pass2bob!'

#Connect mysql workbench to ampps password

In case needed, log in with the username root and an empty password field.Ĭreate or pick a database for the user, to grant access to, for example 'test_db'. For simplicity, open phpMyAdmin, by default accessible via 127.0.0.1:80/phpmyadmin/ or 127.0.0.1:80/phpmyadmin/ locally. Here's a solution, that worked on a Mac (but should be relevant to most OS's). So just create a new user with the correct access privileges granted. Normally the issue is that one is trying to use root as a user, which is somewhat prohibited.