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:
How to connect Navicate with MySQL service?
Click the Connect button, which located at top left.
The connection window will pop-out, fill up your MySQL information, and click on "Test Connection".
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.
This is how it should looks like when it's connected,
Manage Users
Once you have connect Navicat with MySQL service, you can manage the users.
Click "Manage Users", it's located beside "Connection"
How to add MySQL user?
Click "Add User"
Fill up the blank, put localhost for your host and click "Ok".
Now you have to give permission to your new MySQL user, check "Select, Insert, Update and Delete". Now click "Save".
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
A new window will pop-out, click the plus button at the bottom.
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. ._.
To view the content, you need to sign in or register
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.
The connection window will pop-out, fill up your MySQL information, and click on "Test Connection".
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.
This is how it should looks like when it's connected,
Manage Users
Once you have connect Navicat with MySQL service, you can manage the users.
Click "Manage Users", it's located beside "Connection"
How to add MySQL user?
Click "Add User"
Fill up the blank, put localhost for your host and click "Ok".
Now you have to give permission to your new MySQL user, check "Select, Insert, Update and Delete". Now click "Save".
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
A new window will pop-out, click the plus button at the bottom.
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. ._.