+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: [Guide] Setup an new User on Navicat (/showthread.php?tid=1846)
- DrGenius - 05-18-2013
Hellos guys there an new tutorial to setup an new mysql user from navicat i will do it from an simple and easy way using navicat, u can use the new user u make to connect to your vps/dedicate server database or just to connect your tools.
Lets start!!
Click on User Click on New User
Click ON General Fill these box with ur information. Save it Click ON Server Privileges Click on Privileges
There we will give the privileges we want that this user have make.
Server Privileges Select the privileges
There u will be able to give privileges to the databases u want.
example, if you want that user only can access to an specific database there u will be able to do this.
Privileges Add Privileges
Select the databases u want that the user have access Select the privileges u want that this user have on the selected databases Click Ok Click Save
Thats all, really easy i just make it cuz maybe some peoples dont know.
if i forgot something sorry but im asleep >.<
- RomainLastChaos - 05-18-2013
This will help everyone for connect editor to the database
+1 bro- redbull - 05-19-2013
dont halp me it
- DrGenius - 05-19-2013
dont halp me it
its not clear? or what u need to know.
- RomainLastChaos - 06-05-2013
dont halp me it
the only mistake you can make is put in host your ip and not %
but you need put %
the ip is already setting
after to connect ur database or tools u need just ur ip not % and user and password that all
- soryjero - 06-05-2013
i have made a exactly guide some days ago and tried to post here but it wasnt appear. i think some mod dont approve it and now, a guide has been posted like video i made :blink:
2
- Noizy - 06-05-2013
i have made a exactly guide some days ago and tried to post here but it wasnt appear. i think some mod dont approve it and now, a guide has been posted like video i made :blink:
2
why need video, just install mysql and other addons for server, open navicat create connection with SSH and thats all, why need 4min
- soryjero - 06-05-2013
why need video, just install mysql and other addons for server, open navicat create connection with SSH and thats all, why need 4min
to help people that dont know how to do it. in the video you can see it perfectly how to do all steps
- DrGenius - 06-05-2013
soryjero just make another post and dont come here to blame, thanks^^
- soryjero - 06-05-2013
i think it isnt needed to make a new post.
you have explained it well :clapping: