Saturday, August 26, 2006

So you want to setup a Web Server PART 2


This really is not a long step, but it is very important nonetheless. If you remember in the first part of the tutorial I was referring about security, well one of the first things you will want to do is change MySQL's root password or more importantly give it a password.

How to change MySQL root password
  1. First you need to your MySQL database. Since we went over how to setup Apache, PHP, and MySQL in the last lesson you should also know how to connect to the database with the phpMyAdmin.
  2. Once you connect to phpMyAdmin you should see 2 columns in the main body of the webpage. One should read MySQL - 5.x the other should say phpMyAdmin 2.x.
  3. Under the MySQL - 5.x header find the word "Privileges". Once located click on it.
  4. Now you should see a listing of all the users that are currently setup in MySQL. Currently you should only see two users pma and root. If you look at root you see it has NO password set. If you look closer you can also see that it has ALL privileges. This is not a good thing.
  5. If you look across the root row passed GRANT you should see a little person and a pen. Please click on this.
  6. This brings up a screen to edit the privileges of the currently selected user.
  7. Down near the bottom you should see a heading that reads "Change Password". You should also see that the "No password" radial button is selected. This is not going to do.
  8. Click on the radial button in front of password and type a nice secure password. It is recommended that you choose a password with upper and lower case, at least one symbol, and one number. Putting down "password" or "root" for the password is not going to cut it. **NOTE** please oh please write this password down. Otherwise you will not be able to connect to the database to change it, well actually you can, but that is beyond the scope of this article and it is really much easier to just write it down.
  9. After you have typed the password twice click the "Go" button that immediately follows the "Re-type" box.
  10. At the top of the page in smaller black text you should see a confirmation that reads "The password for 'root'@'localhost' was changed successfully". You will also see the exact SQL query syntax that you would have needed to type in order to have successfully changed your password if you were not using the interface.
  11. Now more than likely once you have changed the password and try to go back to the MyPhpAdmin homepage you will receive an error.
  12. This is normal seeing as that you just changed the password that myPhpAdmin uses to interact with you MySQL databases. What you will have to do next is exactly what it tells us to do in the error text which is to edit the config.inc.php file to include the new password.
  13. If you are using the Xampp package and accepted its default installation path you will need to go to the following folder: c:\program files\xampp\phpMyAdmin\ config.inc.php.
  14. Once you open up that file do a search for "root". Once you have located it you will find that the line to enter in the new password is directly below it. The line should read "$cfg['Servers'][$i]['password'] = ' ';.
  15. Now go ahead and type the password you came up with in step 8 between the single quotes on the right side of the '=' sign.
  16. Once this is complete go ahead and save the file.
  17. Now go back to the phpMyAdmin homepage and you should now be able to access it properly again and as an added bonus you now have a location you can go to if you ever forget the root password (if you remember what file that was ;-)).

6 Comments:

At 11:18 PM, September 29, 2015, Blogger oakleyses said...

nike outlet, prada outlet, ugg boots, uggs on sale, louis vuitton, christian louboutin outlet, ray ban sunglasses, cheap oakley sunglasses, louis vuitton outlet, ray ban sunglasses, nike air max, longchamp outlet, polo outlet, louis vuitton outlet, prada handbags, burberry outlet, christian louboutin uk, uggs outlet, nike air max, chanel handbags, louis vuitton outlet, replica watches, gucci handbags, jordan shoes, michael kors outlet store, michael kors outlet, oakley sunglasses, oakley sunglasses wholesale, michael kors outlet online, polo ralph lauren outlet online, christian louboutin shoes, michael kors outlet, louis vuitton, replica watches, ugg boots, tiffany and co, uggs outlet, nike free, ray ban sunglasses, christian louboutin, michael kors outlet online, burberry handbags, tiffany jewelry, tory burch outlet, kate spade outlet, longchamp outlet, michael kors outlet online, longchamp outlet

 
At 11:22 PM, September 29, 2015, Blogger oakleyses said...

