Typeperf – Windows Command Line Monitoring Tools

typeperf is a good tools for Windows IT Professional to monitoring their server/PC through command prompt instead of GUI interface.

To understand more on typeperf, simply type in typeperf /?

To get all of the counter that can be listed in typeperf, you may enter the following command,

C:\> typeperf –q > c:\counter.txt

To define a counter live from your PC,

C:\> typeperf "\processor(*)\% Processor Time"

If you prefer to get from remote server,

C:\> typeperf "\processor(*)\% Processor Time" -s mickgenie.localhost

 

Commonly used permission set in MySQL

Here is some MySQL permission set that I am normally used, I am now sharing them to you.

1. Standard step to create database and grant all permission to mickgenie_wordpress.

mysql>create database mickgenie_wordpress;
Query OK,1 row affected (0.00 sec)
mysql>grant all on mickgenie_wordpress.* to [email protected] identified by 'password';
Query OK,0 rows affected (0.00 sec)

2. Grant create view on mickgenie_user to database mickgenie_wordpress.

mysql>grant select,insert,update,delete,create,drop,index,alter,create temporary tables,lock tables ,CREATE VIEW,CREATE ROUTINE,REFERENCES,EXECUTE,ALTER ROUTINE  on mickgenie_wordpress.* to [email protected] identified by 'password';
Query OK,0 rows affected (0.00 sec)

3. Grant remote access to mickgenie_wordpress.

mysql>grant all on mickgenie_wordpress.* to [email protected] identified by 'password';
Query OK,0 rows affected (0.00 sec)

4. Grant read only user to mickgenie_wordpress.

mysql>grant select on mickgenie_wordpress.* to [email protected] identified by 'password';
Query OK,0 rows affected (0.00 sec)

phpMyAdmin Socket Error

If you are webmaster who using the web interface database management, you shall be familiar with phpMyAdmin.

Then you might get these error from your phpMyAdmin when you logged into the phpMyAdmin.

#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)

To overcome this error, you could have 2 ways to solve the problem.

Method 1:

Check if your mysql.sock file missing from /tmp.

If it is really missing from /tmp, you may create a symbolic link from /var/lib/mysql/ to /tmp.

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

You might ask why must do this, you may check the file from /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php and you need to check for the setting of cfg[‘Server’][‘socket’],  and you will see the setting set to /tmp/mysql.sock.

Method 2:

Edit the following file.
/usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

Find $cfg[‘Servers’][$i][‘host’], change the value from localhost to 127.0.0.1.

Lowest Numbered MX Record Points to localhost

If you are using cPanel server and you might get this error from your exim_mainlog very often whenever sending and receiving email.

temporarily rejected RCPT <[email protected]>: lowest numbered MX record points to localhost

The reason of this error message is the domain.com is missing from either the /etc/localdomains file or /etc/remotedomains file. The difference between two of these file is that, they decide whether the email has to be delivered locally or through a remote server by the exim email services.

To get it fix, add your domain.com to /etc/localdomains file to last line(new line each domain).