Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mac-os-x]

An operating system published by Apple.

-1
votes
1answer
24 views

Error when getting in to MYSQL from terminal [closed]

I get this error message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) when i try to enter mysql from terminal (Macos).
1
vote
1answer
371 views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
2
votes
2answers
1k views

Homebrew MariaDB Server Start Error with 'mysql.server start'

When starting MariaDB 10.3.8 on MacOS 10.13.6 the following strange behavior occurs: mac:~user$ mysql.server start Starting MariaDB .180813 17:50:11 mysqld_safe Logging to '/usr/local/var/mysql/mbp....
1
vote
1answer
6k views

Getting Failed (exit code: 1). when running restore DB from a .tar file in pgAdmin4 postgresql 10.5 [closed]

I'm taking an intro to SQL course and I can't get my very first database loaded. I have a file dvdrental.tar, I create a new database dvdrental > right click > Restore > Select File > Pick "Data" ...
1
vote
1answer
55 views

error connecting to master 'replica@192.168.57.10:3306' mac-ubuntu

Server info: Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10 Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11 Slave server2 (mac): macOS High Sierra IP: 192.168.0.3 MySQL Server ...
0
votes
0answers
510 views

Uninstall mariadb from OS X

i'm trying to remove mariadb from my Mac but I don't find anything relevant for me. I've installed it from the official pkg. The problem is that the server starts automatically and I can't stop it ...
0
votes
1answer
66 views

Postgres to_tsvector is case sensitive on mac os

On PostgreSQL 10.4 on Ubuntu 10.4-2.pgdg16.04+1 select to_tsvector('simple', 'БОЛЬШИЕ БУКВЫ'); returns 'большие':1 'буквы':2 But on postgres 10.3 (installed by brew) on Mac Os High Sierra version ...
1
vote
1answer
3k views

MySQL 8.0, MacOS, create database issue?

when I use: CREATE DATABASE test; ERROR 3680 (HY000): Failed to create schema directory 'test' (errno: 2 - No such file or directory)
1
vote
1answer
104 views

How to control psql displaying rows with (END)?

After my computer upgraded from Mac Sierra to High Sierra, my psql started exhibiting an annoying behaviour. Sometimes when it lists rows, it prints (END) instead of the prompt, and I have to press ...
19
votes
3answers
9k views

pgAdmin 4 version 3 fails to open a second time

I just installed pgAdmin 4 version 3.0.0 for macOS Sierra, replacing the pgAdmin that came bundled with Postgres 10.3 running locally on the same Mac. I opened the pgAdmin 4.app app icon, which ...
0
votes
0answers
2k views

PostgreSQL - Change postgres password (MacOS)

Is it possible to change the OS 'postgres' user password on MacOS so that I can log on as postgres to edit the config file? I've tried changing permissions - it was a disaster that required a re-...
1
vote
1answer
68 views

Quitting PostgreSQL from mac terminal

When I use terminal, enter my database and then quit by using \q I can not get to the following line in order for example to enter my other database (see below). The cursor is stuck without having the ...
1
vote
1answer
75 views

Installing Postgresql parray_gin extension on mac, include not found

I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build. I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode ...
10
votes
2answers
8k views

Is it possible to install just the mongo Shell?

I have Docker installed and am running a MongoDB container for my local development on my Mac. The problem is that I can't connect to said DB easily from CLI. I have Robo 3T installed, but I would ...
1
vote
0answers
471 views

Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
2
votes
1answer
5k views

no pg_hba.conf entry for host “[local]”, user “pgadmin”, database “postgres”, SSL off on OSX

local all postgres trust host all all 0.0.0.0/0 trust hostnossl all all 0.0.0.0/0 trust I would think either the second or the third would match these criteria. I've ...
1
vote
0answers
495 views

Upgrading PostgreSQL from 9.6.6 to 10.1

I'm attempting to upgrade my local instance of postgres to 10.1 (from 9.6.6) on macOS. Using this gist as a guide, I've encountered a problem when running pg_upgrade. Here are the steps taken: $ mv ...
3
votes
3answers
8k views

Homebrew installed PostgreSQL could not connect, database files are incompatible with server

