I'm just wondering if ther's anyone out there using this kind of *technology* ! So happy to see that I can use more ellegant way of coding.

WO is Me!!!

Web Objects do have some advantages, but you certainly don't have as many OSs to choose from to deploy your web application. I easily moved my web site from Linux to MacOS X in a couple hours. Not only that, PHP4, MySQL, and Apache runs on a number of other server OSs such as Windows, Solaris, and BSD OSs.

I had a reader report trouble installing MySQL when their hostname did not match the name you get with an nslookup. Open a terminal and do a "nslookup your.ip.here" with your IP address. The server will reply with your domain name. Type "sudo hostname newhostname". Enter your root password and see if that fixes errors you were getting during installation.

This same procedure was neccessary for me to run the WebObjects examples Apple included with MacOS X CDs.

I've attempted to install MySQL but I can't seem to connect to the server. It is running per the processes viewer however when attempting t connect I recieve: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

The MacOS X machine is a LAN client and does not have it's own domain other than localhost.

Any thoughts?

Thanks a lot for proving that OS X rocks for web dev!

Thanks Eric! I'm a app developer and I've been lagging on getting this going on my home g3. You just made the process nice and painless. Next I can convince work to move to X/php/mySQL - We're cf and SQLserver right now. Wait, actually next is a beowulf configuration of g4's on X. Yeeaah.

Lets replace LAMP with XAMP

Linux/Apache/MySQL/PHP

OSX/Apache/MySQL/PHP

with phakt you can use UltraDev4 to do most all development using PHP or JSP.

Thanks to both this site, and the marc's page listed above, I was able to get PHP and MySQL setup perfectly, and got my first Database created, but I also took mark's advice and created a 'secure the open master account in the default installation:' I don't think you covered this on this page, a needed to use ' sudo mysql -p ' and now I am getting 'Access denied' errors on my page.

Also, I tried copy / paste into 'TextEdit'
but I had problems due to the RTF format, so I used bbedit instead which worked fine.

Any idea's how I can fix your index.php to work with the password I have added?

Thanks again for this site, it has helped me loads!

WoooHooo! - I started again, this time with root access, and it all works fine...

Thanks!

I just had to thank you for your well written, informative, lucid explanation of getting started with MySQL/PHP. I've been pulling my hair out for weeks just trying to find an explanation of this stuff that actually makes sense. Thanks.

I am getting an error saying that the database cannot be created, permission denied. Also getting login error saying that permission deied from root@localhost - when logged in as root...what's going on, and how do I fix it?

The permission denied can be be resolved by hard coding the root password in $dbh = mysql_connect("localhost","root","(password)"). I dont think is it so secure but good for learning.

Yeah, that doesn't seem so secure to me either. How would this be gotten around? Anyone?

I have mysql and php successfully installed. But as I am starting your tutorial I get the following error after the command
sudo mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

could you let me know haw to fix this?
I am quite anxious to learn and your tutorial is most helpful.

Installed everything and tried this tutorial. The browser does not show me anything when i type http://127.0.0.1/~username/index.php

just a black file...no errors, nothing. What could be the problem?

HELP

that's blank file not black...oops

the blank file: did you forget to drop the database you created in the command line?
mysql> drop database CONTACT;

finally mastered the triumvirate (in apx. 3 h, departing from a clean sytem install) I hope the next update will not break all down.
marc liyange advised to set the mysql password. as complete php/mysql beginner i had first to find out that in the line '$dbh = mysql_connect("localhost","root","****"); the db- password had to been set. now all works as it should

lubowsky

Finally someone has made a good tutorial to get something up and running!!!!!

I wish everyone started like this!

Cheers :-)

Yep, it really really works! Well, it does once you figure out the root password issue, like lubowsky commented. This has been a long time coming, I've been waiting for a stable mysql release that fixed the shutdown bug. But now I'm concerned about mysql auto-shutdown, we have a gadget to do a startup on boot, but does it safely shut down when the CPU is shut down?

