[Tut] Navicat 8 for MySQL FAQs

Joined
Aug 18, 2004
Messages
641
Reaction score
3
Location
新加坡
Tool(s) required:
It's not a free software, and don't report to me if it expired!
My other tutorials:
http://forum.ragezone.com/f428/guide-hex-edit-your-client-379958/
http://forum.ragezone.com/f428/guide-all-no-low-sql-knowledge-people-380729/
http://forum.ragezone.com/f428/guide-setup-your-web-server-384471/

Requirement:
  • Make sure you have MySQL installed

How to connect Navicate with MySQL service?
Click the Connect button, which located at top left.
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums

The connection window will pop-out, fill up your MySQL information, and click on "Test Connection".
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums

Once it has successfully connected to MySQL, click "Ok'.

Right click on the connection which you just created(if you see more than one connection, then just choose the with the name you just made), and click "Open Connection". In this case I have named my connection "MySQL" on the previous step.
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums

This is how it should looks like when it's connected,
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


Manage Users
Once you have connect Navicat with MySQL service, you can manage the users.
Click "Manage Users", it's located beside "Connection"
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


How to add MySQL user?
Click "Add User"
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


Fill up the blank, put localhost for your host and click "Ok".
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums

hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


Now you have to give permission to your new MySQL user, check "Select, Insert, Update and Delete". Now click "Save".
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


If you want to change or add password for MySQL user, just select the user and click "Edit User", type in the password and click "Ok".

How to create new account?
Double click on `users` table, look at the picture below
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums


A new window will pop-out, click the plus button at the bottom.
hacker_kts - [Tut] Navicat 8 for MySQL FAQs - RaGEZONE Forums

Fill up all the information and you're done.

I guess that's all you need to know.

For you information, this is my first time using Navicat, I don't understand why people having problem using it, it's just so simple. ._.
 
Re: [Guide] Navicat 8 for MySQL FAQs

Reinstall Navicat and make sure you delete the folder too example C:/program files/premiumsoft. If you get this error "Cannot connect to localhost" then reinstall whatever MySQL server you're using for example wampserver.
 
Last edited:
Re: [Guide] Navicat 8 for MySQL FAQs

1045 - Access denied for user 'root'@localhost' (using password: NO)
I get this error, any suggestions?
 
Re: [Guide] Navicat 8 for MySQL FAQs

2003 - Can't connect to mysql server on 'localhost' ( 10061 )

WTF?
 
Back