I had previously downloaded MySQL on my computer. However, I discovered MAMP and want to use it. When I try to "Set to default Apache and MySQL ports" in the preferences form, Apache starts back up but MySQL doesn't and then my web program won't recognize my local server. What can I do to fix this?
View 2 RepliesI use the normal command line and i get this message.
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Info:MacBookPro, Mac OS X (10.7.4)
MAMP is playing up on me - it seems to be running ok (ie connected to Apache and MySQL server, green lights are on), but the start page won't load.It also won't let me quit out of it properly. It seems to have quit, but when I load it up again the MAMP console appears immediately with both green lights on (ie it seems to have been running in the background).updated my firmware the other day to 3.1965 (3.1965), could this have something to do with it?nd is it possible to uninstall MAMP and reinstall it?
View 1 Replies View RelatedJust trying to load my wamp sites on mamp.
Copied my folders into htdocs and it says to change to the wamp path file for index.php. I looked it up copied what I thought was the code needed and now all is broken.
I just bought a new Macbook Pro 2.4 and starting fixing it with only fresh installs. I installed the OS X 10.5 (x86_64) pak. It was running fine until now.
The start/stop in the pref.pane don't work and if I do a "mysql start" in the terminal I get:
Quote:
MacBookPro:~ matsaki$ mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I tried to reinstall but it did not help. What's bugging? And what to do?
I downloaded a the newer version directly from mysql and made a install. Now I can't stop mysql from running. I throw away the strat/stop in prefpane too. But as soon as I stop mysql it restart's after 3 seconds??
I am wondering if I have 2 mysql running also. The original in the box and the new one. Now I'm at a stage where I have to solve this problem and I am truly not good with UNIX andMySQL commands to see what's wrong or what to do.
Again I almost don't know anything how to use the terminal.
I have Xcode 4.3.2 downloaded from MacApp store. However, it didn't set my environment for development libraries at all. So I included /Applications/Xcode.app/Contents/Developer/usr/bin/ in PATH so it can find common utilities like make, cc, etc. I have installed mysql-5.5.23-osx10.6-x86_64 from MySQL's DMG archive. That went smooth - I am able to start and stop the server. Get in using mysql command line client interface and execute queries, etc. Perl came preinstalled with 10.7.3 Lion. Version of perl is 5.12.3. I am now trying to install DBD::MySQL driver for interfacing with perl and ran into issues. According to MySQL documentation, I first tried to install this driver using -
shell> perl -MCPAN -e shell
cpan> force install DBD::mysql
But this failed with make errors (the error is same as reported further below). Then, after days of googling, I found the original post by etresoft on installing this driver. I followed the steps documented in that post (reproduced below for easy reference). My comments in italics. Download the MySQL Perl driver. Done. My version of DBD happens to be 4.021.
Extract the archive with:
tar xvf DBD-mysql-4.021.tar
Move into the directory:
cd DBD-mysql-4.021
First, fix the MySQL client library. (credit) For Lion, type:sudo install_name_tool -id /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib Done. No issues.
[code]....
Info:
iMac, Mac OS X (10.7.3)
I'm looking for a Mac desktop application that will allow me to edit MySQL databases that are located on a web server. Kind of like PHPMyAdmin, only as a desktop Mac application.
Do any such applications exist?
I've been looking for a nice way to synchronize MySQL databases in a quick and easy way on the Mac, but so far I haven't found any good options.
Since I'm doing my development locally on both my iMac and my MacBook I'd like to be able to sync the site I'm working on with a click of a button.
There are very nice file syncing tools available (I'm currently using Synk Standard), but as far as MySQL syncing (two-way) goes the only one I've found is Navicat.
While Navicat works great they have for some reason not made it possible to access from the command line in the mac version, which means that I can't run the db sync automatically when I run the file sync.
I've tried UI scripting but it just won't work reliably (it clicks in the wrong places all of the time).
So do you know about any good MySQL syncing tools, that sync in both directions and are scriptable?
I am trying to create on my Macbook a mysql account but it doesnt allow it. I suspect it is the same one in the "/etc/passwd" file: _mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false I am curious though why in that same file I dont see my normal login account. Where is the 2nd list of users? Is it a plist file somewhere? Also anyone know of a utility that shows all the users including root and all the other special accounts in one place?
View 1 Replies View RelatedI am attempting to install MySQL for my Mac.
First, let me say that I attempted to install it using Termnial, but I messed up horribly and got very confused. Therefore I partitioned my HD and started over.
I want to use a GUI to avoid scrambling something in Terminal again, as well as it being easier on the eyes. I have downloaded the two DMG's directly from the MySQL site:
mysql-5.0.67-osx10.5-x86.dmg
mysql-gui-tools-5.0-r12-osx10.4-universal.dmg
I installed the GUI no problem, but MySQL is another thing.
Is it as easy as just installing the packages in the dmg, as well as the prefpane? Or do I need to do some Terminal work as well?
My motivation for attempting to install MySQL is so I can have access to Retrosheet files [URL]. These files are baesball statistics that can be imported into mysql. Ultimately, I would like to be able to use the Game Logs (Link) and query them through MySQL.
I'm unable to connect to mysql. I receive the following error when attempting to connect:
<username>: -> mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
I installed mysql-5.5.23-osx10.6-x86_64 using the user tip located at [URL].
Info:
Mac Pro, Mac OS X (10.7.3)
I was running on Mac 10.6.8 and I wanted to update to Mac 10.9, which I did. I am not discovering that there have been some issued with Apache2 and my localhost. I don't know what is wrong, but I got it working once again.
Now I am having a rather large issue with MySQL. That issue being that it's no longer on my computer. mysql is no longer a bash command, and it's not in my /var/lib/ directory, not is it anywhere else I looked. I had a few databases set up, and I don't know if they were deleted somehow or what. I can't connect via Sequel Pro either. Must I completely reinstall MySQL for it to work again, or is some stuff still recoverable?
Info:
MacBook Pro, OS X Mavericks (10.9)
However I cannot figure out how to shutdown and restart MySQL from the command line and pass these options to mysqld.
Snow Leopard and MySQL 5.1.56 MySQL Community Server.
Info:
MacBook & MacAir & iMac, MacAir 10.5.x -- iMac 10.6.x
Every time i stop MySQL from the pref pane it restarts after 30 sec. I don't have a clue why. Anybody who can help me how to find why?
View 5 Replies View Relatedmysqld has a ton of really nice startup options to help me debug my app. However I cannot figure out how to shutdown and restart MySQL from the command line and pass these options to mysqld.Snow Leopard and MySQL 5.1.56 MySQL Community Server.
Info:
MacBook & MacAir & iMac, MacAir 10.5.x -- iMac 10.6.x
I am attempting to install MySQL on my iMac. I downloaded the DMG packages and instaled them, then the instructions I was following from this [URL]. It told me to install a mysql connector (I am new to all of this so I dont know what a mysql connector is). This did not have a DMG package available, so I downloaded the tar.gz as it was my only option. Following the instructions I opened terminal and entered the following command (as shown in image above): sudo pico /etc/my.cnf. I am concerned about the warning message - this is a work computer and I cannot afford to replace it if something gets screwed up.
Info:
iMac, Mac OS X (10.7.3)
mysql unable to connect; MySQL said: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
Info:
Mac mini, Mac OS X (10.7.3)
Macbook Pro running Lion V 10.7.4 .After a hard drive failure this weekend, I restored frm my most recent backup.Unfortunately this did not include svn, host file changes and some other fairly easy to correct things.The one that has been giving me trouble for the last 8 hours is mysql. I have gone through and removed mysql (multiple times) and did fresh installs. Each time I was getting the error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
Even after changing my /etc/my.cnf file to point to var/lib/mysql/mysql.sock I would get these errors.
Are there multiple locations where mysql points to /tmp/mysql.sock?
I am at a loss of what to do. I have uninstalled reeinstalled. Tried many different solutions all to reeive the same error.
Info:
Mac OS X (10.7.4)
Trying to installed JAMF software on Mac Mini server. One of the configuration steps required setting up a database from the terminal but it requires the MYSQL service to be running and I'm unable to get this service to start.
Info:
Mac mini, Mac OS X (10.6.3)
Server version is: 5.0.8 Current available seems to be : 5.5.24 community server available from h [URL]if I already have several databases running under 5.0.8 what are the hazards with upgrading to 5.5.24 community server?
Info:
Mac mini, Mac OS X (10.6.8)
Unable to connect to the database:Could not connect to MySQL I just started to receive this message, when I try to go to this one website. What caused this? and how can I fix this problem? I an geet to website using other browsers.
Info:
iMac, Mac OS X (10.0.x)
I have one of the first generation Intel Xeon Mac Pros (quad core, 2,66 Ghz I think). and in the last two days, I've been having some problems on startup...the power comes on, but the system never starts. If I turn the power on and off a few times, I can eventually get it to work.
Is this something easily repairable? My Apple Care ran out and I didnt renew it. If this is a costly fix, is it possible to buy a *new* bare bones Mac Pro and just swap the hard drives from my first one?
I looked on other threads with similar issues, but they all seem related to the NVidia 8800 crd, but I have an ATI X1900 installed by Apple.
I was listening to iTunes and browsing the web on safari in OSX10.6.1 and each program became unresponsive and the beach ball popped up. I then held in the power button to turn off my mac and I pressed it a second time to turn it back on. After waiting about 15 seconds on the gray screen a file folder with a question mark came up. I set up a genius bar appointment for Saturday (store has been closed for remodeling and opens back up then) but I would like some knowledge as to what is going on before going into the Apple Store.
View 7 Replies View Relatedi have a 2007 15" mbp that woke me up this morning trying to boot up. here's the story: last night after watching a couple comedy channel shows, i shutdown my machine and left it plugged in the wall to recharge. it sat atop my dresser, with the lid closed. i awoke to the boot-up chime and a bright light spilling out of the 2 mm screen/body crack. the machine then rapidly shutoff and repeated this two or three more times more without me intervening --it's possessed!! after a couple hours of investigating the problem, i'm now completely lost on what to do. i've read all the apple support pages, and tried all their suggestions including reformatting PRAM and SMC. however, nothing worked.
here are the facts: - when i press the power button without the power cord attached--i.e. using just the battery--the chime sounds, hard disk (i think) makes its typical sound, the screen turns grayish-white....but....then, i hear a zzzzpp sound from the top left of the body (under the left speaker) and the boot up immediately fails.
- here's the kicker--when i press the power button with the power cord attached, and with or without the battery inserted = nothing happens; however, if i detach, then reattach the power cord, my mbp automatically boots as described above without me touching the power button.
- my battery is fully charged
- i've tried another power cord and battery...same pattern as above
Whenever I start/restart my MP, I am unable to interact with the unit for 2-3 minutes. The mouse pointer will move, but I cannot click on items, nor will the dock icons magnify until 2-3 minutes after. I have done a clean install now and have taken out the 4890. Everything is back to stock but it continues to occur.
View 3 Replies View RelatedI recently got a G4 450 AGP. My intension was to take the hard drive out of my B&W G3 which at the time it was installed with 10.3x (all latest updates) Took out the hard drive and put it in the G4. Started up the computer and was a little slow starting up but it did. I got a dvd ram drive some time ago and put it in and went to update to 10.4.6 with a retail disk. Went and did the update install and when it went to start up in hung up on the gray apple screen with the gray spinning beach ball of death. Thinking that something went wrong I went thru and did it again. Same out come. Un hooked the dvd drive and the zipdrive. No difference. Switched around the ram chips - used some didn't use others-back and forth. No difference.
Put in the install dvd and ran apple repair-nothing wrong. Ran repair permissions and there were things wrong- don't recall what but everything was fixed. Ran repair permissions again and was clean. Tried restart same thing........................
I am receiving the "You need to restart your computer" message on my PowerBook G4. I receive no resolution when I attempt to restart and/or reset PRM. I then attempted to start the computer with the "Software Install and Restore 2 of 2" disk, to no avail - I still just get the grey screen. Do I need to use the Restore disk to re-install the OS? If so, how do I get the disk to start without having access to finder or menu items? If not, what path do I need to take to resolve this very annoying problem?
View 3 Replies View Relatedmy g5 imac wil show the start light, so I know it works, it won't gong or start up!
Info:iMac, Mac OS X (10.5.8), G5
How can I keep itunes from starting?
Info:
iMac 17; iMac 20; MacBook Pro 15, Mac OS X (10.6.7), iPad2 also. iPhone 4S also.
