Quary browser

[Subzeroevil]

i just trying tis out but what do you put in server host spot in the Quary browser ?

thanks for the help

and when i put my server router ip iget this mysql error #1130
host'bsa1-windsor 12-1088735676.dsl.bell.canot allowedto connectto this mysql server any hel would be great

[John Adams]

I sense a scolding coming on...

[Subzeroevil]

why do you say that ??

[Belfedia]

why do you say that ??


Because :
You write your problem in 3 at least post...
The people who can answer you read all new the post, they are tedious which they read you 3 times. That does not give them desire for answering you...

For your post:
Have you a mysql problem install (you're not on the mysql support forum)
Or a real eqemu problem ? Can you give more informations please ?

[devilspuppet]

maybe just

localhost

not sure how you have it setup

[Subzeroevil]

now does any one know where to input the codes and where ??
because i cant get it to work. i am using Setting up EQEmu-0.7.0-845 Minilogin with MySQL 5.0.24 ( http://www.eqemulator.net/wiki/wikka.php?wakka=ws70845mysql5 ) walkthrough when i enter the like this:

INSERT INTO VARIABLES VALUES ('MOTD','Welcome to EverQuest!','Server Message of the Day',20060411132036);



then i try to execute it it allways comes back as an error.

thanks for the help,

devilspuppet :-)

[Belfedia]

INSERT INTO VARIABLES VALUES ('MOTD','Welcome to EverQuest!','Server Message of the Day',20060411132036);


2 solutions but you don't give enough informations :(


1/
because you try to INSERT variables which already exist

In mysql commands INSERT is for new data
you must use REPLACE for change data

2/
Because VARIABLES table isn't exist

Create it with :

CREATE TABLE `variables` (
`varname` varchar(25) NOT NULL default '',
`value` text NOT NULL,
`information` text NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

But my advice is to learn more about mysql in internet guide :)

[John Adams]

INSERT INTO VARIABLES VALUES ('MOTD','Welcome to EverQuest!','Server Message of the Day',20060411132036);

then i try to execute it it allways comes back as an error.
Perhaps you should post the actual error message. Not being able to contact MySQL has no bearing on your failed insert statement, because you wouldn't even be at a point to perform the insert if you couldn't contact the server (first error posted).

[Subzeroevil]

ok i haved log in Query Browser and i entered what Belfedia said but i get a message that there no database selected. anyways it might be easy to just go to here:
http://www.eqemulator.net/wiki/wikka.php?wakka=ws70845mysql5

and go about half way and i haved just log in to the Query Browser. now i think there is something missing but do not know. i did what it said login and i do not know where to put the statments and what to do with them i have been top most of the screen and push execute thata when i get a messege no database selected when i do what Belfedia said to do and when i do any of of the lines in the walkthrough.

thanks
subzeroevil

[Belfedia]

when i get a messege no database selected when i do what Belfedia said to do and when i do any of of the lines in the walkthrough.


Read the documentation of the quary browser and find how to select your database, Guide teach how use eqemu, not how use mysql...