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 [mysql]

An open-source and free relational database management system based on Structured Query Language (SQL)

1
vote
0answers
8 views

MySQL Workbech editor hiding value

I have Workbench on my Windows PC and the Editor looks great .. But I just loaded it onto my Macbook, and it looks funky (I can't see the whole value) .. Does anyone know if there's a setting where I ...
0
votes
0answers
8 views

Recovering old mysql data files with newer version of mysql installed with Homebrew

I installed mysql with Homebrew about a year or so back and created some databases with it. I uninstalled it some time last year. The data files in /usr/local/var/mysql are still around. I recently ...
0
votes
0answers
24 views

Unable to start mysql 5.6

I installed mysql 5.6 using homebrew but haven't been able to start it/login using Sequel pro. When I run mysql.server start in the terminal I am getting this error - ERROR! The server quit ...
0
votes
1answer
165 views

I can’t connect to localhost on Mac high Sierra

I have followed this guide to set-up Apache on High Sierra: https://coolestguidesontheplanet.com/get-apache-mysql-php-and-phpmyadmin-working-on-macos-sierra/ I used it to set it up on Sierra. But ...
0
votes
0answers
43 views

Setting up MySQL on mac to use with Mysql Workbench

Ok so I have a database file which I need to use with mysql workbench but for some reason I can't get to open in mysql work bench: I'm following the instructions in this PDF: PDF to install MYSQL ...
0
votes
1answer
93 views

Is brew using MySQL or MariaDB

A few months ago I installed either MySQL or MariaDB via Homebrew. But I don't remember exactly which one. Now I am trying to figure it out, because MariaDB supports features that MySQL does not, such ...
1
vote
1answer
20 views

How can I restore files when my account isn't granted access?

I had a heavily corrupted MySQL database, so I tried to restore the files from a recent backup (a local time machine snapshot), but that failed with the error: The operation can’t be completed ...
2
votes
0answers
241 views

What would cause MySql to have slow performance on a fresh install of Mojave?

I have noticed slow MySQL performance on my Macbook Pro 2018. Macbook 2018 System Specs: 15" MacBook Pro 2018 2,9 GHz 6‑Core Intel Core i9 32 GB 2400 MHz DDR4 1 TB SSD Tested using mysql-server, ...
0
votes
1answer
77 views

Can you run the latest MySQL security update on macOS 10.12 Sierra?

We're still running MySQL (community server) on macOS 10.12 Sierra (because Apple has gutted later versions of macOS and macOS Server and we don't want to go there just yet). It appears the latest ...
1
vote
1answer
748 views

check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORD(“newpass”)'

I'm using Mysql 8.0.12 version and I am currently facing a problem and I can't solve it even with the references around the internet. I have this error on phpmyadmin . By the I'm using High Sierra 10....
3
votes
1answer
203 views

MAMP still can't access Apache after creating local virtual hosts

I had finally got my PHP and MySQL to work again and then I decided to set up local virtual host. Everything was working perfectly up to that point. I have been getting error messages when I do ...
0
votes
1answer
177 views

Reverse search is not working on mysql terminal on my mac

I was using the mysql in ubuntu terminal. Reverse search was working fine on my ubuntu terminal. Recently I switched to mac, on mac terminal reverse search works fine normally but when I logged in to ...
2
votes
2answers
417 views

mysql command not found after pipe

I installed mysql with homebrew. mysql --version mysql Ver 8.0.11 for osx10.13 on x86_64 (Homebrew) and which mysql /usr/local/bin/mysql but when I try to use it after a pipe, I get the following ...
2
votes
2answers
632 views

If I uninstall mysql with brew, does it drop the databases too?

I want to cleanup my system and uninstall mysql. If I do so with: brew uninstall mysql will the databases also been deleted? I don't want to leave them on the harddisk.
2
votes
1answer
363 views

“Installing” MySQL JDBC .jar file for MATLAB

Goal: "install" JDBC drivers for MATLAB to use This article indicated that one can put the JDBC driver .jar file in: /Library/Java/Extensions/ .bashrc and .bashrc_profile were configured with ...
5
votes
1answer
811 views

Cannot start MySQL - server quit “w/o updating PID file” (PID file missing)

I have been researching this problem for two days, and I know there are many other posts about it. But the solutions are always "fix the permissions". That does not solve it for me. I have recursively ...
1
vote
1answer
16 views

Cannot login to WordPress related MySQL database from iTerm

