SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,200
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    using xampp - several questions.

    I have been using php and mysql since Kevin posted his 10 lessons on this site. My isp supplies the db (user and pw). That has served me well.

    Now I need to do some work in DW5.5 (non cloud) and I have dl-ed xmapp, opened it and am to the point of needing a db, user and pw.

    Thanks in advance

    ed

  2. #2
    SitePoint Mentor silver trophy
    Rubble's Avatar
    Join Date
    Dec 2005
    Location
    Cambridge, England
    Posts
    2,435
    Mentioned
    82 Post(s)
    Tagged
    3 Thread(s)
    As I am on my home PC I just use the root without a password !

    From the xampp website:


    How I can set a "root" password in MySQL? (method 1)

    The easiest way is to use the security console, which you can access at http://localhost/security/.

    This "console" creates a password for the MySQL user "root" and is adjusting the phpMyAdmin configuration.



    How I can set a "root" password in MySQL? (method 2)

    With the"XAMPP Shell" (command prompt) you can also change the password. Open the shell and execute this command:
    mysqladmin.exe -u root password secret

    Of course, your password should not be "secret", too. In the next step you must adjust the phpMyAdmin configuration for this new password. In the file "\xampp\phpMyAdmin\config.inc.php" change the lines:
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    to:
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = 'secret';

    Instead in the XAMPP Shell, you can also change the password with phpMyAdmin, and then adjust the phpMyAdmin configuration.

  3. #3
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,200
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Rubble View Post
    As I am on my home PC I just use the root without a password !

    From the xampp website:

    First, congrats on the photo award.


    I was a bit apprehensive about asking the wrong question, and sure enough, I did (ask the wrong question). Please be patient.

    root and its password are for the entirety of xampp\mysql and your reply reenforces the reading I found in the installation blurbs. I tend to sometimes go sideways and what you have said confirms that I am correct - so far.

    I need to setup a project database and user account.

    I need to post. My machine is going zonks...............

    I posted and then realized that I had not thanked you for the very thoughtful reply, Thanks and Peace

  4. #4
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,073
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    When dealing with php and MySQL you're best off creating a new "super-user" for MySQL for the general administration of MySQL.l Once the new super user ins created it should be used instead of the default or root. Once you've created the new super-user then any other super-uses should be deleted, especially root. Each PHP app should have it's own MySQL user which will only have privileges for that app's own database.

    If you're using a shared server then you'll probably have no say as to what MySQL user you use for PHP to access MySQL or for you to administer MySQL directly.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  5. #5
    SitePoint Wizard edshuck's Avatar
    Join Date
    Jul 2000
    Posts
    1,200
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am sorry about the delay in reply . Personal stuff.

    Thanks for the reply and it makes a lot of sense to move away from using "root".

    Many thanks to those who have read the thread and an extra helping of thanks to those who have replied.

    Peace


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
  •