mysql -u root mysql why does my system need it

[calranthe]

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]