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

    • They probably mean File Pilot, which this colorful rainbow program can never compete with, because this WinUI crap isn’t made for apps like that. My advice? You should just switch the framework already
    • Scientists uncover bizarre new material that's breaking one of the laws of this Universe by Sayan Sen Image by Ron Lach via Pexels Scientists from the University of Chicago and UC San Diego have discovered a group of materials that behave in surprising ways when put under heat, pressure or electricity. Instead of responding like most materials, these can shrink when heated, expand when compressed, and even bounce back to their original state with the right electric charge. The work focuses on oxygen-redox (OR) materials—types that can help batteries store more energy but typically suffer from stability problems due to structural disorder. In their normal state, the materials follow the usual rules of thermodynamics. But in what's called a “metastable” state, a kind of temporary balance, they behave in reverse. “When heated, the material shrinks instead of expanding,” said Prof. Shirley Meng, senior author of the study published in Nature. This is linked to what’s known as a disorder–order transition inside the material’s structure. The team recorded a negative thermal expansion rate of −14.4(2) × 10⁻⁶ °C⁻¹, which means the material actually contracts when warmed up. This goes against a common theory called the Grüneisen relationship, which usually explains why materials expand with heat. And pressure? Even stranger. When they pushed the material on all sides at levels seen in Earth's tectonic plates, it expanded instead of getting smaller. “Negative compressibility is just like negative thermal expansion,” explained Prof. Minghao Zhang. “If you compress a particle of the material in every direction… it will expand.” They also found that electricity can reset the material’s structure. By tweaking the voltage limits, they recovered almost 100% of the original structure and performance. This has big potential for battery tech, especially electric vehicles (EVs). “When we use the voltage, we drive the material back to its pristine state. We recover the battery,” said Zhang. He added: “You just do this voltage activation… your car will be a new car. Your battery will be a new battery.” The research may lead to materials with zero thermal expansion, helpful in everything from buildings to aircraft. Zhang noted, “Take every single building, for example. You don't want the materials making up different components to change volume that often.” As they move forward, the team wants to understand how redox chemistry can further control these effects and expand practical uses. “One of the goals is bringing these materials from research to industry,” said co-first author Bao Qiu. Their work opens up a new way of thinking about material design, where energy doesn’t just power devices, but reshapes the building blocks themselves. Source: University of Chicago, Nature This article was generated with some help from AI and reviewed by an editor. Under Section 107 of the Copyright Act 1976, this material is used for the purpose of news reporting. Fair use is a use permitted by copyright statute that might otherwise be infringing.
    • "Elon Musk says a kid-friendly 'Baby Grok' is on the way" No kid wants to be a baby anymore. "Kid friendly" I would have named it "Kid Grok"
    • TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 is just $135 by Sayan Sen If you’re juggling gaming consoles, 4K streams and a growing roster of smart devices, the TP-Link Archer GXE75 Tri-Band AXE5400 Wi-Fi 6E Gaming Router is a good option to look at right now, considering the device is currently on sale at just $135 (purchase link under the specs table below). The Archer GXE75 promises up to 5.4 Gbps of throughput across three bands: 574 Mbps on 2.4 GHz, 2402 Mbps on 5 GHz and 2402 Mbps on 6 GHz (HE160 channels enabled). A 2.5 Gbps WAN/LAN port pairs with three 1 Gbps LAN ports and a USB 3.0 port for fast file sharing or printer access (purchase link down below). The quad-core CPU and 512 MB of RAM should help to handle multiple streams without bogging down, while MU-MIMO, OFDMA and 1024-QAM improve efficiency when several devices connect simultaneously. The router’s built-in Game Accelerator engine is said to automatically prioritize gaming packets (both wired and wireless), and TP-Link’s GPN (Gamers Private Network) acceleration can reduce packet loss for supported titles. HomeShield security brings firewall protection, device quarantining and parental controls. The technical specifications of the router are given below: Specification Details Wireless Standards IEEE 802.11ax 6 GHz; IEEE 802.11ax/ac/n/a 5 GHz; IEEE 802.11ax/n/g/b 2.4 GHz Wi-Fi Speeds 6 GHz: 2402 Mbps (802.11ax); 5 GHz: 2402 Mbps (802.11ax); 2.4 GHz: 574 Mbps (802.11ax) Spatial Streams 6 streams (tri-band OFDMA/MU-MIMO) Processor 1.7 GHz 64-bit Quad-Core CPU Memory 512 MB high-speed RAM Ethernet Ports 1× 2.5 Gbps WAN/LAN; 1× 1 Gbps WAN/LAN; 3× 1 Gbps LAN USB 1× USB 3.0 SuperSpeed port (up to 10× faster than USB 2.0) Antennas 4× high-performance external antennas with Beamforming Buttons Power On/Off; Reset; WPS/Wi-Fi; LED On/Off Working Modes Router Mode; Access Point Mode Security WPA, WPA2, WPA3, WPA/WPA2-Enterprise; SPI firewall; Access Control; IP/MAC binding; Application-layer gateway; HomeShield security suite VPN OpenVPN, PPTP, L2TP (server & client); WireGuard (server & client) Software & Services IPv4/IPv6; TP-Link HomeShield; EasyMesh; Parental controls; QoS by device; WAN types (Dynamic IP, Static IP, PPPoE, PPTP, L2TP); DDNS (TP-Link, NO-IP, DynDNS); auto firmware updates Gaming Features Game QoS boost; gaming-port priority; Gamers Private Network acceleration; game-port forwarding; real-time game panel with stats & RGB control Operating Environment 0 °C – 40 °C; 10 %– 90 % non-condensing humidity Get the TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 at the link below: TP-Link Tri-Band AXE5400 Wi-Fi 6E Gaming Router Archer GXE75 | EasyMesh, HomeShield: $159.99 + $25 off with coupon => $134.99 (Sold and Shipped by Amazon US This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
  • 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
      137
    5. 5
      +FloatingFatMan
      116
  • Tell a friend

    Love Neowin? Tell a friend!