![]() The reason is that recent Ubuntu installation (maybe others also), mysql is using by default the UNIX or auth_socket plugin. And I am able to work with it through the workbench so far. I donât think this is the perfect solution but gets the job done. MySQL Workbench for Windows can be installed using the MySQL Installer that installs and updates all MySQL products on Windows or the standalone Windows MSI. This might be a case to leave this infor hanging somewhere in case someone else needs heps as well. I followed the steps below and it worked. And for Debian you would need to allow some changes in it. It is also possible to start MySQL Workbench from the command line: shell> open MySQLWorkbench.app .It seems that the folks at MySQL (I would have to check that better) designed Workbench for Mac Unix system. To launch MySQL Workbench on Mac OS X, simply open the Applications folder in the Finder, then double-click MySQL Workbench. I found this tutorial on the internet that explained why I was having some problem. Click the Download Button next to the mysql-installer-community-8.0.31.0 msi file (. Thank you very much Michael! Have a great day. Using the following URL, navigate to the MySQL Community Downloads page: 2. I think you shed some light so I can find an answer. I am not really sure how to get around this. This group is read both both by the client and the server use it for options that affect everything Run program with -help to get a list of available options and with âprint-defaults to see which it would actually understand and use. ![]() One can use all long options that the program supports. If the same option is defined multiple times, the last one will apply. â~/.my.cnfâ to set user-specific options. â/etc/mysql//*.cnfâ to set MariaDB-only options. â/etc/mysql/conf.d/*.cnfâ to set global options. â/etc/mysql/mariadb.cnfâ (this file) to set global defaults, 2. "# The MariaDB configuration file The MariaDB/MySQL tools read configuration files in the following order: 1. Click on MySQL Server then the Add button. The installer is a bit confusing, but donât worry, most everything is fine left on its default. And inside the file I have the following information. After youâve downloaded it, open the the file. I just checked and there is a âmariadb.cnfâ file instead of a âmysqldb.cnfâ file. Someone knows how to get around it?Īlso the winner answer is any that can make me able to work with MySQL with Workbench on Debian 9. I want to know if anyone knows a solution for this? Or if this is a thing that happens on Debian9. ALTER USER IDENTIFIED WITH mysql_native_password BY âMy Passwordâ (Didnât get to this part because of the #4)Īlso no error shows up on the screen.sudo mysql -u root (Didnât get to this part because of the #4).sudo service mysql restart (Didnât get to this part because of the #4).The thing is that is shows as if it is blank. Edit and change the bind-address to 0.0.0.0 (I wasnât able to do that, because of the next step).Ĥ sudo nano /etc/mysql//mysqld.cnf (This part should allow me to access the bind address.I followed these steps (which are contained in the YouTube video): I also looked into other configuration but I wasnât able and I have been with this problem for some time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |