[Guide] Full guide for creating a MySQL database for use with plugins on Ubuntu/Debian

Discussion in 'Bukkit Help' started by desmin88, Apr 5, 2011.

  1. Offline

    Col1107

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I also don't know what a SSH terminal is. Is just the normal terminal on Mac or is there a different one that I need to get or install. Sorry I'm not as smart as you. :p
  2. Offline

    shadrxninga

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    http://en.wikipedia.org/wiki/Secure_Shell
    SSH is basically a remote terminal or a way of bringing up the terminal of a remote computer securely. You can use the MacOSX terminal to start an ssh session.
    Code:
    ssh [email protected]
    It then will prompt you for a password if you have ssh installed and running on port 22 on the remote machine.

    Most hosting companies will not allow this - as you are sharing the same server with others.
  3. Offline

    Col1107

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Is there any other simpler way of doing this? Like a web page? Or this the only way?
  4. Offline

    shadrxninga

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    The whole point of ssh is that it is used through a console. There is some web consoles - but they are basically the same as running it through a console on your computer. In fact they are exactly the same, but slower.

    So.. I'm afraid that no would be the answer to your question.
  5. Offline

    Karlkorv

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
  6. Offline

    shadrxninga

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    You can get ssh clients for windows as well. SSH is built into most linux/unix based machines. For example , there is Putty
  7. Offline

    XLawless BaronX

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Very good Tutorial on how to help people mate people could also get DirectAdmin or Cpanel dpending on the OS and/or Webmin which is free
  8. Offline

    darr111

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    thanks for the tut but when i go to create the database it doesnt ask for the password
    it just make a new line under it

    Code:
    darragh@darragh-Ubuntu:~$ mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 42
    Server version: 5.1.58-1ubuntu1 (Ubuntu)
    
    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> mysqladmin -u root -p create minecraft
        ->
    
    i enter my password but it just makes a new line

    Code:
    mysql>mysqladmin -u root -p create minecraft
        ->'mypassword
        ->
    

    This post has been edited 1 time. It was last edited by darr111 Dec 1, 2011.
  9. Offline

    aikoels

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    i get this when i put my pass in (mac osx)
    Code:
    sudo apt-get install mysql-server
    Password:
    sudo: apt-get: command not found
    
    I put in the pass. but it doesn't show up. I read that it isn't supposed to show up and it stays invisible and i just had to hit enter so that is what i did.
  10. Offline

    shadrxninga

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    This is a tutorial for severs running Ubuntu and Debain Linux os's. Mac OSX doesn't have the apt-get command - which is why it isn't found. Also, Passwords in the terminal never show up - instead of * appearing, it will stay blank.
    I haven't install mysql on a mac before, but this may help
    http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
  11. Offline

    Monkz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I did everything posted above, exactly as entered, except i added a ; at the end of the last line where you create the user, however my logblock refuses to work. I filled in user, localhost, 3306, and mypassword in the 4 sections, and when i go to test after a /reload its not working.
  12. Offline

    Pwnzsolo

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    Ya I would suggest switching to Minecraftserverhost.net they are a wonderful serverhost and they know a lot about minecraft and will help you through every step of creating a server and also will install Mysql on your server and create a database for you all upon request. They aren't crazy expensive like liquid web and you don't lose a lot of performance just because they are cheaper. You get your own dedicated server which isn't oversold so no running into lag when you shouldn't be.
    But yea TuRmoiLxx is right if a webhost wont even let you set up a MySql database then you should deffinately look elsewhere. I can see them not agreeing to do it for you as I was surprised that my host did it all with haste for me but they should not tell you that you cant use it period.
  13. Offline

    kamild1996

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    There's something wrong with that database:
    And that's not a plugin failure - all was working when using dedicated Minecraft hosting. Now I'm using VPS with Debian and that's what happens.
  14. Offline

    Jackbrook

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I'm getting the same problem. Does anyone know how to fix this, or where I am going wrong? Thanks for any help. :)

    This post has been edited 1 time. It was last edited by TnT Dec 9, 2012.
  15. Offline

    lorindellia

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Minecraft account:
    MCUSERNAME
    I have a question,
    I hosted my server on Beastnode and they do not allow a ssh terminal connection; I also have a website hosted at GoDaddy.com as well that does allow me to use databases; althought I must keep each DB under 1 gb. So the question is; can my server 198.143.190.209:25565 be hosted over at beastnode.com and my database reside over at godaddy.com at www.serverlorin.com? Would this cause lag if it is even possible to do?

    Please LMK

    Thanks,
    Lori

Share This Page