Thread: Mysql error
View Single Post
  #5  
Old 07-26-2007, 09:44 PM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default

Firstly, you might want to start searching the forums, as your questions have been answered literally hundreds of times. This tends to get the local natives a little upset (people not using search).

Anyways, your problem is probably that you haven't set MySQL permissions yet:

Code:
 C:\mysql\bin\mysql -u root peq
(If C:\mysql\ isn't your install path, then obviously use yours)


Code:
 GRANT ALL PRIVILEGES ON peq.* TO eqname@localhost IDENTIFIED BY 'eqpass' WITH GRANT OPTION;
Where:
peq = the database name
.* = all tables in said database
eqname = mysql username, in your case you were using root
localhost = host from which this connection is allowed (use % for ALL HOSTS)
eqpass = password for this user/host combination

so for you:
Code:
 GRANT ALL PRIVILEGES ON JukdaksEQEmuDB.* TO root@localhost IDENTIFIED BY 'searchfunction' WITH GRANT OPTION;
__________________
GM/ServerOP - Shadows of Norrath
Reply With Quote