--- In php-list@yahoogroups.com, "misender" <[EMAIL PROTECTED]> wrote:
>
> Hi, I'm beggining on PHP Programming and I'd like to know how to work
> offline. I downloaded the WAMP 5, but I don't know how to use it.
> After choosing "Start All Services", it shows on mouse over the icon
> "WAMP5 - server offline".
>
> Thanks,
> Michel
>
Hi Michael
I recently installed Wamp5 (but only on Virtual PC, for testing
purposes) and I too misunderstood what "WAMP5 - server offline" meant
at first.
First when you see the yellow pop which says "WAMP5 - server offline",
what this means is that Wamp5 (apche server, php and mysql) are all
running, but that only users on your computer can view pages served
from your web server (apache).
Secondly the "offline" bit is a bit misleading for us nOObs, but is
perfectly understandable once you get to grips with programming
jargon. It's actually a microcrap (Microsoft) term and you would often
see it when attempting to make a new ISP connection, back in the old
days of pre-broadband. Microcrap still use it in all their software to
mean "not connected to the Internet".
So do not change your server to "online" (as Pete Clark said) because
this would mean that anyone from the internet (if they happened to
hack your computer) could access your web server and whilst you are
learning, this is definately not a good thing to do.
----------------------------------------------------------------------
I think that being slightly paranoid when it comes to security is
always a good thing, so my personal advice is leave Wamp5 "offline".
----------------------------------------------------------------------
If you just click on the Wamp5 icon in the systray (with "WAMP5 -
server offline") and then click on "localhost", your current (default)
homepage will open in your (default) web browser and you should see
the following text:
Server Configuration (in big bold letters"
and then below that on the left you should see:
Apache Version : 2.2.6
PHP Version : 5.2.5
Loaded Extensions : (list of the PHP extensions on right)
then
MySQL Version : 5.0.45
And then;
Tools (in big bold letters)
phpinfo()
phpmyadmin
sqlitemanager
Your Projects (in big bold letters)
No projects yet.
To create a new one, just create a directory in 'www'.
Your Aliases (in big bold letters)
phpmyadmin
sqlitemanager
If you see all this (with Wamp 5 saying "WAMP5 - server offline"),
then all is well in the land of Michaels new Wamp and you should go
ahead and create your first PHP pages, or download some from the internet.
----------------------------------------------------------------------
Creating A MySQL "root" Password
----------------------------------------------------------------------
When you come to the time when you need to create your MySQL root
password, use "phpmyadmin" to do so, but bear in mind that you must
also change the password in the phpmyadmin "config file", located at
"C:\wamp\apps\phpmyadmin2.10.1\config.inc.php", otherwise you will get
an error and won't be able to load phpmyadmin anymore.
----------------------------------------------------------------------
Create the MySQL password first using "phpmyadmin".
----------------------------------------------------------------------
To create a MySQL root password (and a new user and password too) just
click on the "phpmyadmin" link (at the bottom of your current homepage
on localhost, in your web browser) and select the MYSQL database.
Then navigate to the "user" table and then click on the "INSERT" tab
(near the top of the page) and you can now enter a password for the
"root" user.
If I was you, I would create a screenprint of this "Insert" page with
the root user information, both for creating a second user (who
doesn't have root privileges, read the MySQL manual for more info on
this) and for future reference, in case you need to reinstall any
wamps on your computers.
----------------------------------------------------------------------
Adding the MySQL root password to the "phpmyadmin config file",
location at "C:\wamp\apps\phpmyadmin2.10.1\config.inc.php".
----------------------------------------------------------------------
The actual line in your "phpmyadmin config file" you need to change is:
$cfg['Servers'][$i]['password'] = ''; // MySQL password
(only needed
// with 'config' auth_type)
Add your new password to this bit, in between the two single quotes.
= '';
Example
= 'D7Js2kCbHmo0R';
Use something complicated like I have done in the above example and
don't worry if you won't be able to remember it, because once you
learn a little about php and include files, you will be able to create
a single connection file to use for all your MySQL dB connections.
----------------------------------------------------------------------
I hope this helps.
Joseph
