EQEmulator Forums - Database Connection Issue

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Database Connection Issue (https://www.eqemulator.org/forums/showthread.php?t=38923)

Database Connection Issue

I am trying to figure out why I cannot connect to the MySQL database, I followed the guide and able to do all the patches to the database from the required directory with no issues. I run the .bat file to launch the server and I get the following popup in the window.

http://snag.gy/EfiL2.jpg

I have tried this with XAAMP and I have tried installing MySQL directly and running the service.

I have this entry in my eqemu_config.xml

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>water</password>
<db>peq</db>
</database>

Thanks in advance for any assistance I am at a lost of what to try or check for other than the guide which I have went through a couple of times.

Error 2003 is an access denied error. Have you attempted to change your MySQL root user to be able to connect remotely? (ie - EQ Operations center, use GeorgeS tools, or maybe just manage your database from your local machine instead of server). If you follow the guides where you update your base root account to accept on % instead of localhost, sometimes you can connect remotely, but not locally.

You may try either loading up HeidiSQL and trying to connect to database (on server machine), or launching a command prompt and trying to sign in to your database engine with:

Code:

mysql -uroot -p

and putting in your password. See what the outcome is with that.

P.s Don't remove your server directory

Code:

1. install ActivePerl-5.14.2.1402-MSWin32-x86-295342.msi

2. install mysql-5.1.73-win32.msi

Now install MySQL 5.1 (this will be installed to C:\mysql)

When you first start up the install, make sure you choose CUSTOM install.

IMPORTANT: after clicking "next" this is where you change the install

path to "C:\mysql

On that same menu, make sure ALL options are installed.

After clicking "next", on that menu, choose Detailed Configuration.

After clicking "next" again, choose Server Machine.

After clicking "next" again, choose Multifunctional Database

On the next menu, there is nothing to change, click "next" again.

On that menu, choose Online Transaction Processing (OLTP)

Then click "next". UNCHECK the strict mode option, and make sure that the

TCP/IP Networking is checked ENABLE and at port 3306.

After clicking "next" again, Choose Best Support for Multilingualism.

After clicking "next" again, make sure BOTH of the following are checked:

Install As Windows Service and Include Bin Directory in Windows Path

After clicking "next" again, you will be prompted for a password.

(This password is what goes with your SQL database username)

Your SQL username is automatically set as "root"

After you click "next" again, you will get a menu with "Execute" on it.

Just click that and wait, as it installs and finishes. Reboot.

3. download peqbeta_2014-09-25-02-01.tar.gz

unzip file to C:\MySQL\bin



make two directories peq and peqlogindb

C:\MySQL\data\peq

C:\MySQL\data\peqlogindb



Type mysql -uroot -p

Hit enter and enter your password. (Hit enter again)

You should now see a prompt that looks like this: (along with "Welcome" text before it)

mysql>_



Type the following (in order):



use peq (Hit enter and you will see a short note saying "Database changed")



Then type the following:



source peqbeta_2014-09-25-02_01.sql (when this is done, you will be back at the mysql>_ prompt)



Then type in the following:



source player_tables_2014-09-25-02_01.sql (this will load fast)



I use Navicat for Mysql needs database server setup only

I changed my server files too allow two servers per computer excepting the latest clients

Thanks for the reply, I am able to connect with the XAAMP "Admin" control and HeidiSQL tool, now I am running on Windows Server 2012 R2 Standard.

http://snag.gy/yJykB.jpg
http://snag.gy/QLdn0.jpg

Ok, so I was able to fix this issue by changing the <host> data to explicitly use 127.0.0.1. Now I am getting some table doesn't exist, now to see about patching those:)
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>water</password>
<db>peq</db>
</database>

Quote:

Originally Posted by lakedoo23 (Post 234937)

Ok, so I was able to fix this issue by changing the <host> data to explicitly use 127.0.0.1. Now I am getting some table doesn't exist, now to see about patching those:)

download https://drive.google.com/uc?id=0B5FZ...xport=download peqbeta_2014-10-11-02:01.tar.gz updated database