MySql Problem

Discussion in 'Bukkit Help' started by john924xps, May 17, 2012.

Thread Status:
Not open for further replies.
  1. Offline

    Paswaru

    Goto http://localhost
    On the left menu, click Security
    What does it say about the MySQL admin password and phpMyAdmin login?
     
  2. Offline

    C0nsole

    Help, Paswaru !
    I am working on installing XAMPP and when I try and drag the folder into applications, I get this error message:
    [​IMG]
     
  3. Offline

    Paswaru

    Had you previously tried to install XAMPP? My first thought is one of the componets from a previous install is running. You could try running this in terminal to make sure they are all stopped.

    Code:
    sudo /Applications/XAMPP/xamppfiles/xampp stop
     
  4. Offline

    C0nsole

    I tried that but it still didn't work... I have tried installing XAMPP along time ago and when I just tried to install it again just now, I replaced the XAMPP folder I installed from a long time ago, forgetting I had done so.
     
  5. Offline

    Paswaru

    Assuming you don't need anything from the old install. Try dragging XAMPP from Applications to your trash can to delete it. If it does not give you any errors try installing the new version again. If it gives you an error, post it please.

    *I'm heading off to a meeting but will check back on the thread later*
     
  6. Offline

    C0nsole

    That worked good, I'll continue on with your guide now and tell you if I need any more help ;)

    Ok, got it all set up now, but some things:
    1) how do I allow remote access?
    2) how do I find information I would need for Guardian, such as host, user, database, password?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  7. Offline

    zipron

    only read your first post, but I wrote a full guide about MySQL, including remote access and stuff.. if you want to see your DB, download a mysql client, I advise heidi sql: http://www.heidisql.com/

    link to guide in my sig =)
    zip
     
  8. Offline

    Paswaru

    1) What do you mean by remote access? Typically for security you don't want outside stuff accessing your SQL server. As for Users, they access the plugin, the plugin talks to the SQL server.

    2) Assume your minecraft server is on the same computer as the SQL server, host will just be localhost. Username will be root and password is the password you setup when you ran the sudo /Applications/XAMPP/xamppfiles/xampp security command.



    Note: The root SQL account is different from OSX root account.

    Database will be the name of the database you create. Page 1 Post #28 of this thread.
     
  9. Offline

    zipron

    remote access = access the MySQL server from another computer to do maintenance, one tip: this isn't possible with root acocunt ;-)
     
  10. Offline

    C0nsole

    I shouldn't need remote access then... Hosting both on my computer ;)
    However, if I wanted to allow remote access to a server that a hosting company runs for me, how would I do so?
     
  11. Offline

    zipron

    hosting company = auto remote access, or you wouldn't be able to enter it from your pc home =)
     
  12. Offline

    Paswaru

    Depends on the hosting company. Some will give you direct access to the SQL server, others will require you to use a web interface like phpMyAdmin. Some allow remote access but you have to use their control panel to set which IP address can access it.
     
  13. Offline

    zipron

    phpMyAdmin = a kind of remote access no?
     
  14. Offline

    Paswaru

    It is, but when I think of remote access to a SQL server, its opening up the TCP ports so you can connect directly to the SQL server and not via a intermediary.
     
  15. Offline

    zipron

    if you want to access phpMyAdmin remotly you'll have to open ports too xD
     
Thread Status:
Not open for further replies.

Share This Page