 
			
				01-03-2018, 10:28 PM
			
			
			
		  
	 | 
	
		
		
		
			  | 
			
			
				
				
				 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    
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 |