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

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.

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.

Is there any other simpler way of doing this? Like a web page? Or this the only way?

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.

Mac?

You can get ssh clients for windows as well. SSH is built into most linux/unix based machines. For example , there is Putty

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

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
    ->

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.

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

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.

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.

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.

I'm getting the same problem. Does anyone know how to fix this, or where I am going wrong? Thanks for any help.

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