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
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.