EQEmulator Forums - mysql -u root mysql why does my system need it

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

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

- - mysql -u root mysql why does my system need it (https://www.eqemulator.org/forums/showthread.php?t=17208)

mysql -u root mysql why does my system need it

Okay, I've been trying to install EQ emulator for days.

I've followed all the Howto's and I am now asking for help.

I have even clean formated and reinstalled
even tried without xp sp2 incase it caused problems.

No matter what I try, I get the 1405 or 2001 error when I run World.exe.

Starts with Got signal 0
Current world versiob 0.6.0-dr2
Database Error: lost connection, attempting to recover ..
error 2006

Now i am wondering if the fact my system gives access denied if I try mysql.exe (grant etc)

it all seems to work but if i test

mysql -u <user id> -p

access denied when i input password.

Why does my system need the mysql -u root mysql

to be able to do the GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

I am just trying to get a handle on this because I have read the Howto's i've spent the last 48 hours trying different ways.

Any suggestions or help would be very happily recieved as would any links to something i missed to make me look dumb.

Just to check off what i've tried

Quote:

HOWTO: 0.6.0 Server on Windows (11/03/04)

Everything works except I need to use mysql -u root mysql instead of mysql.

Code:
perl -MIO::Scalar -e "print 'Installed'"

Check

GRANT ALL PRIVILEGES ON eq.* TO someid@"%"
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

The below hasn't been tried because as below my my.ini doesn't include anything like it.

find my.ini (windows) or my.cnf (linux, /etc/my.cnf) and set 8M instead if 1M to
set-variable = max_allowed_packet=1M

->

set-variable = max_allowed_packet=8M

relaunch mysql after you did this.

My.ini

Code:

#This File was made using the WinMySQLAdmin 1.4 Tool

#30/11/2004 19:27:24



#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions



[mysqld]

basedir=C:/mysql

#bind-address=10.0.0.3

datadir=C:/mysql/data

#language=C:/mysql/share/your language directory

#slow query log#=

#tmpdir#=

#port=3306

#set-variable=key_buffer=16M

[WinMySQLadmin]

Server=C:/mysql/bin/mysqld-nt.exe

user=equser

password=*****

db.ini

Code:

[Database]

host=localhost

user=equser

password=*****

database=eq

[/code]

here is the complete error.

Quote:

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Clearing groups..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Unable to clear groups: #2006: MySQL server has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
Couldn't open './addon.ini'.
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Warning: You need to get laid...
TCP listening on: *****
World server listening on: ****
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit

you have mysql installed.
so just follow the directions step by step it aill all make sense.
the
mysql -u root -p
"is how yo connect useing use root with a password"
then type
create database eqemu;
use eqemu;
"if u made it"
then
source world.db;
or whatever world you have.

uhm maybe you said it and I missed it

but are you runing mysqladmin in the backround? and mtsql_nt or something? I thiknk without sql to deal with the account access procs the db is not open to localhost editing