Access denied (SQL)

[!iMacroMage!]

I'm using ArcEmu - User Control Panel. It is saying for the "start logonserver" and "start world":

Connection failed due to: 'Access denied for user 'root' @ 'localhost' <using password: NO>'

I'm using a Buffalo WHR-HP-G54 Router. My username for 192.168.11.1 is root. How do I go about fixing this issue?

World:

<WorldDatabase Hostname = "localhost" Username = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Name = "characters" Port = "3306" Type = "1">

Logonserver:

<LogonDatabase Hostname = "localhost"
Username = "root"
Name = "characters"
Port = "3306"
Type = "1">

OS: Vista

[Allstar .ιllιlı.]

Make sure port 3306 is opened.
Other than that, I can tell you that using routers with a server is EVIL!

EDIT: Try using 127.0.0.1 instead of 'Localhost'

[1ns0mnia]

your configs are missing your password

they should look like this:

<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "yourpasswordhere"
Name = "characters"
Port = "3306"
Type = "1">

see where it says password? yours should ahve this too, same with world config:

<WorldDatabase Hostname = "localhost" Username = "root" Password = "passgoeshere" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "passgoeshere" Name = "accounts" Port = "3306" Type = "1">


if this was a routing issue then you should just get the error "cannot connect to mysql", plus on localhost (127.0.0.1) the port forwards are not needed.

[!iMacroMage!]

Well, I deleted the password parts and made it so the USER: root PASS: (blank)

127.0.0.0 works on start logonserver, but not start world. Also, when I put 127.0.0.0 for start logonserver, it says:
sql: Logon database perimeters not found.

[kaliska]

Well, I deleted the password parts and made it so the USER: root PASS: (blank)

127.0.0.0 works on start logonserver, but not start world. Also, when I put 127.0.0.0 for start logonserver, it says:
sql: Logon database perimeters not found.

That is why your getting access problems
you installed your sql using a password
when you try to access it it requires a password
you were told to do 127.0.0.1

if your using a repack that has your sql set up you need to edit it to the password that uses

I suggest searching to forums for a complete manual setup
that you install sql by yourself
data bases by yourself
navi cat
its a great way to learn

what repack are you using
what post are you following?

[!iMacroMage!]

Changed to 127.0.0.1 & readded pass. Same error, and still refers to host as 'localhost'.

Using this guide: http://www.mmowned.com/forums/ascent...er-public.html

[kaliska]

are you using start database.bat first?

also turn off uac for vista it always causes problems

control panel user account turn off uac

i dont use vista myself so im testing on a xp

you can also try to right click and run as admin trick

[!iMacroMage!]

UAC was off. I also was using Run as Admin. Still not working

[kaliska]

I took a look at the guide its crap
This guide is a little better IMO

http://www.mmowned.com/forums/ascent...r-3-0-8-a.html
Could use some more screen shots but its better

[!iMacroMage!]

Thanks for all of your help, Kaliska. I'll try it when I get home. I'm @ another house for a few days on vacation. I'll try to get it to work here as well. +rep

[!iMacroMage!]

EDIT: Problem still not fixed. I am at my dad's and I can't even connect to HeidiSQL. Please help me, i've tried the host names: localhost, (my ip), 127.0.0.1, (network name).

EDIT 2: Following Wildslayer's advice by going to try MySQL first.