Questions tagged [mysql]

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

19 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
406 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, ...
2
votes
0answers
177 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 ...
2
votes
0answers
41 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 ...
2
votes
0answers
182 views

Mac Pro running MySQL: Error 2013 Error 32

This is mysql running on an Mountain Lion OS X with server.app v2 that set up the server. We suddenly have an issue where only one of anything can seem to connect to mysql at anytime. The problem ...
1
vote
0answers
22 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....
1
vote
0answers
546 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 ...
1
vote
0answers
504 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
512 views

Fatal: Unknown scheme: SHA512-CRYPT - is This mac related?

You can see from the output of the samples shows in the first case, that SHA512-CRYPT seems to be Unknown. The code I used is from a Linux based tutorial on setting up Postfix+Dovecot+MySQL on a site. ...
1
vote
1answer
1k views

Uninstalling all instances of apache, php and mysql

So When I first got my mac mini, I installed things like apache, mysql and php - not knowing that apple either came with these or had a tool called mamp that would allow you to run these. I thought ...
1
vote
1answer
327 views

MySQL server wont start

For some reason, MySQL won't start anymore. Suddenly happened out of the blue. This is what is written in /var/log/system.log right after I try to open MySQL. Feb 8 16:07:31 mys-MacBook-Air....
0
votes
1answer
58 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/...
0
votes
0answers
12 views

Failing to connect Python to MySQL — no luck with brew install mysql-connector-c

I think I must have made some mess with brew install/uninstall of MySQL, but I don't know how to get out of this state: I'm trying to run MySQL stuff on Python 3.7 (High Sierra 10.13). However: ...
0
votes
0answers
17 views

Openssl does not switch to other version

I have read some topics on how to switch openssl to other version. I tried: (venv) ➜ project git:(131-use-dotenv) brew switch openssl 1.0.2t Cleaning /usr/local/Cellar/openssl/1.0.2t Opt link ...
0
votes
0answers
25 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 ...
0
votes
0answers
623 views

macOS Catalina Homebrew mariadb Installation Issues

So I'm running macOS 10.15.2 Catalina and try to install mariadb (10.4.11, the lastest version) with Homebrew. After running brew install mariadb, brew warned that the postinstalllation didn't ...
0
votes
0answers
66 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 ...
0
votes
0answers
37 views

MariaDB cannot reset lost root password according to usual process

I'm preparing a local copy of MariaDB on OS X (already works fine with one local dev site) for a data dump and forgot my root password (stupid I know). But the usual reset password fails like this: $...
0
votes
0answers
2k 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? ...
0
votes
1answer
2k views

403 forbidden on Apache vHost

I'm using Mac OS X 10.6.8 and I'm trying to configure a vHost. I configured it and it gave me a 403 Forbidden, and I'm having trouble giving _www permission to read/write in ~/Document/workspace/dev ...