Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
12 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
1answer
1k views

Database app, accessible from Mac, iPad and Web

I feel very out of my depth with this query, but not being able to do it isn't really an option so I am going to have to learn how one way or another. I have been tasked with building an application /...
1
vote
0answers
83 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....
4
votes
3answers
19k 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 ...
1
vote
0answers
71 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
1answer
266 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 ...
1
vote
1answer
509 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....
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
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 ...
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 ...
0
votes
1answer
1k 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 ...
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
1answer
270 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
1k 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....
2
votes
1answer
531 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 ...
1
vote
1answer
24 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 ...
3
votes
2answers
17k views

How can I upgrade my MySQL 5.1 to MySQL 5.6, and migrate data

I previously installed MySQL 5.1 using the installer, since then created a number of users/databases, and now would like to upgrade to 5.6. What is the procedure to do so?
9
votes
5answers
17k views

How can I disable MySQL from starting at boot?

I have a mid 2013 MBA running OSX 10.9. The process that starts on every start up is mysqld. I believe it was from an old version of MySQL I had installed (via AMPPS). I then installed MAMP Pro and I ...
3
votes
0answers
302 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
103 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 ...
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: ...
3
votes
1answer
262 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
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 ...
27
votes
6answers
96k views

How to add MySQL to $PATH variable to resolve “mysql: command not found”?

I installed MySQL on my Mac, and now I would like to add it to my $PATH variable. I want to be able to type mysql anywhere. I tried adding the following to my .profile file: export PATH=${PATH}/usr/...
2
votes
2answers
2k views

Uninstall MySQL

I'm trying to get a working copy of MAMP. But I once installed the MySQL server seperately, and I can't find a way to uninstall. How can I uninstall this version of MySQL?
2
votes
2answers
480 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 ...
0
votes
1answer
236 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 ...
0
votes
3answers
6k 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: ## ## # ...
2
votes
2answers
849 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.
5
votes
1answer
950 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 ...
0
votes
1answer
1k 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 ...
1
vote
3answers
1k views

Installation failed when attempting to reinstall MySQL in OS X 10.6.6 [closed]

I had earlier installed mysql-5.1.50-osx10.6-x86_64.dmg and then uninstalled it using the below command (found on Stack Overflow): $ sudo rm /usr/local/mysql $ sudo rm -rf /usr/local/mysql* $ ...
3
votes
1answer
24k views

How do I give mysqld write access to a directory?

I am running OSX right now and trying to run a mysqld process and seeing the following error: $ /usr/local/mysql/bin/mysqld --user=root 111026 11:05:08 [Warning] Can't create test file /usr/local/...
0
votes
2answers
616 views

MySQL 5.5.11 “the installation failed” after removing old installation on Snow Leopard

I had an old instalation of MySQL but it wasn't working very well, so I Googled how to completley remove it and found this: http://tomkeur.net/39/how-to-remove-mysql-completely-mac-os-x-leopard.html ...
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
423 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 ...
7
votes
1answer
1k 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]): ...
9
votes
2answers
28k views

How to install 'MySQL Utilities' using brew or brew cask?

I installed MySQL server and client using brew. I installed MySQL Workbench with brew cask, but I don't find MySQL Utilities (something new?). How to install that using brew or brew cask?
2
votes
2answers
37k 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
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? ...
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 ...
0
votes
2answers
28 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
90 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
6k 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 ...
3
votes
9answers
46k views

The server quit without updating PID file (/usr/local/var/mysql/NAME.pid)

I have installed mysql via brew. First start works, but after reboot, I got the following error: The server quit without updating PID file (/usr/local/var/mysql/NAME.pid) I start mysql with sudo ...
0
votes
1answer
367 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 ...
2
votes
1answer
2k views

How to start auto start mysql? Getting “Path had bad ownership/permissions”

How can I auto start mysqld I tried following https://stackoverflow.com/q/26476391/631619 but it didn't help It seems like I have a ownership/permission problem, possibly related to from having ...
3
votes
1answer
247 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
469 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 ...