Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Installing MySQL Workbench but File /etc/my.cnf doesn't exist

I managed to download the MySQL DMG archive to my OS (mac OS X). It works if I use the command line. Now, I'm trying to install MySQL Workbench. I've created MySQL Connection but once I'm testing the host machine settings, I get:

Checking command 'ps xa | grep "/usr/local/mysql.*/bin/[m]ysqld"'
Server detected as running
Check if /etc/my.cnf can be accessed
Operation failed: File /etc/my.cnf doesn't exist

I'm trying to find the file my.cnf and I get:

Didis-MacBook:~ Didi$ find . -type f -name "*my.cnf*"
find: ./perms/newdir: Permission denied

So I tried to create my own "my.cnf" by entering:

cd /usr/local/mysql/support-files/
sudo cp my-huge.cnf /etc/my.cnf

Then it asked for a password. I don't remember setting up a password. So I typed:

/usr/local/psa/bin/admin --show-password

and get:

-bash: /usr/local/psa/bin/admin: No such file or directory.

I believe my password should be in /etc/passwd but I have no dir "etc" in my system!

I'm running out of ideas, can somebody help me please?

like image 817
Didi Bui Avatar asked Jan 17 '14 03:01

Didi Bui


3 Answers

I figured it out:

  1. Went to my terminal and typed:

     passwd
     Old password was blank
     I created a new password (it was THAT simple)
    
  2. I created a "etc" directory

  3. I checked the files under /usr/local/mysql/support-files/ and saw my cnf file was actually named my-default.cnf and not my-huge.cnf like the developer at the MySQL site.

  4. So I typed: sudo cp my-default.cnf /etc/my.cnf

  5. went back to the Workbench and it FINALLY said:

    Testing host machine settings is done.

like image 121
Didi Bui Avatar answered Sep 19 '22 15:09

Didi Bui


The MySQL Server installation on OS X does not include a cnf file, so it is normal that you get the warning. Nonetheless you can continue creating the connection without problems (ignore the warning). When you start MySQL Workbench afterwards and try to manage the configuration of the server, you will get another warning, but you can continue and MySQL Workbench creates the cnf file for you. No need to do all that manually.

like image 33
Mike Lischke Avatar answered Sep 18 '22 15:09

Mike Lischke


I met this problem too. I just clicked the continue button until i was at "Review remote management settings" step, and stop here click "change parameters", then continue. At "Path to configuration file" choose the path point to my-default.cnf. Then check path, it works

like image 35
user3674318 Avatar answered Sep 21 '22 15:09

user3674318