mysqlunixmysql-workbenchworkbenchmy.cnf

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?

Solution

  • 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.