|Jul 5, 2013, 12:43 PM||#1|
Trying to set up a testing server & MySQL Problem
Just bought a Macbook Air. I'm trying to set up a testing server on it but I'm stuck at a particular step.
I have apache set up and can reach the Sites folder I created in my home directory.
I have php running as the info.php file I created works.
My issue is with mysql.
I downloaded and installed the latest version from mysql.com and installed it. I installed the preference panel. But is there a guide on creating and maintaining a mysql instance from the command line? Every one I see saying to start by typing mysql in terminal, but it tells me that it's not installed. But the preference panel tells me different. Thanks.
|Jul 5, 2013, 01:16 PM||#2|
Can you try this in the terminal
As an example, for my current installation, the bin is in /usr/local/mysql/bin/mysql
|Jul 5, 2013, 01:23 PM||#3|
Hmm that command just returns me to the prompt without any information.
However I see:
At the same path on my machine.
Last edited by mripah; Jul 5, 2013 at 02:10 PM.
|Jul 5, 2013, 02:36 PM||#4|
Might I recommend MAMP?
There's nothing wrong with the way you are doing it, after the setup it's rock solid. I just find MAMP too easy NOT to use.
TI-99/4A, tape cassette, 12" B&W Zenith
|Jul 5, 2013, 02:43 PM||#5|
I´m not sure what is wrong but in my case i needed to run a script to complete the mysql installation, in the mysql folder i executed this command:
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
Hope it helps.
|Jul 5, 2013, 02:55 PM||#6|
Well I downloaded Sequel Pro and was able to connect and create a database and a new user, plus grant permissions. (Bare in mind this is all new to me.)
But I can't connect in Coda2 which is what I'm using for development. Not sure why I can connect in one but not the other. The error I'm getting in Coda is:
I'm trying to connect via MySQL Socket.
|Jul 5, 2013, 03:19 PM||#7|
Well I figured out how to connect from Coda, I had to connect to /tmp/mysql.sock. Is there a "Hello world" query I can run to make sure I'm connected and it's running?
Last edited by mripah; Jul 5, 2013 at 03:57 PM.
|Jul 6, 2013, 09:31 AM||#8|
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|PHP & MySQL help please.||Stocktrader||Web Design and Development||1||Mar 9, 2014 06:04 AM|
|Methods for doing local server-side scripting testing||wrldwzrd89||Web Design and Development||4||Nov 27, 2013 11:35 PM|
|Apple Testing Television Set Prototypes, 'Isn't a Formal Project Yet'||MacRumors||MacRumors.com News Discussion||165||Feb 13, 2013 03:53 PM|
|Server Tool. Testing servers from iPhone||J Christensen||iPhone and iPod touch Apps||1||Dec 10, 2012 02:01 PM|
|MySQL Server Connection||aceiswild||Web Design and Development||6||Jun 30, 2012 01:14 PM|
All times are GMT -5. The time now is 12:30 AM.