nike blazer pas cher, nike tn, nike free uk, true religion outlet, timberland pas cher, oakley pas cher, ralph lauren uk, nike roshe run uk, true religion outlet, converse pas cher, michael kors, lululemon canada, ray ban uk, nike air max, michael kors pas cher, coach purses, vans pas cher, nike air max uk, polo lacoste, nike free run, michael kors, nike air max uk, jordan pas cher, louboutin pas cher, north face uk, nike air force, sac vanessa bruno, new balance, mulberry uk, nike roshe, hollister pas cher, longchamp pas cher, michael kors outlet, abercrombie and fitch uk, sac hermes, polo ralph lauren, air max, burberry pas cher, hollister uk, coach outlet, sac longchamp pas cher, coach outlet, guess pas cher, true religion jeans, hogan outlet, kate spade, coach outlet store online, north face, ray ban pas cher, true religion outlet

 
At 11:25 PM, September 29, 2015, Blogger oakleyses said...

reebok outlet, nike air max, beats by dre, north face outlet, vans, babyliss, converse outlet, lululemon, soccer jerseys, mcm handbags, baseball bats, nike huaraches, longchamp uk, vans outlet, hollister, new balance shoes, nike roshe run, p90x workout, herve leger, hollister, hermes belt, nike air max, mont blanc pens, hollister clothing, jimmy choo outlet, gucci, ghd hair, insanity workout, north face outlet, instyler, valentino shoes, timberland boots, iphone 6 cases, mac cosmetics, asics running shoes, wedding dresses, nfl jerseys, giuseppe zanotti outlet, soccer shoes, bottega veneta, ferragamo shoes, abercrombie and fitch, louboutin, nike trainers uk, celine handbags, ray ban, chi flat iron, converse, ralph lauren, oakley

 
At 11:29 PM, September 29, 2015, Blogger oakleyses said...

wedding dresses, pandora jewelry, barbour uk, links of london, moncler, barbour, canada goose outlet, moncler, louis vuitton, canada goose outlet, pandora charms, ugg uk, louis vuitton, doke gabbana, juicy couture outlet, canada goose outlet, louis vuitton, pandora uk, swarovski, moncler uk, marc jacobs, canada goose, lancel, moncler, canada goose jackets, ugg, pandora jewelry, supra shoes, michael kors outlet online, michael kors outlet, moncler outlet, replica watches, louis vuitton, moncler outlet, doudoune moncler, ugg pas cher, ugg,uggs,uggs canada, michael kors handbags, canada goose, karen millen uk, ugg,ugg australia,ugg italia, coach outlet, juicy couture outlet, louis vuitton, swarovski crystal, montre pas cher, moncler, hollister, toms shoes, thomas sabo, canada goose uk, canada goose

 
At 8:38 PM, October 21, 2015, Blogger mmjiaxin said...

timberland shoes
woolrich outlet store
cheap nike shoes
san francisco 49ers
discount ugg boots
oakley,occhiali oakley,oakley italia,oakley occhiali,oakley sunglasses
toms outlet
miami dolphins
adidas wings shoes
designer handbags,handbags outlet,cheap handbags,purses and handbags,wholesale handbags,designer bags,bags outlet,handbags wholesale,cheap purses,discount handbags,handbags sale,wholesale purses,handbags and purses,designer purses
nike trainers
chicago bears
philadelphia eagles
celine outlet
michael kors outlet
cleveland cavaliers
basketball shoes,basketball sneakers,lebron james shoes,sports shoes,kobe bryant shoes,kobe sneakers,nike basketball shoes,running shoes,mens sport shoes,nike shoes
ugg boots
seattle seahawks
nike air huarache
mm1022

 
At 6:49 AM, August 10, 2017, Blogger عبده العمراوى said...

شركة قمة الدقة للخدمات المنزلية
شركة مكافحة حشرات بالرياض
شركة تنظيف خزانات بالخبر

 

Post a Comment

<< Home