Here's the error message I'm getting today when I attempt to log in to my localhost PosgreSQL databases using psql: psql: could not connect to server: No such file or directory Is the server ...
0
votes
1answer
1k views

pgAdmin 4 - Can't Create Script on a database [closed]

When I try to CREATE Script on a database I want to use, there is no CREATE Script item in the context menu. But CREATE Script looks fine on another database. I can select it and it works fine. ...
3
votes
2answers
7k views

Uninstall Postgres 10 on macOS – EnterpriseDB installer

Title says it all… How to completely remove a Postgres cluster from a macOS computer? I used the installer app provided by EnterpriseDB as a courtesy to the community. This uninstallation question ...
2
votes
1answer
2k views

Can't open the mysql.plugin table error when installing MySQL on Mac OS Sierra

I am attempting to install MySQL on macOS Sierra 10.12.5. I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I had to create a var/...
1
vote
1answer
885 views

Share the database between vmware guest and host

I wanna Access the MySQL Database founded in Windows 10 from VMware Workstation MAC OS X guest and give the guest ( MAC in VMware ) only permissions to just one database from the host (Windows 10), I ...
1
vote
0answers
667 views

Getting “pg_ctl: No such file or directory” when trying to start Postgres server on Mac

I'm using Postgres 9.5 on Mac Sierra. My postgres db suddenly died, and so I need to restart it, but I'm getting some errors when I try and run /usr/local/var/postgres start below tells the saga .....
0
votes
1answer
973 views

Starting MySql Failed: check log for more info

I just recently started using MAMP, PHPmyAdmin, and wordpress. When I try to restart the server in MAMP PRO by pressing the server icon in top right corner (mamp pro), I get a pop up that reads the ...
0
votes
1answer
171 views

What's causing my postgresql database to freeze? [duplicate]

This is my current setup on my home laptop: OSX El Capitan. Installed postgresql 9.6 via postgres.app. Symlinked the database files to an external HD (connected via USB). Inserting data via the ...
0
votes
1answer
151 views

Cannot change collation on my MySQL database for all tables - please help

I have MAMP installed on my Macbook, I open up phpMyAdmin and go to Operations, I choose the Collation that I need to use for my WordPress site. I then click "GO", but when I run the following query ...
2
votes
2answers
10k views

MySQL on MACOS Sierra secure-file-priv setting

I cannot find where to set secure-file-priv. I get this message: 1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement when running this ...
0
votes
1answer
3k views

Where is the data stored in MySQL databases?

I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database. I have installed MySQL on macOS and I have ...
3
votes
0answers
34 views

Upgrade PostgreSQL 9.3 without moving the DB and messing PostGIS on OSX OpenGeo Suite original installation

I looked for the answer, but could not find a specifically fitting one, so would appreciate an answer or a pointer to one... Q: How do I upgrade PostgreSQL 9.3 to the current (now 9.6 ?) without ...
1
vote
1answer
173 views

Missing commands in MySQL command line history

Why aren't all command that are entered in the MySQL command line saved in the command history? For example, entering the commands DROP DATABASE mydb; CREATE DATABASE mydb DEFAULT CHARACTER SET utf8;...
1
vote
2answers
953 views

SQL Server Docker image on Mac: Storing a Database

I am having reasonable success running SQL Server for Linux on Docker for Mac, as per the instructions on https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker. The article also ...
1
vote
1answer
226 views

Local CouchDB on Mac Opens New Browser Tab Every 5 Seconds

I am doing some testing with CouchDB. I downloaded the CouchDB application on my Mac and ran it - it opened in my browser, I verified, created a database, added docs ... then I closed the application. ...
2
votes
1answer
4k views

How to uninstall PostgreSQL (and pgAdmin3) from OSX Sierra?

I've been having some difficulty getting up and running with PostgreSQL. Having uninstalled PostgreSQL with brew uninstall postgresql and uninstalled/removed Postgres.app I re-installed Postgresql.app....
0
votes
0answers
920 views

New install and admin establishing postgresql password

