Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
-1 votes
0 answers
23 views

Load failed: 122: Path had bad ownership/permissions

when I tried to start the mysql 8 in macOS 13.4, shows error like this: /usr/local/Cellar/mysql/8.1.0 ⌚ 22:10:29 $ sudo launchctl load -w /usr/local/Cellar/mysql/8.1.0/homebrew.mxcl.mysql.plist ...
Dolphin's user avatar
  • 973
0 votes
0 answers
18 views

ERROR! The server quit without updating PID file (/usr/local/var/mysql/dolphins-MBP.pid)

Today when I changed the mysql bind address in MacOS 13.4.1 from 127.0.0.1 to 0.0.0.0: /usr/local/etc ⌚ 21:14:53 $ cat my.cnf ...
Dolphin's user avatar
  • 973
0 votes
1 answer
116 views

How to install Dovecot with MySQL support using Homebrew?

I've been trying for ages to get this to work. Standard Homebrew recipe does not include MySQL support. I've tried: brew edit dovecot and added --with-mysql to the args section but it just seems to ...
jlbrown's user avatar
1 vote
1 answer
343 views

(Monterey) Could System Integrity Protection be keeping Python3's "MySQL" library from loading?

The "MySQL" client interface library will not load on MacOS Monterey. The relevant traceback lines are as follows: (System is Django, latest versions of everything.) ImportError: dlopen(/...
Mike Robinson's user avatar
0 votes
2 answers
684 views

MySQL 5.7 via brew on MacOS 12.6: how to get past "Access denied" barrier?

I've been through every how-to I can find on the internet, but none are working for me. I've got a fresh install of MySQL 5.7 via homebrew. I can see that the service is running, and the mysql client ...
Pointy's user avatar
  • 327
0 votes
0 answers
62 views

How to entirely delete MySQL from mac Monterey 12.5.1?

How to entirely delete MySQL from mac Monterey 12.5.1? I read articles about this. In all articles it's written that you should go to "System Preferences" -> "MySql" and you ...
Yerassyl Kelsingazin's user avatar
0 votes
1 answer
4k views

/bin/launchctl problem on start mysql after upgrade to 12.4

I upgrade my OSX to 12.4. after that my brew mysql don't start. I got: $ brew services start mysql Bootstrap failed: 5: Input/output error Try re-running the command as root for richer errors. Error: ...
Gerd's user avatar
  • 191
4 votes
0 answers
3k views

Mysql SSL unsupported protocol error

Since a couple days I cannot connect to several mysql instances when using SSL. I am quite sure it's a problem on my machine, since colleagues and production servers don't have this issue. In both my ...
arno_v's user avatar
  • 141
0 votes
0 answers
665 views

Brew MySQL mapped as MariaDB on Monterey? Issues!

Hello I have installed Homebrew versions of Apache, PHP and MYSQL on Monterey, however I am experiencing some issues when restoring a database which was created on another "pure" MySQL ...
Riccardo's user avatar
  • 283
0 votes
2 answers
826 views

Cannot get mysql database installed properly on Monterey on Apple Silicon

I am trying to set up a development environment on my new MacBookPro 14 inch M1 Pro. I am using MacPorts because that is what I have used for many years. Setting up apache and php have mostly just ...
Jeffrey Simon's user avatar
2 votes
1 answer
2k views

Why is Homebrew running MySQL service as root and how to change it?

I used brew update brew upgrade mysql to bump version from 8.0.23 to 8.0.26 and now MySQL service won't start anymore. I try brew services start mysql and after few seconds the service status goes ...
jva's user avatar
  • 141
0 votes
1 answer
1k views

SQL server on M1 based Mac using Docker [closed]

I am trying to install SQL Server on m1 based Mac with docker https://debugsolutions.wordpress.com/2021/03/17/using-sql-server-on-m1-based-mac-with-docker/ I made it all the way to end of step 5, but ...
adam 's user avatar
0 votes
0 answers
834 views

Cant't stop or kill mysql process and there is no installation to be found

So I've tried installing mariadb and using the mysql command but I always get the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (...
Kris's user avatar
  • 1
0 votes
0 answers
162 views

Error 403 on accessing http://localhost/phpmyadmin/setup

I am trying to set up phpmyadmin on BigSur 11.2.3. I have MySQL server running, put phpmyadmin folder to /usr/local, created config file and trying to access setup via http://localhost/phpmyadmin/...
Max's user avatar
  • 1
0 votes
2 answers
819 views

How can I easily run multiple sites with PHP, Apache and mySQL for free on mac?

How can I easily run multiple sites with PHP, Apache and mySQL for free on mac with OSX? I use XAMPP on Windows and it works really well. When I want to add a new site on XAMPP in windows, I only ...
Xtreme's user avatar
  • 101
0 votes
1 answer
2k views

MySQL connection via SSH tunnel

I've been trying to set up a SSH tunnel with VPN on my macbook with Big Sur 11.2, but it doesn't seem to work. On my linux machine, I can simply turn on the VPN and make a SSH-tunnel. Then I can just ...
Jay Wit's user avatar
  • 103
2 votes
1 answer
467 views

Stopping com.mysql.mysqld from launching over and over and over agin

System messages are showing repeated Dec 25 14:42:02 ROLANDs-MacBook-Pro com.apple.xpc.launchd[1] (com.mysql.mysqld): Service only ran for 0 seconds. Pushing respawn out by 10 seconds. every one of ...
Roland's user avatar
  • 21
0 votes
1 answer
637 views

The file system shows there is a user, "_mysql", that I cannot "su" as root. What is basically going on so I can get mysqld running again

The following shell command sequence makes me realize I don't understand something very basic about how user and group accounts works on MacOS: /tmp$ whoami jondoe /tmp$ cd /usr/local/mysql/data /usr/...
rppkgai's user avatar
  • 349
0 votes
0 answers
261 views

Is there a working alternative for mysql on Sierra (10.12.6) that can be used with php?

Does mariadb function properly on Sierra? I can't get mysql to work and since Sierra isn't supported by mysql I'm giving up on trying to get it to function. does anyone have Sierra working as a ...
Rachel Eberle's user avatar
2 votes
1 answer
687 views

Safari Cant Find Server

Problem I am currently working/developing a Drupal CMS Site and I am trying to work on doing development in my local environment. I used to be able to access the local environment but now I am unable ...
B. Cratty's user avatar
  • 123
1 vote
1 answer
764 views

Extensions are disabled in `php.ini` and they still show up on `phpinfo.php`... why?

So, I finally decide it to switch from windows to Mac after 20 years, and I love it! I have so many questions... I've installed apache, php, mysql, imagemagick using homebrew and I have a couple of ...
Marco's user avatar
  • 111
5 votes
1 answer
4k views

macOS Catalina Homebrew mariadb Installation Issues

Edit 2020-10-12: I'm on macOS 10.15.7, the versions in brew formulas is 10.5.6 for mariadb and 8.0.21 for mysql. (you can check them in /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/Formula/{...
Teddy C's user avatar
  • 1,628
3 votes
1 answer
5k views

How do I install MySQLdb on my MacBook or is there a way I can skip install and use sqlalchemy without it?

I have macOS Sierra and XAMPP installed (with mariadb as database). However, on my local MacBook I am running this Python code to create table: from sqlalchemy import create_engine def create_db(): ...
Ciasto piekarz's user avatar
3 votes
3 answers
8k views

MySQL service doesn't start in Catalina OSX

Installed MySQL 8.0.18 from a dmg file downloaded from the official site. The service won't start when manually started from the new Preferences icon added by the installer. Running sudo /usr/local/...
kaldimar's user avatar
  • 171
0 votes
1 answer
434 views

pip install mysql-python throws error

I am on MacOS Mojave 10.14.6 (18G103). When I try to install mysql-python it throws an error : $ pip install --upgrade setuptools Requirement already up-to-date: setuptools in /usr/local/lib/python2....
anjanesh's user avatar
  • 397
1 vote
3 answers
5k views

How to add the PATH for mysql bin on Mac?

I want to add the PATH for mysql.exe on my Mac. I tried this via terminal, but $ vi.bash_profile vi.bash_profile command not found. does not work. I tried this for generating the bash_profile to ...
Sevana Ahmadzada's user avatar
2 votes
1 answer
894 views

Failure to install mysql on macOS Mojave

I've moved to a new machine and installing MySQL is turning out to be quite an issue (the last time I installed it on a mac it was quite seamless). I used two approaches to install MySQL: brew and ...
Projjol's user avatar
  • 121
0 votes
0 answers
91 views

Cannot access mysql from Perl with SIP enabled on Mac Mojave

I'm using a Mac running Mojave as a dev server. I got Perl talking to MySQL but if I enable SIP, anything that accesses the database chokes. Simply disabling SIP fixes it. I have no idea what this ...
HTM's user avatar
  • 21
1 vote
0 answers
37 views

How to set long password for MySQL user?

I want to set user password of length more than 32 characters. But got an error password is too long. Is there any settings that I can change and use long password? I'm using MAMP PRO 4.4.1, MySQL 5.6....
Vitalii Korsakov's user avatar
2 votes
0 answers
408 views

Missing Messages from chat.db

Hi so I can't currently create a minimum reproducible example but I am missing texts that I know I sent and appear in the search on the iMessage app but aren't in chat.db My python code below import ...
qwertylpc's user avatar
  • 131
2 votes
1 answer
1k views

How to proper setting root mysql password

I'm trying to make Mysql and phpMyAdmin works. I installed mysql using brew Following those answers https://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x I tried ...
alfredopacino's user avatar
5 votes
1 answer
22k views

Unable to install python mysqlclient - OSError: mysql_config not found

I installed mysql through XAMPP. When I try pip install mysqlclient I get this error MBP-of-admin:django_project aanto$ pip install mysqlclient Collecting mysqlclient Using cached https://files....
alfredopacino's user avatar
1 vote
1 answer
14k 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 ...
manal al-harbi's user avatar
0 votes
1 answer
2k 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 ...
Daniel Viglione's user avatar
1 vote
1 answer
55 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 ...
outis's user avatar
  • 405
3 votes
0 answers
685 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, ...
Stani's user avatar
  • 31
0 votes
1 answer
176 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 ...
Graham Needham's user avatar
1 vote
1 answer
6k 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....
BoonMingProg's user avatar
3 votes
1 answer
751 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 ...
Melle Mel's user avatar
1 vote
1 answer
1k 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 ...
Suresh Kumar's user avatar
2 votes
2 answers
729 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 ...
Paul Vincent Beigang's user avatar
2 votes
2 answers
3k 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.
MonTea's user avatar
  • 203
2 votes
1 answer
992 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 ...
gatorback's user avatar
  • 2,913
5 votes
1 answer
2k 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 ...
permutations's user avatar
1 vote
1 answer
35 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 ...
Daniel's user avatar
  • 415
1 vote
0 answers
766 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 ...
Pacerier's user avatar
  • 3,169
10 votes
2 answers
5k 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]): ...
Knows Not Much's user avatar
1 vote
0 answers
4k 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? ...
aircraft's user avatar
  • 1,755
2 votes
0 answers
54 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 ...
aircraft's user avatar
  • 1,755
5 votes
3 answers
58k 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 ...
aircraft's user avatar
  • 1,755