Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
27
votes
6answers
97k 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/...
14
votes
0answers
36k views

Is there a relational database with GUI for Mac similar to Microsoft Access or the like? [duplicate]

I need a desktop database that will have a need for extensive 1-many, many-1, and many to many relationships. I've built this kind of app with Microsoft Access, which I don't love, but does combine ...
11
votes
3answers
5k views

Advantages of using MAMP stack over Mac's native Web Sharing and downloaded MySQL

I'm wondering what are the advantages of using a MAMP stack instead of Web Sharing provided with Mac natively and MySQL downloaded and installed manually? I can see how in some cases MAMP can have ...
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?
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 ...
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]): ...
6
votes
5answers
89k views

How to create new mysql user/db in Mac OS X?

Can any one please let me know how to create new user and new db in MySQL? How to use mysqladmin in Mac OS X?
5
votes
1answer
3k views

Stopping a macports installed mysql daemon

I'm trying to reset my root password on a macports installed MySQL on OS X. But none of the ways to do this that I can find works, for various reasons. One reason common to all is that I can't stop ...
5
votes
1answer
967 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 ...
5
votes
3answers
6k views

MySQL does not start on startup

In the System Preferences panel, I have the MySQL there. I chose it to start up every time my Mac starts up, however this doesn't work, I have restarted MySQL many times, but it will not start up at ...
4
votes
2answers
2k views

Starting and stopping mysql server. Shorten and make automatic

Currently I start and stop mysql with the following command sudo /usr/local/mysql/support-files/mysql.server start sudo /usr/local/mysql/support-files/mysql.server stop It is quite a long command ...
4
votes
3answers
20k 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 ...
4
votes
4answers
7k views

phpMyAdmin 403 Forbidden Error after upgrade to Yosemite

I upgraded my Mac to Mac OS X Yosemite. I had a AMP stack installed via Homebrew on Mavericks and it worked fine. After upgrading to Yosemite, I have the following problems: when trying to load ...
4
votes
1answer
320 views

Is it possible to update the preinstalled versions of both MySQL and PHP in OS X?

I'm running 10.6.4 and PHP reports itself as version 5.3.2 (5.3.3 is available) and mySQL reports version 5.1.45 (5.1.51 is available) I know they are minor releases but is it possible to easily ...
4
votes
1answer
580 views

Building mysql with readline instead of editline

I'd really like to be able to use readline instead of editline with the mysql client, but I can't find out how to do this. The bottled mysql that brew installs by default for mavericks is using ...
3
votes
2answers
30k views

MySQL not working on mountain lion

I'm using mountain lion, I have installed MySQL. GUI It shows MySQL is running, but when I type mysql --version It gives error "mysql: command not found"
3
votes
1answer
960 views

MySQL Preference Pane is specifying a port number when it runs mysqld

As it says above. When I run mysqld using the preference pane for MySql, one of the arguments it is providing is --port=3307. Does anyone know how I might go about changing this? Operating System is ...
3
votes
1answer
8k views

Problems with apache after update of php and mysql using homebrew

I am hoping someone here can assist me. I upgraded php and related files using brew upgrade on my mac which is running Mac OS X 10.8.3. Everything was working fine before and I just wanted to update. ...
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?
3
votes
3answers
6k views

Getting Perl DBD::mysql working on OS X 10.7?

I can't seem to get Perl & MySQL to talk to each other on OS X 10.7 Lion. I did all the installs by the book, I used Oracle's PKG installer for the latest MySQL Community Server, and I installed ...
3
votes
4answers
5k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
3
votes
1answer
14k views

ERROR! MySQL server PID file could not be found!

I have reinstalled macOS Sierra on my machine. After installing Oracle MySQL Community Server 5.7.15 (mysql-5.7.15-osx10.11) I tried to stop the MySQL server from the console. I got back the following ...
3
votes
2answers
241 views

Why does OS X's Apache server give different results using real and virtual addresses?

I'm developing a WordPress site on my Mac, running OS X 10.6.4. I'm using OS X's built-in Apache server to run the site locally during development. I've set up WordPress and connected it to OS X's ...
3
votes
1answer
7k 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, ...
3
votes
2answers
302 views

Remove mysql 5.6.26-community

I installed this version of mysql with the script here, but I don't know how to remove it. It isn't in the applications folder. It's here: I wish if someone could tell me how to completely remove it. ...
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
1answer
2k views

MySQL (Percona) and homebrew:

I'm trying to run MySQL server (Percona) by launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.percona-server.plist and I see the following message in /var/log/system.log: Aug 9 01:36:14 xxx com....
3
votes
3answers
18k views

Starting MySQL produces “The server quit without updating PID file”

I've literally looked all over Stack Overflow, Superuser, I cannot find a solution to my problem that I'm experiencing right now, when I want to start MySQL, it produces this error: ERROR! The ...
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/...
3
votes
2answers
6k views

MySQL Preference Pane control for MySQL installed via Homebrew

I have installed MySQL via homebrew: brew install mysql. I'd like to get the MySQL preference pane hooked up to my installation of MySQL through homebrew. How can I achieve this?
3
votes
1answer
266 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 ...
3
votes
1answer
256 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 ...
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 ...
3
votes
1answer
370 views

how can i set up mamp or web sharing to show clients php application remotely?

I'm currently using mamp instead of web sharing and I'm trying to figure out the best approach to share php and mysql web application that I'm working on to clients. What is the best way to do this?
3
votes
0answers
317 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, ...
3
votes
3answers
9k views

How to stop xampp mysql server?

I just installed xampp on my mac os x. When I tried start mysql it displays a message that mysql is already running on this computer. In order to start mysql stop first mysql. I tried following ways ...
2
votes
2answers
484 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
4answers
11k views

How to Properly Install MySQL Server onto OS X 10.10 Running OS X Server

I have seen numerous suggestions about using MAMP to install MySQL on OS X, but since I have the Server app and already have Apache and PHP, which I do not wish to mess up, I wonder how to properly ...
2
votes
1answer
373 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 ...
2
votes
1answer
2k views

mysql fails to load on boot

I have a Macbook. Forever I’ve had mysql server installed and running on start (using El Capitan). Well now I’ve installed Wine. Since then mysql server fails to start on reboot. If I manually run ./...
2
votes
2answers
38k 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 ...
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
270 views

Will Lion install MySQL with it?

I had MAMP running on my laptop. I use MySQL a lot. I kinda messed with the user file permission and I fixed it , in that process I changed some password in MySQL config files. So now SQL does not ...
2
votes
2answers
894 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
563 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 ...
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 ...
2
votes
1answer
455 views

Mac OS X Lion Server and Macports - Can they work together?

I've been using macports for my MAMP projects for quite some time, but I don't think that the command line server management for Apache and MySQL Server, both from macports, is the best way to do it. ...
2
votes
2answers
1k views

Is the performance of Lion + SSD + Filevault2 good enough for a system primarily used for application developemnt?

I'm looking to buy a MacBook Pro w/ SSD. I was wondering if anyone out there has noticed any significant performance drop with FileVault2 enabled for the following tasks: Small (under 2 GB) ...
2
votes
1answer
25 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 ...
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 ...