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
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:

"[email protected].%"

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

  • 1 month later...
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.

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:

"[email protected].%"

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

    • Quantum Error Correction Validated in Nature: Microsoft and Quantinuum Log 800-Fold Improvement Two years after the original press-release announcement, independently peer-reviewed results published in Nature on June 10, 2026, have confirmed that Microsoft and Quantinuum achieved an 800-fold reduction in quantum error rates on real trapped-ion hardware — the largest gap between physical and logical error rates ever independently validated.    What Quantum Error Correction Actually Does — and Why Breaking Even Is Hard https://www.techtimes.com/articles/318329/20260613/quantum-error-correction-validated-nature-microsoft-quantinuum-log-800-fold-improvement.htm   Quantum Computing Wiring Bottleneck Cracked by HKU Silicon Carbide Chip at Qubit Temperature Engineers at the University of Hong Kong have built the first cryogenic control chip that operates at the same temperature as superconducting qubits — 10 millikelvin, or just one-hundredth of a degree above absolute zero — without generating the heat that has forced every competing approach to park its electronics hundreds of meters of cable away. https://www.techtimes.com/articles/318325/20260613/quantum-computing-wiring-bottleneck-cracked-hku-silicon-carbide-chip-qubit-temperature.htm  
    • RevPDF 4.5.0 by Razvan Serea RevPDF is a free, fully offline PDF editor for Windows, macOS, and Linux that lets you edit text and images directly inside PDF files — no internet connection, no account, and no cloud uploads required. Unlike bloated alternatives that demand subscriptions and constant connectivity, RevPDF fits in under 60MB on desktop while delivering a complete editing toolkit: annotate, redact, sign, compress, split, merge, convert, and reorganize pages, all processed locally on your device. Smart font matching ensures edited text blends seamlessly with the original, and multi-language support includes RTL scripts such as Arabic and Hebrew. Where most PDF editors force you to choose between features and simplicity, RevPDF manages both. You can build interactive forms from scratch with text fields, checkboxes, and dropdowns, permanently redact sensitive data before sharing, draw freehand on contracts and diagrams, and add custom watermarks — all without a single file leaving your machine. Edit Text and Images Directly Inside PDFs RevPDF supports true inline PDF editing — not just annotation layers on top of a document, but actual modification of existing text and images within the file. A smart font-matching engine identifies the font used in the original document and applies it automatically when you make edits, so changes blend naturally with the surrounding content. You can reposition elements, resize images, and update text across single pages or entire documents. RevPDF 4.5.0 release notes: This is one of the biggest updates to RevPDF yet. A lot of things people have been asking for are finally here. New Features Auto Redaction Permanently redact sensitive text and areas from your PDFs before sharing. Clean, irreversible, and fully offline. Comments, Links & Bookmarks Add comments for review, insert clickable links, and create bookmarks to jump around long documents without scrolling forever. Find & Replace Search across the whole document and replace text in one go. Long overdue. Split Pages Vertically or Horizontally Split any page down the middle, vertically or horizontally. Perfect for scanned books or double-page spreads. New Drawing Tools More tools for freehand drawing and markup, better for annotations, sketches, and detailed notes. Continuous Scrolling in Editor The editor now scrolls continuously through pages instead of jumping between them. Working through long documents is a lot smoother now. PDF Metadata Editor View and edit the metadata stored inside your PDFs, including title, author, subject, and keywords. Better Font Matching Text edits now blend in more naturally by doing a better job of matching the original font. Tabbed PDF Viewer Open multiple PDFs at once in tabs and switch between them without going back to the home screen. Add Links Insert hyperlinks anywhere in your PDF, to external URLs or to other pages within the document. Share & Print Shortcuts Share or print directly from the editing screen, home screen, and viewer. No extra steps. Minor Updates Paste images directly from clipboard into your PDF New image editing tools for more control over images inside documents Bug Fixes Fixed file saving issues on Windows and Linux Everything still works fully offline. No login, no cloud, no account. Your files stay on your device. Download: RevPDF 4.5.0 | 58.0 MB (Open Source) Links: RevPDF Home Page | Github | Screenshots 1 | 2 Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • Interesting. I'm not using a VPN with my phone. I tried though my home internet (Rogers) and my cellular internet (Telus) and both trigger the dialog above.
    • Three days after Anthropic launched Claude Fable 5 as the most capable AI model it had ever released to the public, the United States government ordered it switched off — and now the company is refunding customers who paid to use a product that vanished almost overnight https://www.techtimes.com/articles/318342/20260613/us-government-pulls-anthropics-fable-5-offline-now-come-refunds-vanished-ai.htm  
    • Microsoft fired the team and replaced them with AI and this is what you get.
  • Recent Achievements

    • Week One Done
      agatameier earned a badge
      Week One Done
    • One Month Later
      agatameier earned a badge
      One Month Later
    • Week One Done
      ssd21345 earned a badge
      Week One Done
    • Contributor
      MarkHughes4096 went up a rank
      Contributor
    • Dedicated
      jordanspringer earned a badge
      Dedicated
  • Popular Contributors

    1. 1
      +primortal
      507
    2. 2
      +Edouard
      175
    3. 3
      PsYcHoKiLLa
      139
    4. 4
      ATLien_0
      90
    5. 5
      Steven P.
      76
  • Tell a friend

    Love Neowin? Tell a friend!