I realized today I actually have two MySQL databases on my Mac OS X Sierra because when I log in to MySQL via iTerm, its not the same database as what I see via phpMyAdmin, but no matter what username ...
1
vote
0answers
351 views

Strange MySql error <Can't read from messagefile …errmsg.sys>

I'm trying to run MySQL without installation. I downloaded ≪mysql-5.7.20-macos10.12-x86_64.tar.gz≫. In the extracted folder, I created a file ≪errmsg.sys≫ and set the permissions: Then I ...
6
votes
1answer
877 views

(homebrew.mxcl.mysql[2274]): Service could not initialize: Unable to set current working directory. error = 2: No such file or directory

If I run console on my mac and go to the system.log I see that system,log is getting flooded with this error Oct 31 15:57:59 abhisheks-mbp com.apple.xpc.launchd[1] (homebrew.mxcl.mysql[2185]): ...
0
votes
0answers
1k views

Where is the configuration file of the MySQL?

As we know, our Mac own a Mysql, under the /usr/local/mysql, it is a soft link from /usr/local/mysql-<mysql-version>-macos<macos-version>. But how can I find its configuration file? ...
2
votes
0answers
35 views

How can I know which MySQL install is started with the PrefPane in the System Preferences?

I forgot that I installed several MySQL (or MariaDB) packages on my Mac, such as rpm or source code packages. You know the Mac's System Preference has a MySQL quick start/stop panel: How do I know ...
4
votes
3answers
14k views

How to get MySQL's port on Mac through the terminal?

I started MySQL with its PrefPane in System Preferences: When I enter ps aux | grep mysql I get the following output: ldl 33675 0.0 0.0 2432804 772 s003 S+ 11:01上午 0:00.00 ...
0
votes
2answers
26 views

How to set up a local MySQL database for dev purposes in Sierra?

I am developing a PHP web application where all data is to be stored in a MySQL database but unfortunately have no server on which to upload it to and even if I did I will be working offline quite a ...
1
vote
1answer
70 views

Connecting from OS X 10.8 to MySQL

I have a local network at home and am trying to develop some program. The program is cross-platform and it should connect to a MySQL server. The server is set up on the Linux box and it accepts ...
3
votes
1answer
4k views

The new created terminal can not find the file use which in Mac

After I installed the mysql in my Mac, it locate in the: /usr/local/mysql And after I use export add the PATH to the $PATH, I can use which mysql_config find it: aircraftdeMacBook-Pro:/ ldl$ which ...
0
votes
1answer
339 views

Sierra - Apache localhost user level and phpMyAdmin

I've installed the AMP stack (Apache, MySQL, PHP) and phpMyAdmin on my system. I set up user level root too (localhost/~user) and it worked. The things that make me still confused are: Why is it ...
3
votes
1answer
224 views

Lightweight SQL server to serve .sql content

I have a python project that needs to access sql data. I actually have the contents of this database as .sql files and I'm wondering what's the fastest/lightest way to run my project The python ...
1
vote
0answers
425 views

CalendarAgent (CoreData) creating hundreds of errors in the console

CalendarAgent is having some kind of issue and is creating hundreds (no exaggeration) of errors in the Console. I cannot find a way to resolve it. Functionally, the Calendar app itself works fine so ...
1
vote
0answers
100 views

MySQL Server has randomly periodic connect problems

During the day (at development) the local MySQL server throws randomly the "MySQL Server gone away" error message to the PHP MySQL driver. If I try to connect via the mysql console client, it works. ...
1
vote
1answer
71 views

save mysql backup to afp network drive fails as cron job

For some strange reason I am not able to save a generated mysql backup via mysqldump to an afp network drive as a cron job. If I call the shell script as root user (login via sudo su in terminal), it ...
0
votes
1answer
5k views

What does the arrow on the bottom left of the folder icon mean?

As you see the mysql and mysql-5.7.17-macos10.12-x86_64 under the local path. The mysql folder icon has a arrow on the bottom left. Does the arrow mean shortcut to the mysql-5.7.17-macos10.12-x86_64? ...
1
vote
1answer
322 views

mysql on OSX suddenly stopped functioning, unable to locate or connect

Having been using an installed version of mysql for some time without any problem, when I attempted to start the server recently it simply failed to recognise the command. The installation is still ...
1
vote
1answer
227 views

how to start a mysql server on login

