Oops, I should have stated that, after step 11, you need to copy the
phptest.php file into your Sites directory so Apache can see it!!!
On Aug 11, 2006, at 11:25 PM, William Squires wrote:
Ha! just got it to work - had to find the php.ini file first (in /
private/etc). Wasn't there, so:
1) sudo cp php.init.default php.ini
<supply password>
2) sudo chown <your username>:admin php.ini
3) chmod 755 php.ini
4) pico php.ini
<Ctrl-W>mysql.default_socket<Return key>
5) (mine was blank, yours may differ...) change the line to say:
mysql.default_socket = /tmp/mysql.sock <- the location where I
found the 'real' mysql.sock file
6) <Ctrl-O><Return key>
7) <Ctrl-X>
8) chmod 444 php.ini
9) sudo chown root:wheel php.ini
You may also, as a matter of course, check the httpd.conf file to
make sure apache is set up to use php (use <Ctrl-W> in pico to find
the line that has 'php.so' in it. Remove the hash "#" character at
the beginning of the line (if present). There's another place where
you have to be sure it's 'turned on'; these things come in pairs.
10) sudo apachectl restart
and then quit Safari (or other web browser) if running.
11) Using TextEdit, or XCode, create the following 'test' file
named phptest.php
<html>
<head>
<title>MySQL Test</title>
</head>
<body>
<p>Connecting to the database</p>
<?php
$host = 'localhost';
$user = 'root';
$pw = '<your MySQL root password>';
$link = mysql_connect($host, $user, $pw) or die('Could not
connect: '.mysql_error());
echo 'Connected successfully.';
?>
</body>
</html>
12) create a file, .tcshrc (or .bashrc if you prefer bash as your
default Terminal.app shell), and put an alias to /usr/local/mysql/
bin/mysql in there so when you start up Terminal.app, the shell
will start out with a handy alias to the mysql monitor program!
This needs to go at the root of your home folder.
13 from the shell, type 'mysql -u root -p'. If it asks for a
password, hit <Return> as the default install should not have any
password in it. Set the database to 'mysql' with
mysql>use mysql
database changed
mysql>set password for 'root'@'localhost' = PASSWORD('<choose a
handy root password - for MySQL only>')**
Query OK, 0 rows affected (0.00 sec)
mysql>flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>exit
** - This is NOT the same password for the Unix root user under
Darwin (OS X)!!!
14) Exit your command shell, then exit Terminal.app also. Restart
the machine to restart apache, PHP, and the MySQL daemon.
15) Open Safari, and type "127.0.0.1/~<your username>/phptest.php
If all is okay, you should get a message, "Connected
successfully.". If you get an error about "...mysql.sock", then
something above didn't take. Make sure the 'mysql.sock' file really
is in /tmp/mysql.sock, and make sure the php.ini file editing
'took' (if you forgot to do the 'chmod 755...' step above, this'll
happen... Trust me, I did it... unwittingly :) ) Also, try renaming
('mv') the php.ini.default file - it might be interfering somehow.
You'll need to sudo it as it has root ownership.
This for
PHP - 4.4.1
MySQL - 5.0.24
OS X (Tiger) - 10.4.7
seems to work now.. :D
On Aug 11, 2006, at 9:47 PM, Phil M wrote:
On Aug 11, 2006, at 11:54 AM, William Squires wrote:
I'm trying to use PHP to connect to a MySQL database (to which
I have already set up). Individually each works (PHP - ver 4.4.1
and MySQL ver 5.0.24 standard); I can write PHP into an html
page, and I can connect to my MySQL database through the 'mysql'
command from Terminal.app, but I can't get a connection from PHP
to the MySQL database
I don't believe that PHP is capable of accessing MySQL 5.0
databases... has to do with the new password scheme, and the fact
that the MySQL license became too restrictive to continue using
MySQL in future PHP development. In fact, MySQL is not the
default database for PHP 5.0... SQLite is.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