With a fresh install through homebrew on OSX Sierra brew install postgresql I confirmed the install $ psql -V psql (PostgreSQL) 9.6.1 and entered the basic command $ psql Password: psql: FATAL:...
3
votes
0answers
642 views

How to unlock / repair mysql.sock

My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
4
votes
1answer
309 views

How to properly align columns in SQLite?

I recently began learning with SQLite, and I am trying to output the data of a table into the Terminal (macOS). However, the result after I've set .mode column or .mode tab is not properly aligned ...
0
votes
1answer
4k views

SQLite size limit and performance

I already studied some databases like MySQL but I never professionally work with databases. I am working on a project and we intend to use SQLite (for some reasons: small, lightweight, fast, among ...
2
votes
1answer
979 views

How to increase max_locks_per_transaction in MacOSX [closed]

I've been performing kind of intensive schema dropping and creating over a PostgreSQL server, ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction. I need to ...
0
votes
1answer
441 views

PostgreSQL location with Postgres.app

I am using the postgres.app. I get a terminal window when I start the postgres app. However, when I go into a bash shell and type in psql it says Command not found. I assume the path to the app is not ...
5
votes
3answers
690 views

Export to format compatible with SQL Server

I need to provide data in a format that could be imported into a Microsoft SQL Server database; however, I do not have Windows or access to a SQL Server instance. The data is currently in several CSV ...
1
vote
1answer
482 views

How can I use `psql` without installing via brew

I want to use the psql utility standalone, without installing postgress via brew or something (I have my reasons). I use psql version 9.5.3 on OS X, which was distributed with PostgressApp. When I ...
1
vote
2answers
372 views

Uninstalling / upgrading PostgreSQL on OSX

The problem I have PostgreSQL 9.3 installed on my MacBook Pro. I don't remember how I installed it (there are numerous ways), and now I want to upgrade to PostgreSQL 9.5. Foresnsics The running ...
1
vote
0answers
2k views

How to connect to a Postgres server in a Docker (1.12.0) container on a Mac?

The latest release of Docker doesn't use a virtual machine anymore, instead using a hypervisor to connect to the containers. This means I can no longer login to postgres with psql: ➜ postgres git:(...
3
votes
1answer
11k views

Is there a Portable MySQL

For teaching and testing purposes I would like to run MySQL without actually having to install it. I have found portable PostgreSQL for both Macintosh and Windows, which is good, but have been unable ...
3
votes
1answer
2k views

PostgreSQL: pg_upgrade failing because hstore incompatible

I'm trying to migrate from PostgreSQL 9.4.5_2 -> 9.5.3 I'm trying to use pg_upgrade (from 9.5.3 distribution) and getting the following error: pg_dump: [archiver (db)] query failed: ERROR: ...
1
vote
0answers
380 views

FATAL: role “MYUSERNAME” does not exist

I am new to psql and am trying to set it up using the Postgres.app site on my Mac. After installation and opening psql, this is the message I get: Last login: Sat May 21 07:10:21 on ttys000 '/...
2
votes
1answer
2k views

FreeTDS TSQL connect string

I am unable to connect to a MSSQL 2012 Server using FreeTDS on OSX in the terminal when I pass the -P . Example: V-MBP:etc vashavoc$ tsql -S SERVER_IP -p PORT -U USER -P PASSWORD locale is "en_US....
1
vote
1answer
9k views

Start, stop, configure PostgreSQL through Mac terminal

I am having basic problems using PostgreSQL on my Mac OSX Yosemite, through the terminal. I tried google-ing but this is becoming increasingly difficult and info very scattered so I keep running into ...
0
votes
1answer
1k views

mysql: unknown variable 'table_definition_cache=400'

I added lines to ~/.my.cnf which worked fine for weeks. Now I receive complaints when I run myqsl CLI. System specs: MAC OS X - El Capitan 10.11.13 Mysql Version: mysql Ver 14.14 Distrib 5.6.29, ...
3
votes
1answer
268 views

How to stop OSX MySQL filling up error logs

I've noticed about every second, a new line the mysqld error log noting a login failure. The user isn't always the same, but it consistently happens every second when mysqld is running. I'd like to ...