Geek Answers Handbook

Installing MySQL Workbench, but File / etc / my.cnf does not exist

I was able to download the MySQL DMG archive to my OS (Mac OS X). It works if I use the command line. Now I am trying to install MySQL Workbench. I created MySQL Connection, but as soon as I test the host 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 try to find my.cnf file 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 typing:

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

Then he asked for a password. I do not remember how the password was configured. Therefore, I typed:

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

and get:

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

I believe that my password should be in / etc / passwd, but I don’t have the “etc” directory on my system!

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

+4
3

:

  • :

     passwd
 Old password was blank
 I created a new password (it was THAT simple)

  • "etc"

  • /usr/local/mysql/support-files/ , cnf my-default.cnf, my-huge.cnf, MySQL.

  • , : sudo cp my-default.cnf /etc/my.cnf

  • Workbench, :

    -.

+11

MySQL Server OS X cnf, . ( ). MySQL Workbench , , , MySQL Workbench cnf. .

+4

I also met this problem. I just clicked the “Continue” button until I was in the “Remote Control Settings Overview” section, and stop here, click “Change Settings,” and then continue. In the "Path to the configuration file" section, select the path to my-default.cnf. Then check the path, it works

+2
source

More articles:


All Articles