WoW Mangos, help please!!

[Vargo]

I know this isnt about this server, but since I use enGB I cant connect to enUS, so Im making a server of my own.
Everything is done, except this tiny little crap.
Im using Mangos for client 1.12.1 enGB.
Well, the tiny little problem is that I cant set up my server!!

This is what its saying on my website.

Error: Unable to connect to MySQL server. MySQL reported: Host 'asus' is not allowed to connect to this MySQL server. Error: Unable to connect to MySQL server. MySQL reported: Host 'asus' is not allowed to connect to this MySQL server.

Well, would be glad if you could help me.
Heres the screen so you know whats wrong. ;)

First, putting up realm and server.


Second, my site.


Please, help me ASAP and please dont delete this topic since I cant find another forum to get help. If you got another forum that I could post this on, Id be glad.

But still, try to help me anyways.

Thanks in advance.

[MentaL]

[Yamachi]

Instead of using 89.233.200.249 in your MaNGOS sql config, use 127.0.0.1. ALWAYS use 127.0.0.1 or localhost when MySQL is on the same computer as the server.

[Vargo]

Thanks! The site works now.
But when I press start realm and start ManGOS DB it just comes up fast in a console and closes in no time.

[Vargo]

2007-02-15 20:55:18 Using configuration file realmd.conf.
2007-02-15 20:55:18 MaNGOS realm daemon /0.6-SVN (Win32)
2007-02-15 20:55:18 <Ctrl-C> to stop.

2007-02-15 20:55:18 Database: 89.233.200.249;3306;root;root;realmd
2007-02-15 20:55:18 ERROR:Could not connect to MySQL database at 89.233.200.249: Host 'asus' is not allowed to connect to this MySQL server

2007-02-15 20:55:18 ERROR:Cannot connect to database

[Fiskarn]

youll need to fix the "mangos.conf" and "realmd.conf" if im not totaly wrong..

[Vargo]

What should I fix?

[Fiskarn]

change the 2 files " mangos.conf " and " realmd.conf "?

[Vargo]

Yes, I understanded that.
But exactly "what" should I change in the doc?

Also, if someone could help me over msn, then it will go a lot faster :)

Timmon_91@hotmail.com

[Yamachi]

Change the sql info in those conf files. Should say something about database. Again, change it to 127.0.0.1

[Fiskarn]

do you see your ip some where in the doc, retype that with 127.0.0.1 or your localhost

[Vargo]

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;root;mangos"

? ;)

If its right, what should I change in them? ;)

[Fiskarn]

hm, thats right, tho have you change the text in the other file?

[Vargo]

Hmm, in what other files?

@echo off

diskw\home\admin\program\pskill.exe Apache.exe
IF NOT ERRORLEVEL 1 goto started
set Disk=%1
IF "%Disk%"=="" set Disk=w
rem create the disk
subst %Disk%: "diskw"
IF ERRORLEVEL 1 goto hint
set apachepath=\usr\local\apache2\
set apacheit=%Disk%:%apachepath%bin\Apache.exe -f %apachepath%conf\httpd.conf -d %apachepath%.
set programit=%Disk%:\home\admin\program\
set closeit=%programit%close.bat %Disk%
%Disk%:
cd \usr\local\php
start C:\Program\MANGOS\diskw\usr\local\mysql\bin\mysqld-nt.exe --defaults-file=C:\Program\MANGOS\diskw\usr\local\mysql\bin\my-small.cnf
CLS
echo The server is working on the disk %Disk%:\ [http/127.0.0.1/a/]
start C:\Program\MANGOS\diskw\home\admin\WWW\redirect.html
start %programit%miniserv.exe "%apacheit%" "%closeit%"
goto end
:hint
CLS
echo The disk %Disk% is busy. Use start.bat [disk letter]
goto pause
:started
CLS
echo ERROR!!!
echo One of the instances of Apache server is started. Use stop.bat
:pause
echo .
pause
:end


In my SQL start.
Is there something wrong?
My brother mentioned something that he changed the bolded areas.

[Yamachi]

he means in your realmd.conf
P.S. Why the hell did your brother chnage the batch file? There's no need to change it...

[Vargo]

Ive already changed there. ;(

[Yamachi]

so, does the server work now?..

[Vargo]

yep ;D Thanks ;D;D