Below are guideline(s) to setting MySQL Server Port Exception : Go to “Start” menu and search “Window Firewall with Advance Security” and click on it. Right Click “Inbound Rules” and choose”New Rule“. Rule Type, choose “Port” and click next. Protocol and Ports>>Specific local ports>>Type 3306 and click Next. Action choose “Allow the connection” and click ..
Category : MySQL
Below are guideline(s) to increase attachment size : Open the “my.ini” file under the MySQL server install directory. Search for the “max_allowed_packet” parameter. If the file does not have it, add the parameter to the file. Set the value as needed. To set the value to 5M, enter the value as one of the following:max_allowed_packet=5242880 ..
Below are guideline(s) to change MySQL root password Step 1: Step 2: Nb : At pc client – Go to system >> Database manager >> Log on to server Entry Name or IP of server >> Tick Modify Mysql Database Password Y/N >>Key in Root Password and Skybiz password which you set in Mysql ..
Below are the Queries on How to Check Transactions Earlier than the Opening Date on MySQL yog, if Delete Transactions[Posted from Other Modules] is showing Empty 1.) SELECT * FROM JOURNAL1 WHERE D_ATE <= ‘2016/12/31’ AND FINCATCODE NOT IN (‘B55′,’B70’); 2.) SELECT * FROM journal1 WHERE D_ATE <= ‘2016/12/31’ AND acountcode = ‘xxx’; 3.) SELECT * FROM journal1 ..