YNOT
  • Home
  • Industry News
    • Adult Business News
    • Adult Novelty News
    • YNOT Magazine
    • EU News
    • Opinions
    • Picture Galleries
  • PR Wire
    • Adult Company News
    • Adult Retail News
    • Adult Talent News
    • Adult Videos News
  • Podcasts
  • Industry Guides
    • Adult Affiliate Guide
    • Affiliate Marketing for Beginners
    • Top Adult Traffic Networks
    • Top Adult PR Agents
    • Funding an Adult Business
  • Business Directory
    • View Categories
    • View Listings
    • Submit Listing
  • Newsletters
  • Industry Events
    • Events Calendar
    • YNOT Cam Awards | Hollywood
    • YNOT Awards | Prague
    • YNOT Cammunity
    • YNOT Summit
    • YNOT Reunion
  • Login with YNOT ID
YNOT University: Educational articles and tutorials

Create a Site with WordPress: Configuring MySQL Using phpMyAdmin

Posted On 14 Feb 2011
By : admin

YNOT – In the previous article, we saw how to configure Apache to prepare for the installation of WordPress.

Today we will focus on using WAMP and phpMyAdmin to configure MySQL, the database we installed.

WAMP (installed here) creates a root account in MySQL, but the security is very weak because no password is required to gain access to the root account. The first thing we will do is create a special access key to increase the level of security for our database.

Launch WAMP, and then left-click on the system tray icon that looks like a tachometer. Select phpMyAdmin from the pop-up menu. Your default browser will open to an administration panel that will allow you to manage the database of your future WordPress site, as illustrated in the image below:


From the tabs at the top of the screen, select the Privileges heading and then select the icon next to the root user to change the security settings (illustrated below):


After clicking on the icon indicated by the arrow, type your password twice and then click the OK button to confirm your choice.

At this point, because we altered a parameter of root access we would get an error page if we tried to log in to the home of phpMyAdmin. To avoid that problem, we must perform a couple of updates.

If you left the default settings during installation, WAMP will have installed phpMyAdmin in the path C:\wamp\apps\phpmyadmin3.2.0.1, which may vary slightly depending on the version of the program that you installed.

To make the appropriate changes now, find the config.inc.php file and look for the following strings:
[PHP]$cfg[’Servers’][$i][’user’] = ‘root’; // MySQL user
$cfg[’Servers’][$i][’password’] = ‘’; // MySQL password[/PHP]
As you can see, the default username is “root” and the default password is blank. This is why you can no longer access phpMyAdmin after you changed the password as instructed above.
Let’s modify the config file by inserting the password you specified earlier. Place the password between the single quotation marks after the “=” sign in the password line, like so:
[PHP]$cfg[‘Servers’][$ i][‘user’] = ‘root’; // MySQL user
$cfg[‘Servers’][$ i][‘password’] = ‘YOUR_PASSWORD_HERE; // MySQL password[/PHP]
Save the changes you just made, and then try to log in to the phpMyAdmin panel to verify that all changes were completed successfully.

Before explaining how to create a specific database for the site you intend to create, it is good to do a little reflection on the security of your password.

The site that you will create, if all goes well and if the contents are really good, will have global visibility. You can be sure someone will try to undermine your security, attempting for example to steal customers’ usernames and passwords or in other ways do harm to your privacy.

Choosing a good password is the basis for the security of your site, so I advise you not to include any variant of the name of the site or your name or location, your birthday, or anything else that could be guessed. Incorporate at least one numeral and possibly special characters that are obtained by pressing SHIFT and any number on the keyboard. Your future customers will thank you for your foresight.

This article was written for YNOT by Eng. Antonio Lodesani. For more information, visit ingoccupati.blogspot.com(in Italian).[/lang]

  • google-share
Previous Story

Landing Page Design Tips

Next Story

How Can I Tell Whether a Translator Did a Good Job?

Leave a Reply Cancel reply

You must be logged in to post a comment.

Sponsor

YNOT Shoot Me

YNOTShootMe.com has exclusive pics from adult industry business events. Check it out!

YNOT Directory

  • Clickadu – Your trusted traffic souce
    Marketing & Traffic Services
  • Mr S Leather
    Retail Affiliate Programs
  • Webmaster Central
    Paysite Affiliate Programs
  • Premiere Listing

    Dao of Leads

    More Details

RECENT

POPULAR

COMMENTS

Free Speech Coalition

FSC Decries Supreme Court’s “Radical Departure from Precedent”

Posted On 30 Jun 2025

Beth McKenna has "A Very Productive Meeting" with Leilani Lei & Savvy G

Posted On 30 Jun 2025

Ricky’s Room Drops Kinky New Liz Jordan Scened

Posted On 30 Jun 2025

Vanessa, Meet Vivid

Posted On 29 Sep 2014
Laila Mickelwaite and Exodus Cry

Laila Mickelwaite, Exodus Cry and their Crusade Against Porn

Posted On 03 May 2021

Sex Toy Collective Dildo Sculptor

Posted On 19 Mar 2019

Find a good sex toy is now a problem,...

Posted On 18 Mar 2024

Thanks to the variety of sex toys, I can...

Posted On 02 Feb 2024

I understand the concerns about...

Posted On 05 Jan 2024

Sponsor

Sitemap
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy Policy