[Question] How to use Navicat? :s Help!

[Gadella]

Hey!

I have made a private server - not public yet - but i still need to add new items / vendors and stuff myself, and i dont have Navicat. Im new at this so i could need some help with this - (Get items and stuff in with help from WoW-V)

Hope you are willing to help me - PLEASE

Thanks on purpose! And thank you =)

[~SaiLyn~]

Well to start off you need MYSQL ----Get MYSQL Community Service

MySQL AB :: MySQL Downloads



Now you may either get navicat

Navicat - the World's Best MySQL Front End for Windows, Linux & Mac OS X


HeidiSql

HeidiSQL - Download


OR

SQLyog


MySQL GUI Tools, MySQL Monitor, MySQL Manager, MySQL Performance Tuning and Optimization

[Gadella]

Well to start off you need MYSQL ----Get MYSQL Community Service

MySQL AB :: MySQL Downloads



Now you may either get navicat

Navicat - the World's Best MySQL Front End for Windows, Linux & Mac OS X


HeidiSql

HeidiSQL - Download


OR

SQLyog


MySQL GUI Tools, MySQL Monitor, MySQL Manager, MySQL Performance Tuning and Optimization

Okaay.. Now i got that! But i asked what to do! That's the problem ;b and what would you recommend?

[Viter]

I would say Navicat. get a crack ore get the free version.

[latruwski]

and about working with it... read guides posted all arround on the forums and other forums

grtz

[Gadella]

I would say Navicat. get a crack ore get the free version.

Still havent got explained how to START it up / use it!

[Ravenouzly]

What repack are you using? Chrispee,AC,Emiloz,2dgreengiant's? I only know Chrispee's (barely at that)

[latruwski]

Still havent got explained how to START it up / use it!

if you dont understand what i am going to write, pls to try to start a server lol

1. Install MySQL (download and install)
2. Configure MySQL as you wish
3. Start Navicat or some other SQLprogram
4. connect to you MySQL server with navicat (using the password you had to configure in step 2)
5. make a new DB with navicat call it wathever you wnt but keep the name in mind you will need it for the config files later
5.1. import DB
6. import char/logon DB if needed
7. get a ascent core
8. configure conf files
9. create an account with a simple insert query
10. play the server


there are posted tons of guides on this forum... for navicat, how to start a sever and much more! use search

grtz

[Ravenouzly]

Anyway, if you're using Chrispee's repack, you should have an empty database, a SQL file, and navicat/SQLyog/Heidisql(or something). The first thing you have to do, is go into Navicat, create a connection, and a Database. Then restore from a SQL dump, go find the SQL file that came with the repack and execute it. This will take a while, so go have lunch, watch TV, or whatever. After that's done, you should click the table that says accounts, and find Table Data( or something of the sort, I'm trying to guide you thru NaviCat, while I have SQLyog ) and create some accounts. Make sure all the accounts are flagged 8(You can change the flag somewhere in the table data, it's default 0), else they won't have TBC content, which is, well, bad. Erm... what else to add. I can't really guess about more NaviCat info, so... I hope it helped. A little atleast :P

[Gadella]

When i install MySQL and make a pass and stuff at last part where i press execute (When i pressed execute is says:

Prepare Configuration (OK)

Write configuration file (OK) (C:\Program Files\MySQL\MySQL Server 5.0\my.ini)

Start service (OK)

Apply security settings (Failed)

The security settings could not be applied.
Error NUmber 1045.
Acces denied for user 'root'@'localhost' (using password: NO)

[~SaiLyn~]

if you dont understand what i am going to write, pls to try to start a server lol

1. Install MySQL (download and install)
2. Configure MySQL as you wish
3. Start Navicat or some other SQLprogram
4. connect to you MySQL server with navicat (using the password you had to configure in step 2)
5. make a new DB with navicat call it wathever you wnt but keep the name in mind you will need it for the config files later
5.1. import DB
6. import char/logon DB if needed
7. get a ascent core
8. configure conf files
9. create an account with a simple insert query
10. play the server


there are posted tons of guides on this forum... for navicat, how to start a sever and much more! use search

grtz

LOL he cant use search beacuse his on leecher status

[Viter]

LOL he cant use search beacuse his on leecher status

Hes a site noob= search function enabled