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

    • https://www.windowsdigitals.com/how-to-remove-items-from-right-click-menu-in-windows-11/
    • Ironically, I do have audio engineering experience, but still find the different flavors of VB-Audio's VoiceMeeter (and more advanced options like Banana and Potato) to be a little unintuitive. Yes, I can figure them out, but despite having a UI that looks like an audio mixer, they don't exactly follow typical audio mixing conventions, so it takes a little time to figure out how the software works. Still, I feel like for what you are asking for, VoiceMeeter is a good solution. If you're interested, I could probably create a quick how-to video.
    • If it was not for AI push, you have a point but as I already use notepad++ and I really don’t see the need for all the extras in a damn NOTEPAD… I also disagree real notepad with pen does not offer spell check, so why NOTEPAD app should? you already have free Word online.. if this is what you need.
    • How is it "one of the best file managers in Windows"? It is slow as hell and crashes like it's the offspring of Windows Me
    • Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Shell Extensions\Blocked] "{e2bf9676-5f8f-435c-97eb-11607a5bedf7}"="Share" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Shell Extensions\Blocked] "{e2bf9676-5f8f-435c-97eb-11607a5bedf7}"="Share" [-HKEY_CLASSES_ROOT\*\shellex\ContextMenuHandlers\ModernSharing] Remove that Share text.
  • 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
      205
    3. 3
      ATLien_0
      201
    4. 4
      Xenon
      138
    5. 5
      +FloatingFatMan
      117
  • Tell a friend

    Love Neowin? Tell a friend!