Portal Home > Knowledgebase > Articles Database > mysqld.log not found on the server?

mysqld.log not found on the server?

Posted by akasharya, 07-21-2010, 09:09 AM

Guys can you tell me whats the mysqld log location in cpanel/whm environment? I checked in /var/log but there is no mysqld.log file exist...also checked in /var/lib/mysql directory only $(hostname).err file exist but it is not enough for monitoring. I checked in my my.cnf and only found these 3 lines:- [mysqld] set-variable = max_connections=500 safe-show-database I tried to use find command(find / -name mysqld.log) but nothing found in output, can you guys please help? Is there any otherway to check whats going on in mysqldatabases? what is the correct syntax to use "mysqladmin proc stat"?

---

Posted by madaboutlinux, 07-21-2010, 10:12 AM

The mysql log file on a cPanel server is /var/lib/mysql/hostname.err It provides basic logs, however, you need to define the kind of logs you want in the /etc/my.cnf file and restart the mysqld service. The "hostname.err" file will start logging the logs as defined in my.cnf file.

---

Add to Favourites    Print this Article

No SOA record on the server (Views: 791)

Reseller Question (Views: 737)

Tomcat (Java Servlet) Reseller? (Views: 797)

.Sql to .CSV (Views: 847)

Can anyone share what the meaning of this code? (Views: 764)