OK, banged my head against this long enough...

[Kirgothi]

I am having the same problem as you. Where are you stuck at? The "Logging into the server. Please wait..." screen? Or the server selection screen.

Cavedude told me that his installer takes care of adding a default user/passcode for you. I think it's mini/mini, but I am not positive.

Kir

[klinzhai]

I'm at the server screen.

His installer does not install default user/password into the account table (if you go get MysqlCC from the good MySQL folks, you can view the table and there's nothing in it). Just right-click on the account table, select "Open Table > Return all rows" and it will actually return you all the data in the table. If there isn't anything in there, right-click again in the open area where it appears that the data is and select "Insert record". Now you can go through and set all those wonderful settings that you'll need so that you can create new users. As soon as you click on the "name" field, it will autocreate a new master key (the "id" field for the table... never change this, it's only important for the db itself and it autoincrements) for the record.

[Kirgothi]

I am trying to use access to open the table, but I can't seem to find anything to open. What are you using to look at the database?

[cavedude]

Installer Pack 3.5 is out and should work for you.

[klinzhai]

You can find MysqlCC here:

http://downloads.mysql.com/archives....ysqlcc&v=0.9.2

It's a control center. If you load it on your db server (like probably most of us do), your settings should be:

Name: (doesn't matter, I just put down 'localhost')
Host Name: localhost
User Name: root (unless you want to use your EQ user)
Password: (your password )

You can actually do all the database admin type stuff through this... it's a lot easier than trying to do it through the command line version. However, you can't run really large (20+MB) .sql files in it, you have to do those through the command line version (*sniff*). I create all my users in that, since it's easier to just insert record and give it a name, password, status, ip, etc...

P.S.: Cavedude. I used 3.5 it does work way better than everything else, but for some odd reason it did not create an entry into the account table for a user.

[Kirgothi]

Um ok, completely lost here. I have actually had a class on SQL and Oracle, but this all seems totally different than any of that. We were able to use Access to look at any of our databases.

I downloaded the control center. I entered the information you mentioned. How do I like do anything in here? How do you find the tables? They don't seem to be listed anywhere. When I try to connect to the database it just says:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

[Kirgothi]

Ok, now I am trying to add the account using the command line method. I am trying to follow the incredibly cryptic guide here:
http://www.eqemulator.net/wiki/wikka...MiniLoginSetup

I am trying to just open a command prompt and typing in the code:
INSERT INTO account(name, STATUS, minilogin_ip) VALUES('mini',250,'127.0.0.1');

In the first set of parenthensis, do I type in "name", "STATUS", "minilogin_ip" as it says in the guide? Or am I supposed to substitute some other value? What is 250 for? I thought it was for GM or admin level access. Where do you find that information?

It just replies by telling me that INSERT is not a recognized command.

[klinzhai]

It's not going to look like Access, you can probably use Access to edit your database and tables if you like. I'm just used to doing more db design type stuff, where having the database view is more easy for me to do stuff with.

It's possible that one of the problems that you're having is one of the problems that I was having... my password for the eq user (inside MySQL) was not set the same as what the 3.5 installer set it for by default (user: eq - password: eq). I changed that in the database and it worked fine.

That being said, the connection error could be that you're entering the wrong password for root. Or it's possible that you need the odbc driver (I always forget that I have it installed).

If you want to use Access, it's not that different and you should be able to view the data in the tables easier than with MySQLCC

[Maus]

No such luck, cavedude. :(