Ask Different Stack Exchange
Ask Different Stack Exchange

Questions tagged [mysql]

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

161 questions
43
votes
7 answers

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/local/mysql/bin/ I have restarted my Terminal but…
JNevens
  • 609
  • 2
  • 6
  • 9
14
votes
0 answers

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

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 the database and a useful GUI. Relational Database…
Chris
  • 463
  • 2
  • 6
  • 13
13
votes
5 answers

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 often have conflicts between these two processes.…
Zaki Aziz
  • 587
  • 2
  • 7
  • 14
10
votes
2 answers

(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]): Service could not initialize: Unable to set current…
Knows Not Much
  • 1,579
  • 5
  • 21
  • 36
10
votes
3 answers

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 latest/other versions of apache/mysql/php, but are…
Michal M
  • 3,786
  • 11
  • 41
  • 58
9
votes
2 answers

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?
Sybil
  • 3,623
  • 12
  • 43
  • 71
9
votes
5 answers

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?
Sarbbottam Bandyopadhyay
  • 277
  • 1
  • 3
  • 10
5
votes
1 answer

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 the mysql deamon. As I understand it, I should be…
Lennart Regebro
  • 250
  • 2
  • 8
5
votes
1 answer

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/{mariadb,mysql}.rb). Mysql works fine after a…
Teddy C
  • 1,404
  • 2
  • 11
  • 30
5
votes
1 answer

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…
alfredopacino
  • 671
  • 3
  • 7
  • 19
5
votes
1 answer

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 changed the permissions on the symbolic and…
permutations
  • 133
  • 1
  • 7
5
votes
3 answers

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 grep mysql _mysql 33474 0.0 0.1 …
aircraft
  • 1,715
  • 5
  • 16
  • 34
5
votes
9 answers

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 mysql.server restart If I try to create a pid file…
user2698024
  • 53
  • 1
  • 1
  • 3
4
votes
0 answers

Mysql SSL unsupported protocol error

Since a couple days I cannot connect to several mysql instances when using SSL. I am quite sure it's a problem on my machine, since colleagues and production servers don't have this issue. In both my Python clients and the mysql command line client…
arno_v
  • 141
  • 4
4
votes
3 answers

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 all - which I require to start up manually. How…
MacMac
  • 422
  • 1
  • 8
  • 19
1
2 3
…
10 11