Questions tagged [mac-os-x]
An operating system published by Apple.
161
questions
-1
votes
1
answer
616
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 ...
6
votes
3
answers
26k
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
1
answer
6k
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 ...
user120246
3
votes
0
answers
44
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 ...
- 763
1
vote
1
answer
318
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;...
- 255
1
vote
2
answers
1k
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://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker. The article also ...
- 2,759
1
vote
1
answer
334
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.
...
- 113
2
votes
1
answer
9k
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....
- 161
2
votes
0
answers
1k
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....
- 121
8
votes
1
answer
4k
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 ...
- 183
0
votes
1
answer
5k
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 ...
- 123
2
votes
1
answer
2k
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 ...
- 121
0
votes
1
answer
1k
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 ...
- 177
5
votes
3
answers
2k
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 ...
- 53
3
votes
1
answer
829
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 ...
- 225
1
vote
2
answers
542
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 ...
- 11.5k
1
vote
1
answer
3k
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:(...
- 280
10
votes
5
answers
27k
views
Is there a Portable MySQL [closed]
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 ...
- 2,759
3
votes
1
answer
3k
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: ...
- 777
1
vote
0
answers
543
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
'/...
- 11
2
votes
1
answer
4k
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....
- 183
2
votes
2
answers
16k
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
1
answer
4k
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, ...
- 103
3
votes
1
answer
421
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 ...
- 3,934
2
votes
1
answer
2k
views
Cannot log in with default user on Mac 10.10
I am running PostgreSQL on a Mac 10.10
PostgreSQL 9.3.5 on x86_64-apple-darwin12.5.0, compiled by Apple LLVM version 5.1 (clang-503.0.40) (based on LLVM 3.4svn), 64-bit
I am having trouble ...
- 177
0
votes
1
answer
1k
views
mysql launch fails after upgrade to 5.7.11
After upgrading a Mac to OS X 10.11.3, mysql was gone, so I downloaded and installed 5.7.11. It installed as usual but fails to launch with;
(com.oracle.oss.mysql.mysqld[1560]): Service exited with ...
- 111
0
votes
1
answer
2k
views
Migrating data from Firebird to CSV on OSX
I have a .gdb Firebird database file that I would like to partially transform to .csv. From the CLI tool, I'm able to do the following:
CONNECT "/Users/jpmonette/Desktop/file.gdb";
OUTPUT /Users/...
- 115
0
votes
2
answers
2k
views
What is making MySQL stay in strict mode
New Mac
El Capitan 10.11.2
mysql-5.7.10-osx10.10-x86_64.dmg
I have to work with a database that has default dates "0000-00-00" but MySQL is in strict mode and chokes on them.
I can't find a way to ...
Roddie Grant
13
votes
3
answers
20k
views
mysqld keeps automatically restarting
I am running mysqld on Mac OSX Al Capitan. After boot up, I ran mysql.server start to start mysqld server.
But when I ran mysql.server stop, or sudo mysql.server stop, it just stopped for a while, ...
- 245
4
votes
1
answer
1k
views
I Need Help Setting Up Roles and Passwords in PostgreSQL
I'm using the postgres.app on my Mac Mini Server running version 9.4.0 using El Capitan. I have not done any customization in pg-hba.conf. I do not have a .pgpass file. I believe that .pgpass is used ...
0
votes
1
answer
784
views
mac os - virtualbox - oracle connection error - invalid username/password; logon denied
I have followed the below step guide(URL) to setup Oracle on Mac OS. Everything is fine on the guest side. But, I am facing some issues in host level.
I can connect database in Guest (Virtual box) ...
- 97
2
votes
1
answer
2k
views
psql "invalid client_encoding" error on OS X, PostgreSQL 9.4.5
I'm currently running a OS X Lion Server system which ships with a built-in and not-upgradable PostgreSQL version.
After years of usage I've finnaly decided to leave the built-in version and install ...
- 716
2
votes
1
answer
1k
views
How to connect DB2 with eclipse on mac? [closed]
I tried to connect the DB2 Express-C Version 10.1 to Eclipse Mars but it returns an exception when I tried to run the program.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
Error ...
- 21
0
votes
0
answers
421
views
How to restore database from a Mac OS X disk image?
So I did take the ship with brave Capitan, and the ship ran aground... My Mac OS 10.11 tried to upgrade to 10.11.1 and freeze my Macbook! There was no backup, Time Machine stop working, so I did a dmg ...
- 101
1
vote
5
answers
20k
views
mongoimport error - Failed: error connecting to db server: no reachable servers
I am currently trying to learn MongoDB and I am having trouble finding a solution for this problem. When I run a mongoimport command it I get the following error:
~ mongoimport --host localhost --...
- 111
29
votes
1
answer
25k
views
Cannot locally import UTF-8 encoded SQL database on Mac
I was importing a confirmed UTF-8 encoded SQL database into Sequel Pro on Mac and got thrown this error halfway through:
An error occurred when reading the file, as it could not be read in
the ...
7
votes
3
answers
9k
views
Mac OS X 10.10 mySQL 5.6.26 accessible from CLI but not port 3306
I did a fresh install of mySQL 5.6.26 on my Mac today. I was able to access mySQL from Terminal.app as expected, however I could not get mySQL workbench to attach to 127.0.0.1 port 3306. What really ...
- 173
3
votes
1
answer
5k
views
Unable to shut down MySQL server
I have tried using the system preferences and then shutting down MySQL there, but to no avail. I also tried typing killall -9 and -11. Both failed :(.
I also tried /usr/local/mysql/bin/mysqladmin -u ...
- 45
2
votes
1
answer
12k
views
How to download Oracle Database 11g release 2 for Mac OS
I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing ...
- 29
2
votes
0
answers
226
views
connecting to a database via tsql on mac 10.10.4
I'm trying to connect to a database via tsql.
I use the following command:
TDSVER=8.0 tsql -S <server IP> -p 1433 -U <my username> -P <my password>
Now, I know the server IP is ...
- 121
0
votes
2
answers
1k
views
Oracle database for learning purposes
I would like to know if I can download Oracle Database on my Mac OS X and use it for learning purposes?
I know that Oracle Database Express Edition 11g is free, but is it free for OS X?
- 111
0
votes
1
answer
384
views
Change MySQL default installation directory in OS X
I install mysql in default installation directory /usr/local/mysql
Is it possible to change mysql installation directory to another path?
I am running OS X 10.10 & MySQL 5.6
- 121
2
votes
1
answer
11k
views
How do I change the MySQL data folder path in a Mac?
How do I change the MySQL data folder path in a Mac?
I am running OS X 10.10 & MySQL 5.6
In Windows I can edit datadir in my.ini
For Mac, mysqld does not have parameter for --defaults-file=
- 121
0
votes
1
answer
72
views
How to peer to a new domain?
How do I peer to a new domain? I'm using NuoDB on MacOS
http://dev.nuodb.com/download-nuodb/request/download
- 1
1
vote
1
answer
1k
views
MySQL, can't find MYD files on OS X, MAMP
Try as I may I can't find the data files for my MAMP installation!
FRM files are here:
/Applications/MAMP/db/mysql/database_name/
but, there are no corresponding MYD or MYI files anywhere.
The ...
- 113
1
vote
1
answer
1k
views
Can't connect to EC2 Postgresql instance unless I change the default port 5432 [closed]
I just created a brand new EC2 instance with a default security group allowing All Traffic from Anywhere.
My listen_address is set to *
I can SSH to it but I can't connect to the pgsql instance ...
- 111
5
votes
5
answers
57k
views
After fresh install getting `psql: command not found`
I downloaded and installed PostgreSQL and PostGIS from KyngChaos for my OS X 10.10 install. When I run psql I get,
bash: psql: command not found
According to the site How to run psql on Mac OS X? it ...
- 177
0
votes
1
answer
5k
views
pg_hba.conf and postgresql.conf in old installation directory
I have installed the PostgreSQL 9.4 on my MacBook via MacPorts, and I am trying to edit pg_hba.conf, but I don't see it in my current installation. Furthermore, psql is reporting that config_file is ...
- 1
1
vote
1
answer
2k
views
MySQL server stops accepting connections partially ("gone away" error)
Hope someone can help me debug this issue.
There is a MySQL server 5.6.22 running on OS X 10.2. The load isn't too heavy. All databases are stored in InnoDB. From time to time it stop accepting ...
- 131
0
votes
1
answer
5k
views
Change MAMP to use a lower Mysql 5.1 version
I need to have the same development environment for my PHP program. My clients test server is running on Mysql 5.1 while my local is using MAMP running Mysql 5.5.
How do downgrade my mysql database ...
- 213