Mysql error

[Jukdak]

im trying to set up a server for this and i am getting an error in the cmd prompt when i try to do the two commands
Source load_system.sql
source load_system.sql

its telling me it failed to open the file, error 2
not sure what to do can anybody help?

[Damilis]

Probably a path issue.
copy those two .sql files to the /bin/ directory of your mysql installation and try again.

[Jukdak]

tried that, isnt working

[Jukdak]

got it fixed now, had the peqdb inside of itself in another folder, but anyways now i have another problem, when i try and start my server i cannot get a connection to mysql, so says my logs

---------------------------------------------
[07.27. - 04:30:49] Starting Log: logs/eqemu_debug_world_5620.log
[07.27. - 04:30:49] [WORLD__INIT] Loading server configuration..
[07.27. - 04:30:49] [WORLD__INIT] Log settings loaded from log.ini
[07.27. - 04:30:49] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[07.27. - 04:30:49] [WORLD__INIT] Connecting to MySQL...
[07.27. - 04:30:49] [WORLD__INIT_ERR] Cannot continue without a database connection.

---------------------------------------------
[07.27. - 04:30:49] Starting Log: logs/eqemu_error_world_5620.log
[07.27. - 04:30:49] Failed to connect to database: Error: #1045: Access denied for user 'root'@'localhost' (using password: YES)

any ideas?

[Damilis]

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:

 C:\mysql\bin\mysql -u root peq

(If C:\mysql\ isn't your install path, then obviously use yours)

 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:

 GRANT ALL PRIVILEGES ON JukdaksEQEmuDB.* TO root@localhost IDENTIFIED BY 'searchfunction' WITH GRANT OPTION;