MySQL Forums
Forum List  »  MySQL Workbench

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

Background:

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/com.oracle.oss.mysql.mysqld.plist
Stop MySQL: launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
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


Subject
Views
Written By
Posted
258
July 10, 2022 12:17PM
132
August 01, 2022 07:39AM
Re: User and Privilege managment
126
August 01, 2022 08:51AM
110
August 05, 2022 08:07AM
113
August 06, 2022 10:37AM
101
August 06, 2022 07:39PM
109
August 07, 2022 12:02PM
114
August 07, 2022 12:37PM


Sorry, only registered users may post in this forum.

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.