Assorted problems
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; 8)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. :) |
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 |
All times are GMT -4. The time now is 06:25 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.