Assorted problems

[Daemeon]

Ok, I need some help with a couple of things. I've searched for this and found similar problems but still hasn't fixed it.
I gathered db.sql from documents in the EqEmu release folder but don't understand it:
1)Install MySQL, standard install procedure.
2)Run winmysqladmin, it will ask you for a username/password (If it doesnt delete the file my.ini from your windows directory) Choose a username/password you can remember and write it down.
4)You can close this now. Depending on your windows version mysql might run as a service in the background or you may need to have winmysqladmin running in the background, to allow programs to access the database.
5)From a dos prompt run mysql.exe
6)To create your database, enter this command:
create database eq;7)Here you need to merge the .sql files into your new blank 'eq' database.
Enter these commands
use eq;
source C:\pathtosqlfiles\db.sql;
Now your 'eq' database has all the info you need.
1st problem:
When I type: create database eq
It says: access denied for user: '@localhost' to database 'eq'
2nd problem
db.sql is not in mysql folder, where do I get this at?
What do you mean by C:\pathtosqlfiles ? For example mysql folder is located in C:\mysql should I type that?
-
Anyways, thanks in advance if you can help.

[Kgaul]

you missed a step. you need to, at the sommand prompt

1 Cd \mysql\bin
2 mysql -u root mysql
3 Grant all privilages to (insert your username)@localhost (or '%' for anywhere) Identified by (insert your password) With Grant options;
4 Create Database (whatever you choose);
5 source db.sql;
6 source (any other .sql you need)
7 exit

continue with your tutorial... its easy to overlook this steplll


Kgaul