Server rentals :: NFOservers.com

Forums

All times are UTC - 8 hours



Author Message
 Post subject: Problem setting up MySQL
PostPosted: Mon Sep 05, 2011 10:03 am 
Offline
New to forums
New to forums

Joined: Mon Sep 05, 2011 8:03 am
Posts: 5
Until now, I've been hosting MySQL locally on my laptop for the plugins on my Minecraft server. Being that it's impractical to always need my laptop on, I decided to utilize my server plans webhosting setup. Upon direction, I used the phpMyAdmin autoinstaller and then created some databases and imported some tables from my local MySQL setup. I've configured the plugin config.yml's accordingly but they don't seem to be working in game. Not too sure what I'm doing wrong and would like some assistance, possibly on TeamViewer. Thanks.


Top
 Profile  
 
PostPosted: Mon Sep 05, 2011 11:42 am 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 10310
Location: Seattle
Are you seeing any errors spitting out in your server's console (or server.log file)?


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 2:33 pm 
Offline
New to forums
New to forums

Joined: Mon Sep 05, 2011 8:03 am
Posts: 5
No, that's why I'm confused because it's as if everything is working properly. I think it may be something to do with the fact that in phpMyAdmin, it lists the names of the databases without the bannedofbrothers_ prefix, yet the only way they work in the plugin config.yml's is to do it without the prefix so I'm not sure how to go about it.


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 2:44 pm 
Offline
New to forums
New to forums

Joined: Mon Sep 05, 2011 8:03 am
Posts: 5
Also, when I log in to phpMyAdmin, under MySQL Localhost it says "No privileges", even though I am the primary user.


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 3:06 pm 
Offline
New to forums
New to forums

Joined: Mon Sep 05, 2011 8:03 am
Posts: 5
Would my webhosting plan be on a separate address to my game address? I'm about to see if localhost works in the config files; if not I will revert to the specific webhosting address and come back with the results.


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 3:11 pm 
Offline
Staff
Staff
User avatar

Joined: Thu Jul 22, 2004 12:24 am
Posts: 1114
Location: Big Bear, CA
The MySQL database is indeed at a different address on a different machine, so localhost will not work on the game server.

_________________
TimeX


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 3:25 pm 
Offline
New to forums
New to forums

Joined: Mon Sep 05, 2011 8:03 am
Posts: 5
TimeX wrote:
The MySQL database is indeed at a different address on a different machine, so localhost will not work on the game server.


Yup, that was one of my trial and error episodes, my fears were answered. I've managed to figure it out now though, so thanks for the help and feel free to lock/delete this thread so others can get the help they need.


Top
 Profile  
 
PostPosted: Tue Sep 06, 2011 3:33 pm 
Offline
Staff
Staff
User avatar

Joined: Thu Jul 22, 2004 12:24 am
Posts: 1114
Location: Big Bear, CA
We'll leave it up so others can learn from it too. :wink:

_________________
TimeX


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
It is currently Wed Apr 16, 2014 5:55 am
Powered by phpBB® Forum Software © phpBB Group