Anonymous
×
Create a new article
Write your page title here:
We currently have 27 articles on PhenixOps. Type your article name above or click on one of the titles below and start writing!



PhenixOps
27Articles

Tipsandtricks: Difference between revisions

No edit summary
No edit summary
Line 32: Line 32:
|-
|-
| Restart mysql service '''''service mysqld restart'''''
| Restart mysql service '''''service mysqld restart'''''
|-
|Follow the logging '''''tail -f /var/log/mysql.log'''''
|-
|Check mysql service '''''service mysqld status'''''
|-
|}
|}

Revision as of 20:27, 16 April 2020

Issue description
How to troubleshoot it
How to fix it
Cannot connect to database
Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide some info to start troubleshooting from.
Actions
Check load on database server using top
Check the ports using nmap -Pn localhost
Check the ports from remote using nmap -Pn databasehost
Check mysql service service mysqld status
Check the logging less /var/log/mysql.log
Try to login locally on the database server mysql -u root -p
Fixing (you might kill your webserver/application first)
Restart mysql service service mysqld restart
Follow the logging tail -f /var/log/mysql.log
Check mysql service service mysqld status