For example, if your MySQL database is run on the same server as your minecraft server, then you can grant access for the user ID to the database as 'local only' access.
The step to grant permission can require a bit more knowledge of how your server is setup and can determine if you pass or fail in your connection attempt. I'm sure there are several other ways as well and depending on how you connect will decide the exact steps you take.Ĭreating the database and user accounts are the super easy parts that are extremely easy to find via google. If you are running MySQL on a Windows machine and you have WorkBench installed, you can use that utility. If you access the database using PhpMyAdmin, then you can run queries inside that. If you have access to the server command prompt where the database is installed, you can run the mysql command-line. How you do all of these depends on the tools you use. #5 - Most plugins will create the tables and populate the data as long as you have done the prior steps. #4 - You update your plugin configuration to specify the MySQL database server name/ip, the database name, user ID and user password. #3 - You must grant permissions for that login account to that database.
Click to expand.#1 - You must create a database.
