Questions tagged [mysql]
An open-source and free relational database management system based on Structured Query Language (SQL)
148
questions
0
votes
0answers
47 views
Somehow MySQL cannot be accessed via command line, but no problem with DBeaver
I have MySQL (v8.0.23) and DBeaver (v7.3.4) installed via Homebrew.
Here's how I start mysql:
$ mysql.server start
For unknown reasons, sometimes MySQL works fine, sometimes it doesn't and spit this ...
0
votes
2answers
49 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 ...
0
votes
1answer
44 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 ...
2
votes
1answer
41 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 ...
0
votes
1answer
111 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
30 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
39 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
49 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 ...
2
votes
1answer
312 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 ...
1
vote
1answer
110 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 ...
4
votes
1answer
1k 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/{...
1
vote
1answer
1k 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():
...
1
vote
3answers
5k 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/...
0
votes
1answer
59 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....
1
vote
3answers
2k 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 ...
2
votes
1answer
463 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 ...
0
votes
0answers
70 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 ...
1
vote
0answers
29 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....
2
votes
0answers
204 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
1answer
967 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
3k 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
1answer
9k 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
1answer
900 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
34 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
0answers
447 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
149 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
2k 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
443 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
548 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
623 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
2k 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
797 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
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 ...
1
vote
1answer
20 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
587 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 ...
8
votes
1answer
3k 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
3k 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
42 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
38k 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
32 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
293 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 ...
0
votes
1answer
396 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
323 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
510 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
1answer
91 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 ...
1
vote
1answer
9k 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
447 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
290 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
51 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?