| Lesson learned database | Description |
|---|---|
| Database access | A client accessing the database may not have full access to the database due to which the issue may be arising |
| Database not collaborated with an organisational system | The organisation may not have integrated the database with the database of the Future IT due to which changes made on the organisational database are not shown on the database services of Future IT |
| Incorrect commands | The client may be used incorrect commands to access the database due to which they may be facing difficulty to accessing it |
| Unstable internet | The client may have unstable internet due to which database services might have been impacted |
| User not able to save data ,access data,retrieve data | Check the database that user is trying access has been collabrated with centralised Database. Use the command - telnet hostname port |
| Can check user credential access permission levels,depending on the type of database that the client is using commands might change. | SHOW GRANTS FOR 'username'@'host'; This command will show the permissions that the user holds on the database. |
| Can network stability by evaluating the connection strength and spot any errors or weak spots before they cause a crash | PING is a tool that sends packets to a target server and listens for a reply. A successful reply of all (100%) of the packets delivered means the target is up and running and there are no connectivity issues. Can also use TRACERT tool that sends packets to every single router that lies between the host and the target server. |