DataBase not connecting

07/26/2011 10:20 Bаne#1
Heya everyone, I just moved overs PC's, (AGAIN Q.Q), this is was supposed to be dedicated to Co2, so I got the hellmouth sorce, seemed stable and I used it on my last PC, only probleme is I get a error message on the Hellmouth.exe saying it can't connect to the MySQL server, everything is correct on the settings file so I'm not very sure on why, and yes the DB is running ETC.
07/26/2011 10:23 12k#2
Hmm, have you checked the source code in the source to make sure the mysql connection is reading from the settings you set, or from a different location?
07/26/2011 10:29 Bаne#3
Quote:
Originally Posted by 12k View Post
Hmm, have you checked the source code in the source to make sure the mysql connection is reading from the settings you set, or from a different location?
The hellmouth soruce does not require you to do so, but I double check the sockets ETC and no not that.
07/26/2011 10:39 12k#4
Ah gotcha. Downloaded the source code for hellmouth source. So you have changed the MySqlArgument values to the correct mysql info for ur mysql in the code, and debugged the solution, and u cant connect to mysql? o.o


#edit
The settings.txt isnt being used, incase you were using that.
07/26/2011 10:41 Bаne#5
Quote:
Originally Posted by 12k View Post
Ah gotcha. Downloaded the source code for hellmouth source. So you have changed the MySqlArgument values to the correct mysql info for ur mysql in the code, and debugged the solution, and u cant connect to mysql? o.o
yes, the MySQL varibles in the settings file are all correct, so is the IP, when I run the debugger it start's the server successfuly, yet when I try to login game, I get the connection error.
07/26/2011 10:43 12k#6
It doesnt read off of the settings.txt file. It reads directly out of the source code. Thats why i was asking if u looked in the source code ^^. You will have to do it inside of visual C#.
07/26/2011 10:45 Bаne#7
Quote:
Originally Posted by 12k View Post
It doesnt read off of the settings.txt file. It reads directly out of the source code. Thats why i was asking if u looked in the source code ^^. You will have to do it inside of visual C#.
Yes, I checked the source code, and it seemed correct, and I have never needed to edit any of the source to log in, in the past o.o
07/26/2011 10:46 Spirited#8
What's the error message?
07/26/2011 10:48 Bаne#9
Without starting the computer up, etc, the message was something along 'Cannot connect to MYSQL using user 'Root' (pass check YES)
07/26/2011 10:49 12k#10
Ahh woops, i retract my previous statement rofl. It does read from the settings.txt sry, didnt look at it that hard. I cant even find a instance of the MySqlHandler being created right now lol, to me it appears its just using structs. I must be too tired :D bed time for me lol. sorry, i tried.
07/26/2011 10:50 Spirited#11
Quote:
Originally Posted by [GM]Bane View Post
Without starting the computer up, etc, the message was something along 'Cannot connect to MYSQL using user 'Root' (pass check YES)
make "Root" lowercase --> "root" and u'll be good to go.
(taking that your password and database name are correct)

If that doesn't work, reinstall MySql Community Server using the official installation and set it up with information that will work. You might of typed something incorrectly.
07/26/2011 10:52 Bаne#12
I logged on and checked, it was already lowercase root, infact here it is

IP=127.0.0.1
USERNAME=root
PASSWORD=alpha675463
DATABASE=5310
DMGREDUCT=80
07/26/2011 10:54 12k#13
And you can login using a mysql GUI such as query browser or navicat with that information? o.o
07/26/2011 10:54 Bаne#14
Quote:
Originally Posted by 12k View Post
And you can login using a mysql GUI such as query browser or navicat with that information? o.o
Yes I can o.o
07/26/2011 11:09 Spirited#15
DATABASE=5310 ?
What is the name of your database?