Well then, first of all : THANKS it works :-)
Then a little problem, Mysql works well in the terminal, I add, drop and play with it quite fine, Php also is really funny to use but but but...
I can't connect this damned mysql from a web browser : the user (root) and the password I give (which is the same that I give in the terminal) doesn't works :-(
I tried to use the PhpMyAdmin also and I have the same problem of authentification.
Does anybody have any idea to help me? Yu're welcome.
--
az

Well..it works fine...download put it in yur local website set the config.inc.php to "root" as user and nothing more in this file and...it runs fine :-)
so no password is needed when you log as root.
I think that I will put a .htaccess right now...
Bye
--
az

that was quick and easy.

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 19

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 19

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 22

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 22

Warning: MySQL: A link to the server could not be established in /Users/sku/Sites/index.php on line 22

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 26

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 26

Warning: MySQL: A link to the server could not be established in /Users/sku/Sites/index.php on line 26
1045: Access denied for user: 'root@localhost' (Using password: NO)
Warning: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 34

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /Users/sku/Sites/index.php on line 34

Warning: MySQL: A link to the server could not be established in /Users/sku/Sites/index.php on line 34
Can't Select CONTACT
Warning: Supplied argument is not a valid MySQL-Link resource in /Users/sku/Sites/index.php on line 40
1045: Access denied for user: 'root@localhost' (Using password: NO)


This is what I get from the index.php...what can I do? I am new to PHP, terminal.app and MySQL.

If you have set a password for your mysql server, you will need to modify this line:

$dbh = mysql_connect("localhost","root","your_password");

well, after all i've heard about mysql, and databases i thought i'd be in for a rough ride. config was easy, now i'm off to learn more PHP to build and create stuff in web apps. thanx, great to see this work for the Mac community

when i open the php page thru my browser, i only see the php file and nothing else. It's just like viewing a static page.

Is is really a good idea to log in as "root" to query the DB?

I followed the steps, but I get the following error:

[localhost:~] hoffj% sudo mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[localhost:~] hoffj%

I have to thank you + Marc for these pages. They really got me started. I never imagined I would be setting up and running the latest Apache, PHP and MySQL on my Mac. Thanks!

where's the line

$dbh = mysql_connect("localhost","root","your_password");

I type it as it as in the terminal but it says Badly placed ()'s. HELP

After getting Apache, PHP, and MySQL all properly installed, I have since been stymied by an error getting PHP to connect to MySQL. When calling a mysql_connect() the browser displays the following error:
Fatal error: Call to undefined function: () in /public_html/index.php on line 8

Ugh. Haven't found an answer anywhere. Some allusions to php.ini, but nothing concrete. Anyone have any ideas?

It did not work the first time ....
I check the curly brace added a few
echo "<P>$dbh this line is ". __LINE__."</P>";
This way I know which line I am on and I have a MySQL resource.
I see what need to be change
WORK FINE NOW
....
As for the security (once your started)
You should not be using root acess for a web application NEVER
create a new web-user with limited privilige (from localhost) such as select_priv, insert_priv, update_priv.
NO MORE
use a field to indicate if record is active or inactive to the web.
this way if you ever get hack (or in blonde moment) you may get info overload but you wont loose data
save you delete and drop for the comand line and don't forget to back up

As for the textedit/rtf delemma above, Under the FORMAT menu is a command "Make plain text" use that and then save as with the name index.php but don't forget to check the "Hide extension" at the bottom or it will end up saving as index.php.txt.

Now, having saved it correctly, I loaded it and got the following error.


1146: Table 'CONTACT.CONTACT_INFO' doesn't exist

If I go into terminal and the mysql program I get the following, proving it DOES exist:



mysql> show tables;
+-------------------+
| Tables_in_CONTACT |
+-------------------+
| CONTACT_INFO |
+-------------------+
1 row in set (0.00 sec)

mysql> drop database CONTACT;
Query OK, 3 rows affected (0.42 sec)

mysql>




Why can't the browser find it? I installed PHP in /Library/Webserver/ instead of in my home dir. Could that be the reason? Please email me a reply. Thanx..

-Randy

I had installed PHP by following the O'Reilly tutorial. Went back and installed the ver 4.1.1 from entropy.ch and reinstalled the MySQL from same page and all worked fine.

WHEW! Now, I just want to be able to use the examples in the php/MySQL book I just bought, "PHP and MySQL Web Development" from SAMS. Hope it all works....

Thanx for the help!
-Randy

