Questions tagged [mysql]

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

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
318 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
36 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
112 views

How to open port 3306 only for localhost traffic on MacOS Mojave 10.14.5?

I would like to open up port 3306 on my localhost but only for traffic on my local LAN. How should I go about doing that? When I check to see if the port is open I get: $ nmap -p 3306 localhost ...
1
vote
0answers
16 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
82 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 ...
1
vote
0answers
10 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 ...
1
vote
0answers
430 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
474 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
463 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
320 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
0answers
43 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
27 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
16 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
35 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
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 ...