Remote Allow mysql connection | SSH Commands

Enter your ssh server
OR if you are on the Windows PC, then install the Putty software and log in to your main server 
You can download the Putty Here - https://the.earth.li/~sgtatham/putty/latest/w64/putty.exe 


paste line by line on the command screen  


mysql -u root -p 
CREATE USER 'xcodeswhmcs'@'localhost' IDENTIFIED BY 'password'; 
GRANT ALL PRIVILEGES ON * . * TO 'xcodeswhmcs'@'localhost'; 
GRANT ALL ON *.* to xcodeswhmcs@'XXX.XX.XX.X' IDENTIFIED BY 'password'; 
FLUSH PRIVILEGES; 
quit 

where says "password" enter a password to your liking plus take note that it will be necessary and important to access the WHMCS Portal 
where has this 'XXX.XX.XX.X' replace with the WHMCS Portal IP (Example xcodeswhmcs@'123.56.78.9' Module has been installed
  • mysql, Comando SSH
  • 1040 Users Found This Useful
Was this answer helpful?