So.. All i know about MySQL is that it stores logs and data and large file stuff and stuff and stores crap and logs and stuff....... yeaaah.. you get what i mean. Anyways, I run my server on beastnode and i see the "MySQL database" option in the mutlicraft panel, but... what i don't know is, wtf should i do? xD For example, i got coreprotect installed and it has a MySQL option, so i check these in the mysql option thing http://prntscr.com/1tm1wj and put them in the plugin, is that right? what then? how do i access the database? how does it work? anything? how do i know if its even working? what if i get an error log? etc...
BeastNode doesn't offer a web-panel to access the database, you need to download something like Heidi SQL (Personal Favourite) or MySQL-Workbench EDIT; If the database isn't working, the plugin you need it for will return errors (always) because it can't connect, so don't worry about that.
Shouldn't be a need to access it directly. Coreprotect will tell you on server boot or reload if it can't connect. If it's not connected then nothing would be logged so /co inspect would return nothing on an inspected block. If u need to purge the db just use /co purge
guys, so i put the info and it worked nicely, no core protect errors.. but the workbench doesnt show anything... just crap i dont understand :/
Beatlynx Coreprotect logs all my worlds with flatfile stuff, /co i etc.. but saving it to mysql? idk..
Mysql is a database system for storing information in tables, as opposed to a flatfile system, it has many advantages, do you have access to phpmyadmin? Phpmyadmin is a web interface to manage your mysql databases. For your plugin to connect you will need to either find or create a user thats connected to a database, if your host only allows one, they will have pre-generated this for you to literally copy and paste. If the mysql server is on the same as your mincraft server you will be able to set the "host" as localhost or 127.0.0.1.
GodsDead Yeah.... "MySQL noob" what is that? how does it work? how do i access? ..... i must either sound dumb or this is some complex shit
Completely depends on your host, or if you are hosting yourself. If you have a control panel that you manage your minecraft server look in there
GodsDead I'm really sorry but i'm still confused. So i run my server on beastnode which gives you a multicraft panel that has the info for MySQL, And i got the MySQL workbench on my laptop. I also put a new tab connected to my server. And then i put the info in core protect. It gave off an error... ???