Erik -
You rock! That was a super straight forward tutorial. Could not have been easier.
May good things come your way.
Thank You

Thanks for providing this helpful info.

Just great : It works and I'm happy !!!

I've got PHP/MySQL working beautifully, but am now moving on to the next hurdle: moving data from SQL/Server into my MySQL installation... any ideas?

Hello everyone...

Please reply here if you know how to delete a row or the whole database (with the source code on thsi page)

Thx for replying

Erik, thanks for writing this tutorial. It got me up to speed on using mysql on mac os x.
Ive been using mysql on a linux server and now I can run it locally on my machine.
woohoo!

Excellent intro to the complexities of PHP/MySQL.
My colleague was trying to go back to ASP/MSAccess but thanks to this site I think she is convinced!

I've attempted to install MySQL but I can't seem to connect to the server. When attempting to connect I recieve: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

The MacOS X machine is a LAN client and does not have it's own domain other than localhost.

Any thoughts would be GREATLY appreciated.

Thanks,
Alex

Is there any updated tutorials out there explaining how to pass variables from a form to your database using $_POST ..?

the solution to this error:

[localhost:~] hoffj% sudo mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

which occurs on the command line, is NOT to do this:

$dbh = mysql_connect("localhost","root","your_password");

which you would do from a script, but rather, to do this (from the commandline):

mysql -u root -pmypassword

where root is the root mysql database user, not the system's superuser, and mypassword is the password you set for that root mysql database user.

note that there is NO space between the -p password option and the password itself.

you enter that command as an ordinary user. no su or sudo required.

This is very cool. But I am having trouble getting dreamweaver mx to see my database. Does anyone know the proper way to configure this?

gracias

I have followed these instructions below, but cannot connect to MYSQL.

Installed 3.23.51.pkg.tar.gz
Create user
Name: "MySQL User"
Short Name: "mysql"
Password:*******
type "cd /usr/local/mysql"
type "sudo ./scripts/mysql_install_db", enter administrator
type "sudo chown -R mysql /usr/local/mysql/*"
type "sudo ./bin/safe_mysqld --user=mysql &"
Use it with "mysql test"
and get the error "ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
Tired this command
"cd /usr/local/mysql; sudo ./bin/safe_mysqld --user=mysql &"
-same error
I must be missing something wrong, help?

I have followed these instructions below, but cannot connect to MYSQL.

Installed 3.23.51.pkg.tar.gz
Create user
Name: "MySQL User"
Short Name: "mysql"
Password:*******
type "cd /usr/local/mysql"
type "sudo ./scripts/mysql_install_db", enter administrator
type "sudo chown -R mysql /usr/local/mysql/*"
type "sudo ./bin/safe_mysqld --user=mysql &"
Use it with "mysql test"
and get the error "ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
Tired this command
"cd /usr/local/mysql; sudo ./bin/safe_mysqld --user=mysql &"
-same error
I must be missing something wrong, help?

