![Old](/forums/images/Darkness/statusicon/post_old.gif)
01-03-2018, 10:28 PM
|
![ChaosSlayerZ's Avatar](image.php?u=100496&dateline=1489668896) |
Demi-God
|
|
Join Date: Mar 2009
Location: Umm
Posts: 1,492
|
|
Quote:
Originally Posted by Akkadius
Creating a MySQL user: (By JSR)
If using Navicat;
- Click 'User' on the main ribbon
- Right click 'root@localhost'
- Choose 'duplicate user'
- In the username field, change it to something preferable to root_Copy (or keep it if you think it has a nice ring to it)
- In the host field, replace 'localhost' with '69.168.254.244'
- In the password/confirm password fields, enter a secure password. Note: A long password (e.g. dogsandcatslikerawfishfordinner) is exponentially more secure than one with uppercase, lowercase, numbers, and symbols while also being much easier to remember
- Under the advanced tab, change 'max user connections' to 1
- Under the server privileges tab, uncheck the privileges 'File', 'Process', 'Drop', 'Shutdown', 'Super', and 'Create user' (there may be others worth disabling)
- Click Save
|
I got a question about this part - how do you do it with HeidiSQl that now comes with server automatic install?
Thank You ![Wink](http://www.eqemulator.net/forums/images/smilies/icon_wink.gif)
|