Welcome to the MacNN Forums.

simonmartin · Mar 22, 2003, 05:41 PM

Hi,

I'm in way over my head here...

I'm trying to get a shared calendar running on my box to be shared with my wife on our internal network.

I have php and mySQL running, apparently, having followed the instructions on Marc Liyanage's site <http://www.entropy.ch/home/welcome.html>.

So far so good...

I thought I'd have a go at installing phpmyAdmin as well as I have no clue about using mySQL.

From the installation instructions:

1)"Untar or unzip the distribution (be sure to unzip the subdirectories): tar -xzvf phpMyAdmin_x.x.x.tar.gz in your
webserver's document root"

In Mac-speak, is my "webserver's document root" my 'Sites' folder?
If not where is it?
Is it Ok to have the contents of the unpacked download inside a folder or do all the resulting documents have to be rattling around in the 'Sites' folder?

2) "Open the file config.inc.php3 in your favourite editor and change the values for host, user, password and authentication mode to fit your environment. Here, "host" means the MySQL server. Also insert the correct value for $cfg['PmaAbsoluteUri']. Have a look at Configuration section for an explanation of all values."

I'm afraid I don't have the faintest idea what that paragraph is on about...

Hope a generous person can help me out.

Many thanks

Simon
London Uk

philzilla · Mar 22, 2003, 06:10 PM

1. /Library/WebServer/Documents

2. host: localhost, $cfg['PmaAbsoluteUri']: http://127.0.0.1/phpMyAdmin_x.x.x

simonmartin · Mar 23, 2003, 12:54 AM

Originally posted by philzilla:
1. /Library/WebServer/Documents

2. host: localhost, $cfg['PmaAbsoluteUri']: http://127.0.0.1/phpMyAdmin_x.x.x

philzilla,

Thanks for that! I *think* I understand...

In 1) I can have a folder called 'phpMyAdmin_x.x.x', in there , yes?

In 2) The only thing I added was 'phpMyAdmin_x.x.x' as everything else seemed to say it could be left blank...?

Now how do I start it up?

Thanks

Simon

simonmartin · Mar 23, 2003, 04:15 AM

Originally posted by philzilla:

2. host: localhost, $cfg['PmaAbsoluteUri']: http://127.0.0.1/phpMyAdmin_x.x.x [/B]

philzilla

Should that be <http://127.0.0.1/Library/Webserver/D...pMyAdmin-2.4.0> ?

Simon

philzilla · Mar 23, 2003, 04:20 AM

Originally posted by simonmartin:
Should that be <http://127.0.0.1/Library/Webserver/Documents/phpMyAdmin-2.4.0> ?

no, it shouldn't. you can just name the directory phpMyAdmin, it's easier. then you just aim for 127.0.0.1/phpMyAdmin in your browser

as for starting it up, if you've configured it properly, it should work. we're all assuming mysql is installed & working on your mac... right?

simonmartin · Mar 23, 2003, 04:22 AM

Originally posted by simonmartin:
philzilla

Should that be <http://127.0.0.1/Library/Webserver/D...pMyAdmin-2.4.0> ?

Simon

philzilla,

Sorry, you were of course right.

phpMyAdmin-2.0.4 has a <->, not a <_> which is why the cut and paste I did from your message didn't work.

I have some life in the thing now!

Still have no idea what I'm doing...

Thanks again

Simon

simonmartin · Mar 23, 2003, 04:31 AM

Originally posted by philzilla:
no, it shouldn't. you can just name the directory phpMyAdmin, it's easier. then you just aim for 127.0.0.1/phpMyAdmin in your browser

as for starting it up, if you've configured it properly, it should work. we're all assuming mysql is installed & working on your mac... right?

philzilla,

I'm sorry, I won't turn this in to a one-to-one tutorial, promise... :-)

The thing fired up and I wanted to change the root password. I ticked the box 'Change Password' entered in the password twice. Got a message confirming that the change had been made. Then when I tried to go back to the original page I got:

<Error

MySQL said:

Access denied for user: 'root@localhost' (Using password: NO)>

Any ideas?

Thanks mate!

Simon

simonmartin · Mar 23, 2003, 04:42 AM

philzilla,

I got back in by changing the Authentication method to 'cookie', someone on the sourceforge page of phpMyAdmin had had the same problem.

I'll battle on! Thanks for your help!

Simon

redJag · Mar 23, 2003, 07:04 PM

I'm not sure about the exact sytanx, but if you change the authentication method to HTTP (I think that is right..) then it will popup a box asking for user name and password. This way you can enter it, tell your browser to remember, and if you change it later down the road it will popup saying you gave it the wrong password and you can change it.