I currently use Valet to develop sites, and many of those sites need SQL databases. To host SQL databases, I run a mariaDB server from the Terminal. In order to start the MySQL server so that I can ...
0
votes
1answer
45 views

iPhone app to manage MySQL databases

Is there any app for iPhone where I can manage my server's MySQL databases? Or any app to just create an entire MySQL database?
3
votes
1answer
13k views

ERROR! MySQL server PID file could not be found!

I have reinstalled macOS Sierra on my machine. After installing Oracle MySQL Community Server 5.7.15 (mysql-5.7.15-osx10.11) I tried to stop the MySQL server from the console. I got back the following ...
0
votes
1answer
1k views

MySQL can't start: Symbol not found: _clock_gettime

I just did a fresh install of MySQL with Homebrew, when I start it, it says: %> /usr/local/homebrew/bin/mysqld dyld: lazy symbol binding failed: Symbol not found: _clock_gettime Referenced from: ...
0
votes
2answers
232 views

How to recover the built in Directory Service data?

AFAIU, OS X has a collection of built in users, and one of these users is 'mysql' user. The reason I am making this guess is, the first time I have installed mysql server using the dmg, it installed ...
-1
votes
1answer
236 views

Weird behaviour of mysql-connector-c++ in OSX [closed]

I'm developing an application in c++ in OSX Yosemite that uses mysql. I've installed both mysql and mysql-connector-c++ using brew. I could use the library without any problems until recently, ...
1
vote
1answer
5k views

Cannot execute this binary file

appreciate any assistance, I'm a Mac Noob Im trying to upgrade MySQL in MAMP to 5.6 according to the these instructions When I try to run the .command script as per #2 I get the following output: ...
0
votes
1answer
513 views

Does MAMP installation create conflicts with standalone MySql?

I have just installed MAMP. And I have just now realized that I already have a MySQL server and a database that runs under it. Do I now have two MySQL servers? Will they interfere with each other (and ...
1
vote
2answers
342 views

Upgrade to El Capitan has broken MySQL and Apache

Due to unforeseen circumstances, I was forced to upgrade to OS X 10.11 (El Capitan). Here, the process I followed was to: install Yosemite onto an external hard drive; migrate data from MacBook Pro ...
1
vote
1answer
664 views

Trouble running MySQL on OS X 10.9.5

So I ran over a lot of post treating of this specific problem but none of the answer seems to work for my case. So this is the process : I installed mysql via homebrew that lead me to this : ...
0
votes
1answer
1k views

MySQL fails to start after update

I am on Yosemite 10.10.5 and just now I updated my outdated MySQL to the latest version. I made a copy of my existing databases /usr/local/mysql/data/ somewhere safe. I have tried to setup MySQL both ...
2
votes
1answer
2k views

mysql fails to load on boot

I have a Macbook. Forever I’ve had mysql server installed and running on start (using El Capitan). Well now I’ve installed Wine. Since then mysql server fails to start on reboot. If I manually run ./...
1
vote
1answer
444 views

Script of mysqldump didn't work correct invoked by launchctl in OS X

Here is my question asked on StackExchange 2 days ago. https://stackoverflow.com/q/35839190/4772652 Someone suggested me to ask here. Could anyone give me a hand to solve this? ============ I had ...
3
votes
1answer
6k views

How could I remove mysql from manually installation version

I manually installed the MySQL without homebrew However, I still installed another mysql server by homebrew. which mysql /usr/local/bin/mysql How could I remove the manual installed mysql server, ...
0
votes
3answers
5k views

localhost loads default apache page

I'm setting up a localhost and everything looks like it should work but whenever I go to site.local it loads the default Apache localhost page (It works!). Here's a copy of my hosts file: ## ## # ...
1
vote
1answer
173 views

Unable to install with admin

I am trying to update MAMP MySQL from this link, but when i double click the file as mentioned in the blog. I get message saying, The file “Install_MySQL_5.6.25.command” could not be executed ...
2
votes
2answers
33k views

How to get started with MySQL on Mac

I'm all very new to mySQL. I've installed it from the Oracle website, and I think I managed to run the server with the command: sudo ./mysqld_safe --console But it's impossible to open the client ...
0
votes
2answers
623 views

MAMP PRO uninstalled but Terminal commands still exist. How to remove them as well?

Source: To "uninstall" MAMP, you only have to delete the MAMP directory and everything returns to the original state I uninstalled MAMP using the Uninstaller from Applications/MAMP PRO. I checked ...