• MySQL
    2 replies, posted
Hey, I am a newb I know so little about MySQL makes sense so when replying please keep it as understandable to someone like me as possible - Thanks Let me explain: I need to use MySQL databases for a game server I own (To hold the data obviously) now upon doing so, I have followed many tutorials online and the method has worked in the past on what I am trying to do. When I fill out the Lua Code (The code for the game server) with the MySQL information - All correct and I have made sure of this - I simply get a repeat error no matter what I'm trying to set it up for (Forums, game server, etc) The error: Error:Access denied for user 'nexonnet_sbu'@'185.44.76.2' (using password: YES) The IP is the one for my gameserver which doesn't make sense (But then I guess it doesn't help I'm a newb at this stuff). The code for it is: local SBANDATABASE_HOSTNAME = "185.38.148.82" -- IP for cPanel local SBANDATABASE_HOSTPORT = 3306 local SBANDATABASE_DATABASE = "nexonnet_sourcebans" local SBANDATABASE_USERNAME = "nexonnet_sbu" local SBANDATABASE_PASSWORD = "" -- The password is the same on the database as in the code, I just took it out here I have also granted the users all privileges to the databases
Might be related to the settings of remote connections policy, just want to point into right direction [QUOTE]Error:Access denied for user 'nexonnet_sbu'@'185.44.76.2' (using password: YES) The IP is the one for my gameserver which doesn't make sense (But then I guess it doesn't help I'm a newb at this stuff).[/QUOTE] MySQL settings may not allow to connect from 185.44.76.2, only localhost by default.
[QUOTE=suXin;52047908]Might be related to the settings of remote connections policy, just want to point into right direction MySQL settings may not allow to connect from 185.44.76.2, only localhost by default.[/QUOTE] So you suggest I use localhost instead of the IP?
Sorry, you need to Log In to post a reply to this thread.