SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast dineroking's Avatar
    Join Date
    Nov 2008
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL username and password

    I'm a beginner, and I'm just starting to learn PHP and MySQL. I just installed XAMPP and after I start Apache and MySQL and I click on admin next to MySQL I get a page to access the database but it asks for a username and password. I never set one before. What can I do?

    Thanks

  2. #2
    SitePoint Zealot
    Join Date
    Feb 2003
    Location
    Akron, OH, USA
    Posts
    102
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    The default username should be 'root' and I do not believe that there is a password.

    If you want to change this browse to http://localhost/security/ while XAMPP is running.

  3. #3
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,028
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Once you've logged into MySQL you should create a new "super-user" (one which you use for editing the structure of your databases, and can access all databases with all privilages) straight away. Once the new "super-user" is created and confirmed to work, the user "root" should be deleted.

    For any app that needs access to its database, give it it's own database user which will have privilages only for it's own database, it should not have any rights to any other database. Depending on what the app is you might want to consider denying it rights to use either TRUNCATE or DROP on its own database or any tables in its own database
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •