EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   Accounts/User Problem (https://www.eqemulator.org/forums/showthread.php?t=12194)

D-Loading 02-27-2004 08:58 PM

Accounts/User Problem
 
Sorry if this is in the wrong forum but I am trying to run a Windows server so I thought this would be the best place. Thank you for taking the time to read and respond to this.
-------------------------------------------------------------------------------


The Problem:

I have been trying to add a database in MySQL. I don't know the code to well so I have 3 web pages pointing to manuals and help files.

But I still can't figure this out or why it is giving me the error:

ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'Eq'

Now I know that the user name should go before the local host but I can't insert that from this interface because I don't have 'access'.

So basically I need to know where I can modify this or what file I need to modify.

I also know that the possibility of a missing file is not too small. So here are the .ini files I have right now, please say if I need anything else.

My.ini
ODBCINST
db.ini
miniloginaccounts.ini
addon.ini
LoginServer.ini

Please, any advise would do. I'm also reading through some manuals that tell me how to grant accounts but I can't seem to log on to my admin account.

Thank you,

samandhi 02-27-2004 09:49 PM

You will need to open cmd window and type as follows:
Code:

mysql -u root mysql
USE <your db's name>;
GRANT ALL OPTIONS ON *.* TO <your username for db>@localhost IDENTIFIED BY <'your pw for your db'> WITH GRANT OPTION;

NOTE the ' before and after your pw they HAVE to be there.... also note you will not use the < and > symbols.. those are to show you that your own thing should go in there..
That should solve your access denied error.. However if you find that you have another error, try doing a search first.. There IS a one stop error guide that has this and many more errors listed in it. http://www.eqemulator.net/forums/viewtopic.php?t=12827 Hope this helps you.


All times are GMT -4. The time now is 01:58 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.