MySql and a dedicated server.

Discussion in 'Spigot Discussion' started by IHazSugar, May 2, 2015.

  1. Can anyone link me to a good video on how to setup MySql? I'm using a dedicated server, if that makes a difference.
    I am also looking for a few plugins:
    1. I need a plugin that can Sync players inventory and xp over cross servers.
    2. I need a plugin that has a global chat.

    I also intend to implement BanManager.

    Any help is appreciated, thanks!
  2. Video's aren't gonna be helpful. Do your research, and you'll be okay.
  3. MikeA

    MikeA Retired Moderator
    Retired Benefactor

    I recommend using CentOS 6.

    Here's a list of all of the commands you need to run in order to setup apache (web server), mysql server 5.5, php 5.6, and phpmyadmin. Just run them in order. You will need to run the mysql installation script after it's done to set a root password, just run "/usr/bin/mysql_secure_installation" in SSH after it's all done. Make sure to right click and copy the phpmyadmin download link since the forums shortens it automatically.

    Sorry if I missed something.

    rpm -Uvh
    yum update -y
    yum install -y zip unzip mysql55w mysql55w-server php56w php56w-opcache php56w-mysql php56w-gd php56w-mbstring httpd
    service httpd start
    service mysqld start
    unzip phpmyad
    rm -rf download
    mv phpMyAdmin* phpmyadmin
    mv phpmyadmin /var/www/html/phpmyadmin
    mv /var/www/html/phpmyadmin/ /var/www/html/phpmyadmin/
    setenforce 0