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

learn more… | top users | synonyms

5
votes
3answers
4k 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 ...
2
votes
1answer
7k 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
256 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
1k 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
779 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
370 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 ...
1
vote
4answers
19k 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
437 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
283 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
403 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
557 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
986 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
591 views

Re-install MySql in mac 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 belo command (found in stackoverflow) Sarbbottam-Bandyopadhyays-MacBook-Pro:~ sarbbottam$ sudo rm ...
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
248 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
208 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 ...