PDA

View Full Version : mysql -u root mysql why does my system need it


calranthe
11-30-2004, 09:09 AM
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.

calranthe
11-30-2004, 09:45 AM
Just to check off what i've tried

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

#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

[Database]
host=localhost
user=equser
password=*****
database=eq



[/code]

calranthe
11-30-2004, 10:04 AM
here is the complete error.

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

sdabbs65
11-30-2004, 11:23 AM
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.

watcher001
11-30-2004, 02:28 PM
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