I used Marc Liyanage's instructions to install mysql onto Jaguar 10.2 build 6c106. While the command line 'mysql' tool didn't work (errors with libraries), the daemon seemed to run. I poked around a bit for a simple php-based test, and voila! Thanks much Erik! And to all you Jaguar users - never fear, php is fine, but no cli for now =(

I created a discussion forum with php4 and mysql. That text is mixed up if I don't type tags like . How should I fix the problem? I appreciate for your help.

Hi, I downloaded a guestbook from http://php.inc.ru and configured everything, you can see it here http://200.46.150.15/~sku/evidelio/guestbook/gb.php

the thing is, when i try to add an entry to the guestbook, nothing happens, the page processes something and nothing happens. I cheked the MySQL database to see if something was written on it, but nothing was passed on to the database.

I mannually added an entry from withing Mac OS X's Terminal into the database, and that is the only one that shows up.

What gives? any suggestions??

Thank you for this helpful information!
As a web-and starting database developer, I want to learn as fast as possibe: time is money and this example got me up to speed.

Thanks!

Peter

create database CONTACT' at line 1
mysql> create database CONTACT;
ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT'
mysql>

what's wrong please hepl me.. wanne use mysql on a mac !!

In entropy's php 4.2.3 for Jaguar, there isn't a php.ini file that you would use to configure options. Does anyone know how to get around this?

Hi,

as fo many of us i can't connect to mysql trhough socket when configured ad a LAN client.

What I would greatly appreciate is an explanation of what is going on.

Tks

I got it to work by changing the $dbh statement as follows:

$dbh = mysql_connect("127.0.0.1","root","password");

Now all is well. Hope this helps those who are having connection problems.

Probably it's due to my lack of knowledge in Unix.
PHP works fine but mysql is a pain in the a.

Most of the time I get te warning:ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Or mysql is alraedy started. Or cannot find mysql server.

This is what I got now in the terminal:

[ovpserv3:/usr/local/mysql] mysql% sudo mysql
Password:
dyld: ./bin/mysql Undefined symbols:
./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib
./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib
./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib
Trace/BPT trap

I am actually a Filemaker user and this seems to me a giant step back into the stone age. Unfortunately I am forced to use mysql.

Anyone has a hint ?

Well, I get this for a start:
1146: Table 'CONTACT.CONTACT_INFO' doesn't exist

Also, when I type in the terminal, mysql, as my normal user, it all runs fine, as root it does not let me in.
I can use yourSQL, when I type mlee into the user field, and leave the login field blank. Surely this cannot be secure.
Help, please!!!

i hit index.php from IE
and see the following which I open index.php

", $first_name, $last_name, $phone); } ?>

any ideas?

tia
great tutorial

to the guys getting the lib errors: you need to get the latest version of MYSQL. The one you are running is for Jaguar 10.1.

If you use the up to date entropy packages you literally can't go wrong.
;o)

ps.. check out cocoaMYSQL for database management.

Thanks for a great tutorial!

I need to set up a link between an MSAccess datatbase (on PC of course) and the MySQL database now running sweetly on my Mac.

I have to transfer data from Access to MySQL not the other way (at least for now).

How do I do this? I have heard of ODBC but have no experience using it. Any help very gratefully received.

Super tutorial! Worked beautifully once I got past the need for the root password. For the time being I am coding it into the 3rd param of the connect statement. Something more secure to follow.
Thanks!

I have spent two works trying to get php and mysql communicating with each other, working thru every stage, learning how to use terminal, finding out about .conf files etc.etc. and still I couldn't get them talking.5 minutes on this page and a copy here and a paste there and bingo it's done! Thank you very much!

Sorry, but nothing in this forum proved useful. :(

I got error 1045 as well, and there isn't a single damned post here that helps deal with it.

Would somepne please lucidly describe precisely what this error means, and what precisely can be done to alleviate it, short of deciding that MySQL is a lousy product and abandoning it entirely?

I cannot get php and mySql to communicate with each other. Do I need to do something in the apache web server?

Please advise, thanks in advance.

Hi! I found a solution to this at Marc liyanages homepage:

(with a little change as I used serverlogistics mysql)

http://www.entropy.ch/software/macosx/mysql/
"Database Re-Initialization
Sometimes the scripts in the installer package do not work correctly, preventing the startup of the database server. Sometimes you need to reinitialize for other reasons, when the database is too screwed up. So if you have problems and you want a fresh start, perform these steps manually and then try again to start the server:
1. sudo find /usr/local/2. mysql/data -type f -exec rm {} ';'
3. sudo hostname 127.0.0.1
4. cd /usr/local/mysql
5.

here I made a change: my "mysql_install_db was inside "bin" and not "scrpits": si I exchange it! Which makes it this

I already installed all following the instructions and all is perfect!! running on OSX 10.4.2, ibook G4.

How do I get a page that has a gallery, which works great on localserver, on to my site. Do I copy and paste the whole script or just use links. When I go to browser it says page not found. Or,.. what the hell. Does anyone know or could tell me exactly...how to set up my dynamic site that's probably the problem. Maybe??? Somebody help me!!!!!!!!!!!!Please, deadline, and I don't know what I am doing.....so much for trying to get creative. eh?

solved the problem by modifying to this:

$dbh = mysql_connect("127.0.0.1","root","");

solved the problem by modifying to this:

$dbh = mysql_connect("127.0.0.1","root","");

and changing the "mysql_create_db($database_name)" to "mysql_query("CREATE DATABASE $database_name"