I have PHP running on my machine in Mac Tiger. I can do
elementary things like includes. But I now want to learn about
how to get a simple database going, how to maintain it.

There is a program, I understand, called MySQL. And that it is a
good idea to have it and install it and learn how to use it. Any
Mac people out there that can start me off with very specific
info, however short, on how to begin this quest of mine.

I don't even know if I have it? I don't think so. And it seems
not to be obviously on my OS DVD. I recall doing things like
removing comments in files in the library to turn on PHP. And I
know there is a test for whether PHP is running. Is there a test
for mySQL?

I also know there are a lot of tutes out there. For some reason,
an actual human is sometimes helpful to begin with.

--
dorayme

> I don't even know if I have it? I don't think so. And it seems
> not to be obviously on my OS DVD. I recall doing things like
> removing comments in files in the library to turn on PHP. And I
> know there is a test for whether PHP is running. Is there a test
> for mySQL?

from command line you can try something like
!> whereis mysql
to find out if you have at least the mysql client (command line) installed


> I also know there are a lot of tutes out there. For some reason,
> an actual human is sometimes helpful to begin with.
>
> --
> dorayme


http://developer.apple.com/internet/opensource/osdb.html
General Installation and configuration infos from apple
http://dev.mysql.com/doc/refman/5.1/en/mac-os-x-installation .html

http://www.mamp.info/
An easy way to install apache/mysql/php on Mac Osx


Regards

L. A. Iarrusso

