[Tutorial] Basics of Navicat

Jargs · 07-25-2007, 12:14 AM

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

moonfang · 07-25-2007, 12:31 AM

Good work jargs !!

Wiggins · 07-25-2007, 01:18 AM

thanks for puttin' it with all the pretty colors jargs :-P much appreciated.

szela_93 · 07-25-2007, 08:39 AM

usually i dont pres save changes and it wokrs

Flame254 · 07-29-2007, 03:11 AM

it says "Can't connect to MySQL on server 'localhost' (10061)" I installed AC Web Ultimate Repack, and that's what it says.

Azax · 07-30-2007, 08:10 AM

Then your not connected to your SQL..

Random Noobie · 07-30-2007, 09:37 AM

How do I connect to my SQL? Im having the same problem.

blackout224 · 07-30-2007, 08:14 PM

guys i get error 1045 using password yes how can i make it work

jordanb301 · 08-05-2007, 02:04 AM

WHAT THE FUCK! It says access denied, what do I do?

szela_93 · 08-05-2007, 09:55 AM

if u even touch even open mysql conf file ur db will screw and u'll hav to reinstall it

08-05-2007, 12:29 PM

lol meybe sometimes use your brains ok ? ^ ;)

alkaiser · 08-08-2007, 09:26 PM

well, apparently you didn't start up mySQL, which is step 1 in starting up your server. Do that first, then run navicat

hestonf50 · 08-11-2007, 04:02 AM

i cant get that big table

killerbot23 · 08-17-2007, 03:55 PM

pfft cant connect to local host error...

jibidy · 08-21-2007, 03:03 AM

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..

Icelord · 08-21-2007, 04:30 PM

nvm got it now

Alcohobbiest · 08-27-2007, 01:48 AM

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?

imfamous08 · 09-03-2007, 01:03 AM

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?

lilnate22 · 09-03-2007, 01:07 AM

Quote:

Originally Posted by imfamous08

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???

imfamous08 · 09-03-2007, 04:18 AM

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.

sae6996 · 09-03-2007, 04:19 PM

if your geting a 1045 put pass word as ascent insted of antrix

Oreoshakes · 09-07-2007, 12:58 AM

"Can't connect to MySQL on server 'localhost' (10061)" same error for me

damon166 · 09-08-2007, 07:47 AM

i get error 1045 using password yes how can i make it work???

streamshot · 09-12-2007, 11:54 AM

thanks sae6996!!... that sorted it

holyyo · 09-13-2007, 03:31 AM

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

08-21-2007, 04:30 PM	#16
Icelord Join Date: Aug 2007 Posts: 6	nvm got it now Last edited by Icelord; 08-21-2007 at 05:31 PM. Reason: Automerged Doublepost

09-03-2007, 04:18 AM	#20
imfamous08 Join Date: Aug 2007 Location: TX Posts: 491	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-25-2007, 12:14 AM	#1
Jargs Join Date: May 2007 Posts: 2,236	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

07-25-2007, 12:31 AM	#2
moonfang Join Date: Jul 2007 Posts: 238	Good work jargs !!

07-25-2007, 01:18 AM	#3
Wiggins Join Date: Jul 2007 Posts: 293	thanks for puttin' it with all the pretty colors jargs :-P much appreciated.

07-25-2007, 08:39 AM	#4
szela_93 Join Date: Jun 2007 Location: Poland near Cracow Posts: 1,336	usually i dont pres save changes and it wokrs

07-29-2007, 03:11 AM	#5
Flame254 Join Date: Jul 2007 Posts: 48	it says "Can't connect to MySQL on server 'localhost' (10061)" I installed AC Web Ultimate Repack, and that's what it says.

07-30-2007, 08:10 AM	#6
Azax Join Date: Jun 2007 Posts: 122	Then your not connected to your SQL..

07-30-2007, 09:37 AM	#7
Random Noobie Join Date: Jul 2007 Posts: 7	How do I connect to my SQL? Im having the same problem.

07-30-2007, 08:14 PM	#8
blackout224 Join Date: Jul 2007 Posts: 38	guys i get error 1045 using password yes how can i make it work

08-05-2007, 02:04 AM	#9
jordanb301 Join Date: Aug 2007 Posts: 15	WHAT THE FUCK! It says access denied, what do I do?

08-05-2007, 09:55 AM	#10
szela_93 Join Date: Jun 2007 Location: Poland near Cracow Posts: 1,336	if u even touch even open mysql conf file ur db will screw and u'll hav to reinstall it

08-05-2007, 12:29 PM	#11
ismails Guest Posts: n/a	lol meybe sometimes use your brains ok ? ^ ;)

08-08-2007, 09:26 PM	#12
alkaiser Join Date: Aug 2007 Posts: 6	well, apparently you didn't start up mySQL, which is step 1 in starting up your server. Do that first, then run navicat

08-11-2007, 04:02 AM	#13
hestonf50 Join Date: Aug 2007 Posts: 3	i cant get that big table

08-17-2007, 03:55 PM	#14
killerbot23 Join Date: Aug 2007 Posts: 1	pfft cant connect to local host error...

08-21-2007, 03:03 AM	#15
jibidy Join Date: Aug 2007 Posts: 1	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..

08-27-2007, 01:48 AM	#17
Alcohobbiest Join Date: Aug 2007 Posts: 3	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?

09-03-2007, 01:03 AM	#18
imfamous08 Join Date: Aug 2007 Location: TX Posts: 491	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?

09-03-2007, 04:19 PM	#21
sae6996 Join Date: Sep 2007 Posts: 1	if your geting a 1045 put pass word as ascent insted of antrix

09-07-2007, 12:58 AM	#22
Oreoshakes Join Date: Sep 2007 Posts: 1	"Can't connect to MySQL on server 'localhost' (10061)" same error for me

09-08-2007, 07:47 AM	#23
damon166 Join Date: Sep 2007 Posts: 13	i get error 1045 using password yes how can i make it work???

09-12-2007, 11:54 AM	#24
streamshot Join Date: Sep 2007 Posts: 6	thanks sae6996!!... that sorted it

09-13-2007, 03:31 AM	#25
holyyo Join Date: Aug 2007 Location: michigan Posts: 34	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