[Tutorial] Basics of Navicat  
Old 07-25-2007, 12:14 AM   #1
Jargs
 
Jargs's Avatar
 
Join Date: May 2007
Posts: 2,236
Jargs has a reputation beyond reputeJargs has a reputation beyond reputeJargs has a reputation beyond reputeJargs has a reputation beyond reputeJargs has a reputation beyond reputeJargs has a reputation beyond repute
This tutorial will show you the basics of Navicat and how to edit simple things. Everything from player accounts, items, creatures, forum accounts, and all that information is stored in the MySQL database.

Download Navicat.

When you have downloaded it, install it and open it.

First of all, we need to connect to the MySQL database. Click on the Connection button in the top left and fill out the details.

Connection Name: Can be anything you want.
Host name/IP address: localhost
User name: root
Password: If you are using AC Web Ultimate Repack, the password is ascent. If you have installed MySQL yourself, then you will put in the password you used during the installation.

*NOTE THE PASSWORD IS ACTUALLY ASCENT*


Now double click on your connection to the left. You will see your databases, click on those to view the tables.



Once you have opened a table here are some basic commands at the bottom:



Tutorial by Jargs of ac-web.org
Jargs is offline   Reply With Quote
 
Old 07-25-2007, 12:31 AM   #2
moonfang
 
moonfang's Avatar
 
Join Date: Jul 2007
Posts: 238
moonfang is an unknown quantity at this point
Good work jargs !!
moonfang is offline   Reply With Quote
 
Old 07-25-2007, 01:18 AM   #3
Wiggins
 
Wiggins's Avatar
 
Join Date: Jul 2007
Posts: 293
Wiggins is an unknown quantity at this point
thanks for puttin' it with all the pretty colors jargs :-P much appreciated.
Wiggins is offline   Reply With Quote
 
Old 07-25-2007, 08:39 AM   #4
szela_93
 
szela_93's Avatar
 
Join Date: Jun 2007
Location: Poland near Cracow
Posts: 1,336
szela_93 has a spectacular aura about
usually i dont pres save changes and it wokrs
szela_93 is offline   Reply With Quote
 
Old 07-29-2007, 03:11 AM   #5
Flame254
 
Flame254's Avatar
 
Join Date: Jul 2007
Posts: 48
Flame254 is an unknown quantity at this point
it says "Can't connect to MySQL on server 'localhost' (10061)" I installed AC Web Ultimate Repack, and that's what it says.
Flame254 is offline   Reply With Quote
 
Old 07-30-2007, 08:10 AM   #6
Azax
 
Azax's Avatar
 
Join Date: Jun 2007
Posts: 122
Azax is an unknown quantity at this point
Then your not connected to your SQL..
Azax is offline   Reply With Quote
 
Old 07-30-2007, 09:37 AM   #7
Random Noobie
 
Join Date: Jul 2007
Posts: 7
Random Noobie is an unknown quantity at this point
How do I connect to my SQL? Im having the same problem.
Random Noobie is offline   Reply With Quote
 
Old 07-30-2007, 08:14 PM   #8
blackout224
 
blackout224's Avatar
 
Join Date: Jul 2007
Posts: 38
blackout224 is an unknown quantity at this point
guys i get error 1045 using password yes how can i make it work
blackout224 is offline   Reply With Quote
 
Old 08-05-2007, 02:04 AM   #9
jordanb301
 
Join Date: Aug 2007
Posts: 15
jordanb301 is an unknown quantity at this point
WHAT THE FUCK! It says access denied, what do I do?
jordanb301 is offline   Reply With Quote
 
Old 08-05-2007, 09:55 AM   #10
szela_93
 
szela_93's Avatar
 
Join Date: Jun 2007
Location: Poland near Cracow
Posts: 1,336
szela_93 has a spectacular aura about
if u even touch even open mysql conf file ur db will screw and u'll hav to reinstall it
szela_93 is offline   Reply With Quote
 
Old 08-05-2007, 12:29 PM   #11
ismails
Guest
 
Posts: n/a
lol meybe sometimes use your brains ok ? ^ ;)
  Reply With Quote
 
Old 08-08-2007, 09:26 PM   #12
alkaiser
 
Join Date: Aug 2007
Posts: 6
alkaiser is an unknown quantity at this point
well, apparently you didn't start up mySQL, which is step 1 in starting up your server. Do that first, then run navicat
alkaiser is offline   Reply With Quote
 
Old 08-11-2007, 04:02 AM   #13
hestonf50
 
Join Date: Aug 2007
Posts: 3
hestonf50 is an unknown quantity at this point
i cant get that big table
hestonf50 is offline   Reply With Quote
 
Old 08-17-2007, 03:55 PM   #14
killerbot23
 
Join Date: Aug 2007
Posts: 1
killerbot23 is an unknown quantity at this point
pfft cant connect to local host error...
killerbot23 is offline   Reply With Quote
 
Old 08-21-2007, 03:03 AM   #15
jibidy
 
