Concerning this:
Quote:
|
Originally Posted by MagicalRage
I downloaded your database and it installed into mysql folder so I sourced it in using
create database eq;
use eq;
source eqbackup00.sql;
then when i tried the insert into account line ... it got an error
Error1062: Duplicate entry 'eqemu' for key 2
anyway i continued onto the grant all privileges line and it seemed like it worked ... but when i ran world.exe it immediatly closed which it wasnt doing before .. and has the access denied for user Magicalrage@localhost
dont know what to do about it ...?
|
The duplicate entry is expected, & harmless. If you'll refer back to my setup instructions, step # 14 says:
Quote:
|
Originally Posted by Devor
(if the last step, the GRANT... command, gives you an access denied error, exit out of mysql.exe & open it again via the command prompt with mysql.exe --user=root eq)
|
... so try that & then the GRANT... command again. I had to do this when I upgraded to MySQL version 4.
As far as this goes:
Quote:
|
Originally Posted by MagicalRage
i uninstalled mysql and reinstalled it as you said
when i look at the enviroment tab in the MyODBC box I still see
Not Found
Driver Version 03.51
Driver C:\WINDOWS\SYSTEM\myodbc3.dll
API Level 2
Setup C:\WINDOWS\SYSTEM\myodbc3.dll
SQL Level 1
|
This appears to be a problem with some missing driver files, or improper versions that's causing a conflict with the proper functioning of MySQL. You're probably going to have to seek MySQL-specific help on this (I'm not expert, myself), if no one else here can help you with that. Consult the MySQL documentation or one of the MySQL help/support forums online (I found one by doing a quick search
here). I'm afraid I can't offer much help on this.