Didi Bui Didi Bui - 1 year ago 427
SQL Question

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?

Answer Source

I figured it out:

  1. Went to my terminal and typed:

     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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download