Join Date: Aug 2007
Posts: 1
jibidy is an unknown quantity at this point
ok wth when i downloaded navicat it just downloaded a word pad... ???? is navicat that actual server? cna someone please tell me where i start to make the server..
jibidy is offline   Reply With Quote
 
Old 08-21-2007, 04:30 PM   #16
Icelord
 
Join Date: Aug 2007
Posts: 6
Icelord is an unknown quantity at this point
nvm got it now

Last edited by Icelord; 08-21-2007 at 05:31 PM. Reason: Automerged Doublepost
Icelord is offline   Reply With Quote
well my room mate n I got it running On the 1st try  
Old 08-27-2007, 01:48 AM   #17
Alcohobbiest
 
Join Date: Aug 2007
Posts: 3
Alcohobbiest is an unknown quantity at this point
HOWEVER im not clear on the making it public or gettin an account so i can play On his server!~ SO i have 1 Question!~ in several parts... Do i need to open a forums of my own ? or do i just need a web host that can handle this account thing ! cuz Quite honestly Im lost in that 1 area! BUT i as well as My roomate got thsi running On 2 seperate pcs on the 1st try! so we can run 2 servers! just Not sure about the accout set up stuff so others can Join In the Fun.................


And i must say So far ALL the tutorials i have read have been right on the money ! except the account set up stuff It is a Little vague! just need to no do i need to set up something at my forums at Allgadgets to access the servers we have set up ? Thanx for all the Awesome info so far This is teh coolest thing i have ever seen! My kids love the idea! so this is really very interesting and we decided we gotta try it on for size! and as a gamer i can say ya can never have enough online servers for this game specially if ya aint gotta pay for it! my forums already pays for itself so it will be no problem to add a section for this! with just a simple registration and log in set up please help?
Alcohobbiest is offline   Reply With Quote
 
Old 09-03-2007, 01:03 AM   #18
imfamous08
 
imfamous08's Avatar
 
Join Date: Aug 2007
Location: TX
Posts: 491
imfamous08 is just really niceimfamous08 is just really nice
Omg Someone Please Help Me!! When I Try Getting In To Navicat It Sais Acces Denied For User "root"@"localhost"(using Password:yes) Can Someone Please Help Me!! I Will Greatley Appreciate It Oh And I Should Have My Server Running While Doing This Right?
imfamous08 is offline   Reply With Quote
 
Old 09-03-2007, 01:07 AM   #19
lilnate22
 
lilnate22's Avatar
 
Join Date: Jun 2007
Posts: 1,814
lilnate22 will become famous soon enough
Quote:
Originally Posted by imfamous08 View Post
Omg Someone Please Help Me!! When I Try Getting In To Navicat It Sais Acces Denied For User "root"@"localhost"(using Password:yes) Can Someone Please Help Me!! I Will Greatley Appreciate It Oh And I Should Have My Server Running While Doing This Right?
ummm no... ur just retarded as hell



hmmm heres a WILD idea..


actually PUT a password in???
lilnate22 is offline   Reply With Quote
 
Old 09-03-2007, 04:18 AM   #20
imfamous08
 
imfamous08's Avatar
 
Join Date: Aug 2007
Location: TX
Posts: 491
imfamous08 is just really niceimfamous08 is just really nice
put a password in where?

u have to right click the file that was put on your desktop and extract the files then another folder will pop up.

Last edited by imfamous08; 09-03-2007 at 04:23 AM. Reason: Automerged Doublepost
imfamous08 is offline   Reply With Quote
 
Old 09-03-2007, 04:19 PM   #21
sae6996
 
Join Date: Sep 2007
Posts: 1
sae6996 is an unknown quantity at this point
if your geting a 1045 put pass word as ascent insted of antrix
sae6996 is offline   Reply With Quote
 
Old 09-07-2007, 12:58 AM   #22
Oreoshakes
 
Join Date: Sep 2007
Posts: 1
Oreoshakes is an unknown quantity at this point
"Can't connect to MySQL on server 'localhost' (10061)" same error for me
Oreoshakes is offline   Reply With Quote
 
Old 09-08-2007, 07:47 AM   #23
damon166
 
Join Date: Sep 2007
Posts: 13
damon166 is an unknown quantity at this point
i get error 1045 using password yes how can i make it work???
damon166 is offline   Reply With Quote
 
Old 09-12-2007, 11:54 AM   #24
streamshot
 
Join Date: Sep 2007
Posts: 6
streamshot is an unknown quantity at this point
thanks sae6996!!... that sorted it
streamshot is offline   Reply With Quote
 
Old 09-13-2007, 03:31 AM   #25
holyyo
 
holyyo's Avatar
 
Join Date: Aug 2007
Location: michigan
Posts: 34
holyyo is an unknown quantity at this point
look in your antrix config or ascent config and look for the password should be ascent for ascent and antrix for antrix bu yours might be different soo look in that config file
holyyo is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:40 PM.

All times are GMT. The time now is 05:40 PM. Contact Us - AC Web - Archive - Privacy Statement - Top