Installing Apache + PHP + MySQL


Recommended Posts

hi all :)

I have one question about MySQL. When I am installed it, I have already some users. There are: "@%", "@localhost", "root@%", "root@localhost". What is this means? :huh:

Can I make only 1 user with all privileges?

post-107-1095335600.jpg

Edited by RaiderOnline
  RaiderOnline said:
hi all :)

I have one question about MySQL. When I am installed it, I have already some users. There are: "@%", "@localhost", "root@%", "root@localhost". What is this means? :huh:

Can I make only 1 user with all privileges?

The format is this: user@hostmask

"%" is a wild card. A blank username and a wildcard after the "@" means that "@%" is an anonymous user that can connect to your server from any host. I'd advise deleting the account. I'd advise deleting the anonymous user that can connect from localhost too. So, delete "@localhost" also.

"root@%" Means that root can connect from any host. You may or may not want this. Consider allowing root to connect from localhost only, or only from a box on the LAN. For example:

"root@192.168.0.%"

I would advise you to create a user for your own use, with priviledges granted for specific databases only.

  • 1 month later...
  Jervous said:
Is there a way to do the same thing for PHP 5?

584883037[/snapback]

I don't recommend using PHP5 to any novice users, as the only feature that catches my eye is very good OOP support. But, just change the code in httpd.conf to:

LoadModule php5_module "C:/PHP/php5apache2.dll"
AddType application/x-httpd-php .php

and copy php5ts.dll to your C:\WINDOWS\system32 directory.

PHP 5 is actually better to start learning now, as it is still in an early age, so by the time you have learned some of the things needed in scripts a stable release will be out and you can.

Also, since you install PHP, you want Apache to recognize index.php and make it the first page you see when you visit the directory, so you would have to do this aswell:

Open C:/Apache2/conf/httpd in Wordpad or Notepad or whatever you use and find:

DirectoryIndex

and after that you have to add

index.php

If you use home.php or something different just add home.php, etc.

  vhane said:
The format is this: user@hostmask

"%" is a wild card. A blank username and a wildcard after the "@" means that "@%" is an anonymous user that can connect to your server from any host. I'd advise deleting the account. I'd advise deleting the anonymous user that can connect from localhost too. So, delete "@localhost" also.

"root@%" Means that root can connect from any host. You may or may not want this. Consider allowing root to connect from localhost only, or only from a box on the LAN. For example:

"root@192.168.0.%"

I would advise you to create a user for your own use, with priviledges granted for specific databases only.

584575295[/snapback]

wow :woot: thanks :D Now I can understand all this stuff :p

  • 3 weeks later...

Somehow it does not work for me...apache works fine....then on to step 2 PHP .... i cant'get that to work...

I did all that is listed in the guide

get this error

LoadModule takes two arguments, amodule name and the name of a shared object file to load it from

Edited by DrRip
  • 2 weeks later...
  • 1 month later...

Nice tutorial!!!

Although after i downloaded the php (installer exe) i found that none of the directories such as sapi and files such as php.ini-recommended were in the c:\php directory so i just downloaded the Zip file and extracted it in and all was well.

Thanks again!

  • 4 weeks later...
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Using NASA’s IXPE telescope and a fleet of observatories, scientists discovered that the system’s intense X-rays don’t come from its glowing accretion disk as previously believed, but from a chaotic, high-speed wind of particles hurled out by the pulsar itself. The findings challenge old models and reveal a single, powerful mechanism behind the pulsar’s radiation. It’s a dramatic twist in our understanding of how dead stars can still light up the universe. A global team of astronomers has made a significant discovery about how the energetic remains of exploded stars interact with the space around them. Using NASA’s IXPE (Imaging X-ray Polarimetry Explorer) along with several other observatories, researchers gathered new insights into this dynamic cosmic behavior. The scientists, working across the United States, Italy, and Spain, focused their investigation on a puzzling stellar system known as PSR J1023+0038, or simply J1023. This system features a rapidly spinning neutron star that draws material from a smaller companion star. As a result, an accretion disk of matter has formed around the neutron star. The neutron star also functions as a pulsar, emitting intense beams of radiation from its magnetic poles as it spins, creating a pattern that resembles a lighthouse sweeping through space. What makes J1023 especially important is that it switches between two distinct phases. https://scitechdaily.com/nasa-just-discovered-where-these-mysterious-space-x-rays-really-come-from/    
    • Artifacts from the Iron Age have revealed an intense historical magnetic anomaly in the Middle East. Could using a similar approach elsewhere help us unravel the mysteries of Earth's magnetic field? Ben-Yosef, an archaeologist at Tel Aviv University, had been working in southern Jordan with Ron Shaar, who was analyzing archaeological materials around the Levant. Shaar, a geologist at The Hebrew University of Jerusalem, was building a record of the area's magnetic field. The hunk of copper slag — a waste byproduct of forging metals — they found recorded an intense spike in Earth's magnetic field around 3,000 years ago. Shaar worked hard to give them more evidence. After they had analyzed and described samples from around the region for more than a decade, the anomaly was accepted by the research community and named the Levantine Iron Age Anomaly (LIAA). From about 1100 to 550 B.C., the magnetic field emanating from the Middle East fluctuated in intense surges. https://www.livescience.com/archaeology/earths-magnetic-field-is-weakening-magnetic-crystals-from-lost-civilizations-could-hold-the-key-to-understanding-why
    • Designed by former F1 engineers. Pure danger. A company made up of former F1 racing engineers has unveiled an outrageous e-scooter that can reach a top speed of north of 100 miles per hour — and covers a whopping 150 miles on a single charge. The bizarre contraption, dubbed The Turbo, was developed by UK-based e-scooter company Bo, whose existing lineup targets the more premium end of the last-mile — or last 150 miles, in this case — mobility market. The Turbo's specs are borderline hard to believe. The metal-clad and girthy two-wheeler features a 24,000-watt dual-motor engine and an enormous 1,800-watt-hour battery. Aerodynamic air intakes funnel wind to keep everything cool. https://futurism.com/the-byte/100-mph-escooter-hazard    
    • Apple was waiting for Samsung to refine the technology. Now, they will ask Samsung to make their screen. Amazing...
  • Recent Achievements

    • Rookie
      Snake Doc went up a rank
      Rookie
    • First Post
      nobody9 earned a badge
      First Post
    • One Month Later
      Ricky Chan earned a badge
      One Month Later
    • First Post
      leoniDAM earned a badge
      First Post
    • Reacting Well
      Ian_ earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      495
    2. 2
      Michael Scrip
      203
    3. 3
      ATLien_0
      197
    4. 4
      Xenon
      136
    5. 5
      +FloatingFatMan
      116
  • Tell a friend

    Love Neowin? Tell a friend!