MySQL Forums
Forum List  »  MySQL Workbench

Re: User and Privilege managment
Posted by: John Peterson
Date: August 01, 2022 08:51AM


The MySQL Workbench and MySQLDB was working and I have 116 Tables and completed ER Diagrams. This was on Monterey Version 12.4. I called Apple and opened a ticket because I could not reach files such as .local and grayed out files and was told I had to upgrade the O/S that there was a bug in O/S 12.4
Before the upgrade everything was working.

Workbench indicates there is a local instance 3306 with localhost3306.

I believe MySQL was installed and is in a share mode on the MacBook Pro M1 MAX with macOS Monterey Version 12.5

I checked the activity monitor for CPU, Memory, Energy, Disk and Network. No Activity.

When I click on the The Setup Connection is 127.0.01. When I try to Test Connection the system requires the root user password. I enter the password for root. The system responds with a screen to enter the password [This is a loop]

When I try to Configure Local Management under Test DB Connection I receive the following error message:

"Could not connect to MySQL server:
Access denied for user 'root'@'localhost' (using password: YES)
You may continue if the server is simply not running."

In Testing Host Machine Settings I receive an error message:

"Error: File/etc/my.cnf doesn't exist. Message Log:
Check if /etc/my.cnf can be accessed
Operation failed: File /etc/my.cnf doesn't exist.

Under Review Remote Management Settings (No One Will be Using Remote)

MySQL Configuration
MySQL Version: 8.0
Settings Template: macOS (MySQL Package)
Path to Configuration File: /etc/my.cnf
Instance Name in Configuration File: mysqld

Commands for MySQL Management
Start MySQL: launchctl load -F /Library/LaunchDaemons/
Stop MySQL: launchctl unload -F /Library/LaunchDaemons/
Use sudo: Yes

At this point. Would it be best that I delete all instances of MySQL and download another .dmg and start from scratch? Could there be multiple instances of SQLdb running?

Hope I answered your question ... if not let me know.

I have spent an entire two weeks on this issue. I can't move forward on this project since Python 10.5, and Django has the initial def table models coded.I need to complete migration but simply can't.

Appreciate your help.

Options: ReplyQuote

Written By
July 10, 2022 12:17PM
August 01, 2022 07:39AM
Re: User and Privilege managment
August 01, 2022 08:51AM
August 05, 2022 08:07AM
August 06, 2022 10:37AM
August 06, 2022 07:39PM
August 07, 2022 12:02PM
August 07, 2022 12:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.