In article <45cd48f6$0$25473$4fafbaef [at] reader3.news.tin.it>,
"www.j2be.com" <info [at] [nospam[j2be.com> wrote:

> > I don't even know if I have it? I don't think so. And it seems
> > not to be obviously on my OS DVD. I recall doing things like
> > removing comments in files in the library to turn on PHP. And I
> > know there is a test for whether PHP is running. Is there a test
> > for mySQL?
>
> from command line you can try something like
> !> whereis mysql
> to find out if you have at least the mysql client (command line) installed
>

Seems I have not got it. Thanks
>
> > I also know there are a lot of tutes out there. For some reason,
> > an actual human is sometimes helpful to begin with.
> >

> http://developer.apple.com/internet/opensource/osdb.html
> General Installation and configuration infos from apple
> http://dev.mysql.com/doc/refman/5.1/en/mac-os-x-installation .html
>
> http://www.mamp.info/
> An easy way to install apache/mysql/php on Mac Osx
>
>
> Regards
>
> L. A. Iarrusso

Did you install mySQL on your Mac? Which route did you take?
Given I have a server installed and php on my machine, Tiger and
I want mySQL, what should I press at the last url you give?

--
dorayme

In article
<doraymeRidThis-9716A4.12283511022007 [at] news-vip.optusnet.com.au>,
dorayme <doraymeRidThis [at] optusnet.com.au> wrote:

Is there a Mac equivalent to the sort of treatment one finds at

<http://www.webdevelopersnotes.com/tutorials/sql/mysql_database_in
troduction_mysql_beginners_tutorial.php3>

where the author talks about Windows and Linux? Or can it be
taken that the Linux instructions are the same (it really is no
good if it is not, because then one has to figure out what the
differences are and that means going elsewhere).

--
dorayme

In article
<doraymeRidThis-1F3292.15220511022007 [at] news-vip.optusnet.com.au>,
dorayme <doraymeRidThis [at] optusnet.com.au> wrote:


I have PHP installed on my Mac Tiger and it works fine. It is
version 4.4.1

In my efforts to understand and work with a database, I have now
downloaded a mysql-standard-5.0.27-osx10.4-powerpc.pkg.

To tell whether one has php installed (apart from seeing if
includes and stuff are working, there is a simple test: run a
phpInfoPanels.php file from the server in which the only text is:

<?php phpinfo() ?>

My question is this: what, please, is as simple a way to tell if
the installation of MySQL is successful?

Doubtless the question reveals ignorance! But that is how it is
and I am trying to cure it. I am not even sure of the very nature
and logic of what I have installed. I have got as far as vaguely
understanding that this database direction involves both

(a) A database server (some sort of software that somehow stores
and controls and serves or delivers things databasewise)

and

(b) A "client" program which enables one to communicate with this
server so one can make new databases, change old ones and
generally geek away and stay young.

So I have installed the package. What now, there are no whistles
or flags or jumping gifs when I go to a page I made that gives a
menu of my sites on my server. For all the world this corner is
as quiet as before I installed the package. I would appreciate a
hint of what to do next that promises to turn on some practical
light for me.

--
dorayme

Post removed (X-No-Archive: yes)

In article <eqt1dh01ob [at] drn.newsguy.com>, Tom <tom [at] to.com> wrote:

> On Mon, 12 Feb 2007 11:30:34 +1100, dorayme wrote...
> >
> >In article
> ><doraymeRidThis-1F3292.15220511022007 [at] news-vip.optusnet.com.au>,
> > dorayme <doraymeRidThis [at] optusnet.com.au> wrote:
> >
> >
> >I have PHP installed on my Mac Tiger and it works fine. It is
> >version 4.4.1
> >
> >In my efforts to understand and work with a database, I have now
> >downloaded a mysql-standard-5.0.27-osx10.4-powerpc.pkg.
> >
> >To tell whether one has php installed (apart from seeing if
> >includes and stuff are working, there is a simple test: run a
> >phpInfoPanels.php file from the server in which the only text is:
> >
> ><?php phpinfo() ?>
> >
> >My question is this: what, please, is as simple a way to tell if
> >the installation of MySQL is successful?
> >
> >Doubtless the question reveals ignorance! But that is how it is
> >and I am trying to cure it. I am not even sure of the very nature
> >and logic of what I have installed. I have got as far as vaguely
> >understanding that this database direction involves both
> >
> >(a) A database server (some sort of software that somehow stores
> >and controls and serves or delivers things databasewise)
> >
> >and
> >
> >(b) A "client" program which enables one to communicate with this
> >server so one can make new databases, change old ones and
> >generally geek away and stay young.
> >
> >So I have installed the package. What now, there are no whistles
> >or flags or jumping gifs when I go to a page I made that gives a
> >menu of my sites on my server. For all the world this corner is
> >as quiet as before I installed the package. I would appreciate a
> >hint of what to do next that promises to turn on some practical
> >light for me.
> >
>
> I'm guessing you may need to connect to your MySQL server directly

I would like to do this. My question (not quite grammatically put
above) was: "what, please, is a simple a way to tell if the
installation of MySQL is successful?


> and create
> the database you want to use for access with PHP if you hadn't created one
> already.
>
> Once that's in place you can try creating a test PHP page to see if you are
> able
> to connect to that database. Maybe...
>

Thanks for below... but I have not got to that stage.
>
> <?php
>
> $database="database_name";
>
> mysql_connect("localhost", "username", "password");
>
> echo 'Connected successfully';
> mysql_select_db($database) or die( "Unable to select database");
>
> mysql_close();
> ?>
>
>
> Tom

--
dorayme

One simple way to check is to download and install the free software
TextWrangler. You can then select from the file menu "Open hidden"
and browse through the hidden directories on you MacIntosh. You
should find mysql installed in the following location:

/usr/local/

in its own subdirectory. This is also where php is installed.

To test the installation, try logging in from the "terminal" program
by entering the following command at the command line prompt:

mysql -h localhost -u root

(you may need to change directory or provide a bath to the mysql
program, which is also usually at:

/usr/local/mysql/bin/

on a MacIntosh -- the "mysql" in the path is the unix equivalent of an
"alias" in MacIntosh terminology that links to the mysql directory,
which is usually set up by the mysql installation. The "bin" is the
mysql sub-directory where mysql programs are kept.)

When mysql is installed, it installs a user named "root" that is
allowed full access in with no password. If this gets you into the
software you have an installation of mysql. You will know this as the
prompt will change to something like:

mysql:

The next thing you will need to do is to protect your installation by
adding a password to root and establishing any other users you need.

I would suggest that you do this by immediately downloading and
installing the open source software phpmyadmin. It will allow you to
set up mysql tables, change and add users, etc. through a
straightforward interface you can access via your browser.

I would also suggest that you find a good tutorial on mysql and read
the phpmyadmin documentation. The best way to use mysql is to
understand how it works. These are both easy to find on the internet.

I went through a learning curve, trying to get someone to explain
things to me and never really got it until I dug into the
documentation and understood it for myself. Until then, you will just
be following directions, forever vulnerable to things happening that
you don't understand and constant frustration.

--Kenoli

On Feb 13, 4:39 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
> In article <eqt1dh0... [at] drn.newsguy.com>, Tom <t... [at] to.com> wrote:
> > On Mon, 12 Feb 2007 11:30:34 +1100, dorayme wrote...
>
> > >In article
> > ><doraymeRidThis-1F3292.15220511022... [at] news-vip.optusnet.com.au>,
> > > dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
>
> > >I have PHP installed on my Mac Tiger and it works fine. It is
> > >version 4.4.1
>
> > >In my efforts to understand and work with a database, I have now
> > >downloaded a mysql-standard-5.0.27-osx10.4-powerpc.pkg.
>
> > >To tell whether one has php installed (apart from seeing if
> > >includes and stuff are working, there is a simple test: run a
> > >phpInfoPanels.php file from the server in which the only text is:
>
> > ><?php phpinfo() ?>
>
> > >My question is this: what, please, is as simple a way to tell if
> > >the installation of MySQL is successful?
>
> > >Doubtless the question reveals ignorance! But that is how it is
> > >and I am trying to cure it. I am not even sure of the very nature
> > >and logic of what I have installed. I have got as far as vaguely
> > >understanding that this database direction involves both
>
> > >(a) A database server (some sort of software that somehow stores
> > >and controls and serves or delivers things databasewise)
>
> > >and
>
> > >(b) A "client" program which enables one to communicate with this
> > >server so one can make new databases, change old ones and
> > >generally geek away and stay young.
>
> > >So I have installed the package. What now, there are no whistles
> > >or flags or jumping gifs when I go to a page I made that gives a
> > >menu of my sites on my server. For all the world this corner is
> > >as quiet as before I installed the package. I would appreciate a
> > >hint of what to do next that promises to turn on some practical
> > >light for me.
>
> > I'm guessing you may need to connect to your MySQL server directly
>
> I would like to do this. My question (not quite grammatically put
> above) was: "what, please, is a simple a way to tell if the
> installation of MySQL is successful?
>
> > and create
> > the database you want to use for access with PHP if you hadn't created one
> > already.
>
> > Once that's in place you can try creating a test PHP page to see if you are
> > able
> > to connect to that database. Maybe...
>
> Thanks for below... but I have not got to that stage.
>
>
>
> > <?php
>
> > $database="database_name";
>
> > mysql_connect("localhost", "username", "password");
>
> > echo 'Connected successfully';
> > mysql_select_db($database) or die( "Unable to select database");
>
> > mysql_close();
> > ?>
>
> > Tom
>
> --
> dorayme

In article
<1171471338.635781.120390 [at] s48g2000cws.googlegroups.com>,
"kenoli" <kenoli.p [at] gmail.com> wrote:

> One simple way to check is to download and install the free software
> TextWrangler. You can then select from the file menu "Open hidden"
> and browse through the hidden directories on you MacIntosh. You
> should find mysql installed in the following location:
>
> /usr/local/
>
> in its own subdirectory. This is also where php is installed.

Thanks for this. I have BBEdit and yes, MySQL is there.

>
> To test the installation, try logging in from the "terminal" program
> by entering the following command at the command line prompt:
>
> mysql -h localhost -u root
>
> (you may need to change directory or provide a bath to the mysql
> program, which is also usually at:
>
> /usr/local/mysql/bin/
>

Looking at the file system that was opened by BBEdit, it goes:

dorayme's Power Mac G4/usr/local/mysql/

and there are all sorts of things from there. The mysql folder is
an alias as I can see by the little curved arrow in the icon. So,
given this info, what exactly am I to type into Terminal please?

> on a MacIntosh -- the "mysql" in the path is the unix equivalent of an
> "alias" in MacIntosh terminology that links to the mysql directory,
> which is usually set up by the mysql installation. The "bin" is the
> mysql sub-directory where mysql programs are kept.)
>
> When mysql is installed, it installs a user named "root" that is
> allowed full access in with no password. If this gets you into the
> software you have an installation of mysql. You will know this as the
> prompt will change to something like:
>
> mysql:
>
> The next thing you will need to do is to protect your installation by
> adding a password to root and establishing any other users you need.
>
> I would suggest that you do this by immediately downloading and
> installing the open source software phpmyadmin. It will allow you to
> set up mysql tables, change and add users, etc. through a
> straightforward interface you can access via your browser.
>
I actually do have this as part of a package I downloaded called
MAMP. I had though MAMP would be an easier route to things when I
got a bit lost after previously installing MySql. But for now, I
prefer to do without MAMP. I can download the the open source
software phpmyadmin afresh or borrow it from the MAMP package.


> I would also suggest that you find a good tutorial on mysql and read
> the phpmyadmin documentation. The best way to use mysql is to
> understand how it works. These are both easy to find on the internet.
>

Any recommendations by anyone would be appreciated. The simpler
the better at first.

> I went through a learning curve, trying to get someone to explain
> things to me and never really got it until I dug into the
> documentation and understood it for myself. Until then, you will just
> be following directions, forever vulnerable to things happening that
> you don't understand and constant frustration.

You are undoubtedly right. I think that at least with me, a few
confidence building measures helps, like getting various
ill-understood things to actually work or "do as expected". Much
appreciate your remarks throughout here...
>
> --Kenoli
>
> On Feb 13, 4:39 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
> > In article <eqt1dh0... [at] drn.newsguy.com>, Tom <t... [at] to.com> wrote:
> > > On Mon, 12 Feb 2007 11:30:34 +1100, dorayme wrote...
> >
> > > >In article
> > > ><doraymeRidThis-1F3292.15220511022... [at] news-vip.optusnet.com.au>,
> > > > dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
> >
> > > >I have PHP installed on my Mac Tiger and it works fine. It is
> > > >version 4.4.1
> >
> > > >In my efforts to understand and work with a database, I have now
> > > >downloaded a mysql-standard-5.0.27-osx10.4-powerpc.pkg.
> >
> > > >To tell whether one has php installed (apart from seeing if
> > > >includes and stuff are working, there is a simple test: run a
> > > >phpInfoPanels.php file from the server in which the only text is:
> >
> > > ><?php phpinfo() ?>
> >
> > > >My question is this: what, please, is as simple a way to tell if
> > > >the installation of MySQL is successful?
> >
> > > >Doubtless the question reveals ignorance! But that is how it is
> > > >and I am trying to cure it. I am not even sure of the very nature
> > > >and logic of what I have installed. I have got as far as vaguely
> > > >understanding that this database direction involves both
> >
> > > >(a) A database server (some sort of software that somehow stores
> > > >and controls and serves or delivers things databasewise)
> >
> > > >and
> >
> > > >(b) A "client" program which enables one to communicate with this
> > > >server so one can make new databases, change old ones and
> > > >generally geek away and stay young.
> >
> > > >So I have installed the package. What now, there are no whistles
> > > >or flags or jumping gifs when I go to a page I made that gives a
> > > >menu of my sites on my server. For all the world this corner is
> > > >as quiet as before I installed the package. I would appreciate a
> > > >hint of what to do next that promises to turn on some practical
> > > >light for me.
> >
> > > I'm guessing you may need to connect to your MySQL server directly
> >
> > I would like to do this. My question (not quite grammatically put
> > above) was: "what, please, is a simple a way to tell if the
> > installation of MySQL is successful?
> >
> > > and create
> > > the database you want to use for access with PHP if you hadn't created
> > > one
> > > already.
> >
> > > Once that's in place you can try creating a test PHP page to see if you
> > > are
> > > able
> > > to connect to that database. Maybe...
> >
> > Thanks for below... but I have not got to that stage.
> >
> >
> >
> > > <?php
> >
> > > $database="database_name";
> >
> > > mysql_connect("localhost", "username", "password");
> >
> > > echo 'Connected successfully';
> > > mysql_select_db($database) or die( "Unable to select database");
> >
> > > mysql_close();
> > > ?>
> >
> > > Tom
> >
> > --
> > dorayme

--
dorayme

On Feb 14, 2:06 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
>
> dorayme's Power Mac G4/usr/local/mysql/
>
> and there are all sorts of things from there. The mysql folder is
> an alias as I can see by the little curved arrow in the icon. So,
> given this info, what exactly am I to type into Terminal please?

try enterring:

/usr/local/mysql/bin/mysql -h localhost -u root

This is the full path to the mysql appcommand line application and
should get you to it no matter what directory you are in. If the
users have not been changed since installation, it should get you into
the MYSQL administration program. You can follow commands in a mysql
manual after that. I don't know them well enough to tell you what
they are. The first think you whould do is to set an admin user and
password.

When you install and set up phpmyadmin, I think it either uses the
localhost password or sets one up for itself. After that you can
administer mysql from phpmyadmin, which is quite easy. You can even
set up new users and passwords from there.

--Kenoli

In article
<1171559062.173326.218010 [at] v45g2000cwv.googlegroups.com>,
"kenoli" <kenoli.p [at] gmail.com> wrote:

> On Feb 14, 2:06 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
> >
> > dorayme's Power Mac G4/usr/local/mysql/
> >
> > and there are all sorts of things from there. The mysql folder is
> > an alias as I can see by the little curved arrow in the icon. So,
> > given this info, what exactly am I to type into Terminal please?
>
> try enterring:
>
> /usr/local/mysql/bin/mysql -h localhost -u root

I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)

I will read up a little more I guess. One day I might actually
get some progress.

--
dorayme

On Feb 15, 2:44 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:

> ERROR 2002 (HY000): Can't connect to local MySQL server through
> socket '/tmp/mysql.sock' (2)
>
> I will read up a little more I guess. One day I might actually
> get some progress.
>
> --
> dorayme

Check out this site:

http://www.entropy.ch/software/MacOSx/mysql/

especially the forums. I remember some issue about the way the tmp/
directory is used. It is a directory that is used by a number of
applications for temporary files and there are issues related to
linking to it and automatically deleting files. I wish I understood
this adequately to explain it myself, but I think you will find some
info on this site to help you. I had some trouble at first getting
things working and since then it has all been so stable that I forgot
the original issues.

Liyanage's site was at least once the gold standard for installing
mysql on a Mac.

--Kenoli

Post removed (X-No-Archive: yes)

In article
<1171639033.700541.118960 [at] a75g2000cwd.googlegroups.com>,
"kenoli" <kenoli.p [at] gmail.com> wrote:

> Check out this site:
>
> http://www.entropy.ch/software/MacOSx/mysql/

thanks for this... I did once come across it but I will now look
again.

--
dorayme

On Sat, 17 Feb 2007 01:55:11 +0800, Tom wrote
(in article <er4r5v02pnn [at] drn.newsguy.com>):

> On 16 Feb 2007 07:17:13 -0800, kenoli wrote...
>>
>> On Feb 15, 2:44 pm, dorayme <doraymeRidT... [at] optusnet.com.au> wrote:
>>
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through
>>> socket '/tmp/mysql.sock' (2)
>>>
>>> I will read up a little more I guess. One day I might actually
>>> get some progress.
>>>
>>> --
>>> dorayme
>>
>> Check out this site:
>>
>> http://www.entropy.ch/software/MacOSx/mysql/
>>
>> especially the forums. I remember some issue about the way the tmp/
>> directory is used. It is a directory that is used by a number of
>> applications for temporary files and there are issues related to
>> linking to it and automatically deleting files. I wish I understood
>> this adequately to explain it myself, but I think you will find some
>> info on this site to help you. I had some trouble at first getting
>> things working and since then it has all been so stable that I forgot
>> the original issues.
>>
>> Liyanage's site was at least once the gold standard for installing
>> mysql on a Mac.
>>
>> --Kenoli
>>
>
> Maybe the permission settings on /tmp are too strict and MySQL can't access
> the
> directory to write in it?
>
> Tom
>

no apple fucked up the setup.......

here are my notes to get a working php+ my sql


How to fix Warning: mysql_connect(): Can't connect to local MySQL server
through socket '/var/mysql/mysql.sock'
Apparently, OS X Tiger doesn't allow for PHP MySQL connection out of the box.
You get this:
Warning: mysql_connect(): Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock'
I found the most clear fix here:
/etc/php.ini(.default) looks for mysql.sock in the wrong place... two options
are to make a symbolic link from the right place to the socket...

sudo mkdir /var/mysql
sudo ln -s /private/tmp/mysql.sock /var/mysql/mysql.sock

Or you can update your /private/etc/php.ini (.default) by finding
"mysql.default_socket" and setting it to equal /private/tmp/mysql.sock and
then restart apache with "apachectl graceful"


/etc/httpd/httpd.conf



> <form action=3D"test.php" method=3D"post">
.../..
> I get the following:
>
> Method Not Allowed
> The requested method POST is not allowed for the URL

You might want to actually "activate" your php module (it's not loaded
by default on Mac OS X).
To do so, become root then edit /etc/httpd/httpd.conf and search for:

#LoadModule php4_module libexec/httpd/libphp4.so

change it to:

LoadModule php4_module libexec/httpd/libphp4.so

search for:

#AddModule mod_php4.c

change it to:

AddModule mod_php4.c

save, and restart apache.

patpro

--
http://www.patpro.net/



RECOVER ROOT PASSWORD

server as root without requiring password or by keying in blank password.
However, if you have set the password for root and forget or unable to recall
the password, then you will need to reset the root password for MySQL.
Login as root to the Unix-like (Unix, Linux or BSD) machine with the MySQL
server.
Stop the MySQL server by using either of the following command
#/etc/init.d/mysql stop
Now you need to Start MySQL server without password
# mysqld_safe --skip-grant-tables &
Connect to mysql server using mysql client with the following command
# mysql -u root
Now you should be having mysql prompt
mysql>
Now you need to Setup new MySQL root user password
mysql> use mysql;
mysql> update user set password=3DPASSWORD(=B2newrootpassword=B2) where
user=3D=B9root=B9;
mysql> flush privileges;
mysql> quit
Note: Replace newrootpassword with the new root password for MySQL server.
Flush Privileges is needed to making the password change effect immediately.
Now you need to Stop MySQL Server using the following command
# /etc/init.d/mysql stop
Test Your New Mysql root password
First you need to start mysql server using the following command
# /etc/init.d/mysql start
# mysql -u root -p
Now it will prompt for root password and enter your new root password


also
/etc/php.ini

must have:
register_globals =3D On