Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [homebrew]

15 questions
4
votes
1 answer

Brew Upgrade Mysql: sdi_delete failed: Record Doesn't exist: tablespace_id: 1 Key: 1 4049

I ran the following commands from the cli in MacOS Monterey V 12.4: brew update brew upgrade Upon doing so, MySQL was upgraded from 8.0.30 to 8.0.31. MySQL was running in the background during the upgrade. MySql would not restart, so I rebooted…
Derrick
  • 141
  • 2
3
votes
0 answers

How do I find out details about an error showed iby "brew services list"?

I want test my postgres13 service on mac by using "brew services list". I got following: $ brew services list Name Status User Plist postgresql error gerd /Users/gerd/Library/LaunchAgents/homebrew.mxcl.postgresql.plist How can I…
Gerd
  • 143
  • 1
  • 1
  • 6
3
votes
1 answer

Server quit without updating PID file when trying to start MySQL server?

So I created my .bash_profile, opened it in a text editor and added: export PATH=$PATH:/usr/local/mysql/bin and then I saved it. Next, I tried running sudo /usr/local/mysql/support-files/mysql.server start was told to enter my password (so I did),…
nickcoding
  • 83
  • 1
  • 1
  • 7
2
votes
2 answers

What is causing my ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)?

I'm using brew install mysql/brew install mariadb, and cannot find a way around the following error: ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) Here are the key takeaways: I have nothing running on ports…
It's WPTom
  • 29
  • 4
1
vote
1 answer

MySQL Plugin "mysql_old_password" not loaded

In an attempt to fix another issue I had, I ran the commands below (as per https://dev.mysql.com/doc/refman/5.6/en/old-client.html) mysql> UPDATE mysql.user SET plugin = 'mysql_old_password' mysql> WHERE User = 'root' AND Host = 'localhost'; mysql>…
The Royal Guardian
  • 31
  • 5
1
vote
1 answer

Postgres CREATE DATABASE Not Working

I'm on a Mac using Monterey. It's a Mac M1 which had a bit of an issue using homebrew to install postgres when I first started working on this machine. I moved to the GUI postgres.app which just seemed like a front for the underlying postgres, so…
Rich_F
  • 131
  • 1
  • 10
1
vote
0 answers

Have I destroyed my postgresql database?

I installed psql using homebrew and I use it for some local data tracking. However, there were some issues with installing ruby using homebrew, so one suggestion was to reinstall it. Which I did, and now, I can't get my old databases back. Is it…
hargun3045
  • 111
  • 3
0
votes
0 answers

InnoDB issues with MySQL installed with homebrew

I installed MySQL with Homebrew and I think it was version 5.7 or earlier version at the end of 2022. mysql.server start used to work fine until recent months. My current mysql is of Ver 9.1.0 for macos14.7 on x86_64 (Homebrew). I can still see the…
Paul Chuang
  • 101
0
votes
0 answers

Upgrading database instance for MongoDB 4.2 to 4.4 requires legacy MongoDB on Macosx

I'm running MongoDB within a ten year old node app, and in the process of upgrading node had to upgrade MongoDB. For some time, I have been using MongoDB community 4.4 to run the database, but in the process of upgrading to MongoDB community 7 (the…
peter
  • 101
  • 1
0
votes
1 answer

Removing mongoDB from MacOS

I need to delete all mongoDB thing in my mac. i followed the uninstall guide on mongoDB uninstall official guide but on step 2 which is `launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mongodb-community.plist rm -f…
antisuri
  • 1
  • 1
0
votes
2 answers

How to install sqlplus in macOS M1 Pro ( silicon chip)

I have been searching in internet for best way to install sqlplus in MacOs apple silicon chip ( arm bases processor). please guide me some easiest method to do that. I saw that many article about installing sqlplus in x64 intel based processor but…
Developer
0
votes
0 answers

MySQL and MariaDB on same macOS via brew

How do I install mariadb on my macOS Mojave via homebrew without destroying my MySQL 8 setup ? Error: Cannot install mariadb because conflicting formulae are installed. mysql: because mariadb, mysql, and percona install the same binaries Please…
anjanesh
  • 279
  • 1
  • 3
  • 14
0
votes
1 answer

mysql on Mac Monterey not working regardless what I do

I am running a Mac on Monterey v 12.4 with an M1 Max. I tried to install mysql on my Mac but I never get it to work regardless what I do. The first thing I tried to do is: $ brew install mysql Then I start the server: $ brew services start…
Alex
0
votes
1 answer

postgres: could not find the database system

If I try to run the postgres command, I get: 2020-12-29 00:14:53.213 GMT [34374] LOG: skipping missing configuration file "/usr/local/pgsql/data/postgresql.auto.conf" postgres: could not find the database system Expected to find it in the directory…
Troy
  • 111
  • 1
  • 3
-1
votes
1 answer

How do I connect to a PostGres 14 server installed via Homebrew on Mac OS Big Sur?

I installed PostGreSQL 14 via Homebrew. I seem to be able to restart my local server ... $ brew services restart postgresql@14 Stopping `postgresql@14`... (might take a while) ==> Successfully stopped `postgresql@14` (label:…
Dave
  • 753
  • 10
  • 22
  • 39