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

learn more… | top users | synonyms

1
vote
2answers
108 views

Where can I find a list of MAMPs?

I'm looking for a MAMP packaging = Apache + MySQL + PHP bundled together for Mac OS X (which is my OS). Where can I find it? Is there an "official" site where I can download it from? [ I know that ...
1
vote
2answers
3k views

How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?

I'm running Mac OS X 10.7. How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?
0
votes
1answer
946 views

How to Automatic Backups of a MySQL Database

I am using the version of MySQL that came with Snow Leopard Server. I am running Time Machine on that server, but I know that it's not backing up the MySQL databases due to strict permissions issues. ...
0
votes
2answers
175 views

Where is MySQL installed for the included Apache server?

I'm trying to set up Web Sharing... phpinfo() shows MySQL is installed, but I can't find it. Terminal says "command not found" when I try mysql. I have no idea what I'm doing, or even if this ...
-1
votes
2answers
762 views

Setup macbook pro for ruby on rails development

I just got my first Macbook :). And now I want to configure it for Ruby on rails development. I want to setup following things: Textmate Ruby using RVM Rails Mysql Postgresql Apache Also I am ...
15
votes
0answers
35k 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 ...
2
votes
1answer
342 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?
0
votes
1answer
1k views

mysql.sock gets deleted on restart

I have set up PHP and MySQL, however MySQL wants the mysql.sock file in /var/mysql, which is fair enough. I change the directory to /var/mysql however every time I restart my computer mysql.sock gets ...
1
vote
2answers
4k 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 ...
5
votes
3answers
5k 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 ...
3
votes
1answer
8k 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 ...
2
votes
2answers
259 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 ...
0
votes
1answer
2k views

[MySQL Server] MySQL Workbench can't find my.cnf on (clean installation of) Snow Leopard

I have a clean installation of Snow Leopard on a MacBook and I want to get a MySQL Server running on it. I downloaded and installed the .dmg file provided by the homepage of MySQL and installed it. I ...
2
votes
2answers
2k 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?
1
vote
2answers
848 views

Cannot start MySQL server with AppleScript - Snow Leopard

I've sucessfully installed MySQL server (5.5.11) on my MAC Snow Leopard. I can start the server using PreferencePane, using command line sudo /usr/local/mysql/bin/mysqld_safe but cannot use the same ...
0
votes
1answer
378 views

MySQL won't start on Snow Leopard

I'm getting this error while trying to start the mysql server $ sudo mysqld_safe --user=mysql 110425 23:11:33 mysqld_safe Logging to '/usr/local/mysql/data/unknown-e0-f8-47-0c-04-a0.lan.err'. 110425 ...
2
votes
4answers
25k 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?
0
votes
2answers
507 views

MySQL - Ruby on Rails mysql gem not working on snow leopard

i have installed mysql 5.5.11 and i'm running on Snow Leopard (10.6.7) when i create my rails application everything wokrs fine: rails fooTest -d mysql then cd fooTest then rake db:create and ...
0
votes
2answers
315 views

MySQL - installation from source failed on ./configure

I'm following this How-to on installing MySQL on Snow Leopard but instead of using MySQL 5.1 I'm downloading the source for MySQL 5.5.11 so when I go into the source directory and run: ./configure ...
0
votes
2answers
463 views

MySQL - The Installation Failed 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 ...
0
votes
1answer
563 views

MySQL service is grey under Server Admin

We just made a fresh install of Mac OSX Server 10.6.7, but the MySQL service doesn't seem to work, which is strange as its a fresh install! I open Server Admin, and under Services, the MySQL service ...
8
votes
3answers
2k 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 ...
1
vote
2answers
2k views

How to get in to mysql prompt in mac os x

I have installed mysql in mac os x (10.6.6). How ever I dont know how to get in to mysql prompt (newbie). Sarbbottam-Bandyopadhyays-MacBook-Pro:bin sarbbottam$ pwd /usr/local/mysql/bin ...
1
vote
3answers
657 views

Installation failed when attempting to reinstall MySQL in OS X 10.6.6

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* $ ...
4
votes
1answer
1k 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 ...
4
votes
1answer
257 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 ...
2
votes
2answers
210 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 ...