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

    • Apple is giving the upcoming iPad Pro a second front-facing camera by Taras Buria The M4-based iPad Pro brought a few significant changes to Apple's high-end tablet, such as tandem OLED displays, a much-thinner chassis, camera changes, and a much more powerful processor. Its successor, the M5-based iPad Pro, is rumored to retain the current form factor without major changes. However, there is one rather odd hardware update that is coming with the next iPad Pro. A new report says that a successor to the current iPad Pro lineup will offer a more powerful Apple M5 processor and more cameras on the front. While Apple experimented with a dual-camera setup on the back of the recent iPad Pros (this was killed in the M4 generation), the front of every iPad has always had a single camera, minus the original one, of course, which had none. With the M5 iPad Pro, Apple is rumored to double the number of front-facing cameras for a rather odd reason. No, Apple is not using a dual-camera setup for depth of field effects or a wider angle. According to Bloomberg's Mark Gurman, the logic is much simpler: satisfy fans of the portrait orientation. The problem is that in the 2024 iPad Pro, Apple moved the front-facing camera to the longer side of the tablet, where it makes much more sense for FaceTime calls, selfies, and everything else. However, that makes the iPad a bit awkward to use when in portrait mode, especially when it comes to FaceID. Now, it appears that Apple wants to make both camps happy by adding another front-facing camera to the shorter side of the screen. There is no information on whether we will see just one more front-facing camera or the entire FaceID module. Given Apple's nature of blaming users for some of its device shortcomings (the infamous "you are holding it wrong" line), it is quite interesting to see Apple addressing a seemingly minor concern with such an overkill solution.
    • Hello! It's default behavior. I assume that F:\ and E:\ are external drives? My local drives are under This PC. So File Explorer is showing storage from different locations: This PC (under which are local drives) Mapped Network drives External USB drives The Network (under which, my NAS) You could drag the drive to Quick access to see it all the time, but in my case when I expand This PC, the local drives remain in view even when I close and reopen the window.
    • It also lost Window Share support, so can no longer share websites from Edge to it or files from Explorer using the Share button or photos from Photos app. Mind you, not that this is impossible from a webappp since the new Outlook does support Share and that's a web app.
    • Was that just a warning about malware in general, or is there a list of malware that's proven to affect a computer outside a sandbox/vm?
    • One of the best file managers for Windows 11 gets brand-new Omnibar and more by Taras Buria Files is a popular file manager for Windows 10 and 11, and it is one of the best alternatives to the stock File Explorer. The app is packed with features, it looks fantastic on Windows 11, it is free, and it regularly receives feature updates. The latest preview update, version 3.9.12, introduces some big changes to the address bar, search, and filtering. With Files Preview 3.9.12, the app is getting the new Omnibar. It is a new control that works the same as your browser's address bar. It combines the "breadcrumb" path and the search box into a single UI element. By default, the new Omnibar displays breadcrumbs, which are the current path to the folder with quick access to each directory in the path and their nested folders. Besides the visual overhaul, the new Omnibar introduces a new Home button with a dedicated flyout that lets you navigate to quick access items, drives, and other elements. You can click the new Omnibar (or press Ctrl + L) to edit or copy the current path, paste a new address or navigate to another folder by typing its location. The Omnibar also now hosts the Command Palette, which you can trigger by pressing Ctrl + Shift + P. With the Omnibar, Files no longer uses a dedicated search bar. You can search for files by pressing Ctrl + F or clicking a search button in the omnibar. It is also worth noting that developers changed how filtering works. Now, Files has a dedicated filter UI instead of defaulting to filtering items when typing in the search box. It works faster and it is more intuitive. Other changes in Files Preview 3.9.12 include OX Drive integration and partial RTL support. You can download Files Preview 3.9.12 from the official Files.community website. If you want to support developers, you can purchase the preview version from the Microsoft Store.
  • 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
      497
    2. 2
      Michael Scrip
      206
    3. 3
      ATLien_0
      201
    4. 4
      Xenon
      136
    5. 5
      +FloatingFatMan
      117
  • Tell a friend

    Love Neowin? Tell a friend!