Category Archives: Guides

mySQL ERROR 2002

ERROR: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

solution:
You need to install the server package:

sudo yum install mysql-server

After installation, you have to start the service:

sudo service mysqld start

and dont forget to secure install

sudo /usr/bin/mysql_secure_installation

Truth about Videocards/GPUs

Ex. AMD Radeon HD 677/ Nvidia GeForce GTX 780

  • The first digit is the generation (2nd Important)
  • The second digit is the performance indicator (Very Important)
  • The third digit is a refined performance indicator (Least Important)
  • The forth digit is often just 0


Performance indicator numbers: 
(red number)
1: Intergrated graphics product, very low performance
2: Low performance
4-3: Low-Mid performance
5-6: Midrange performance
7-8: High performance
9: Ultra High performance

Examples:
High Performance ang AMD Radeon HD 6770 at Nvidia Geforce GTX 770.
Low-Mid Performance ang AMD Radeon 6470 at Nvidia Geforce 530

So when it comes to performance. the higher the second number the better.
So AMD HD 5000 series… 5450<5550<5570<5670<5750<5770<5830…
if combined AMD HD 4000 series… 4350<5450=4550<5550<5570=4670<5670<575…

not only memory is important to look at you also need to check other like:
(red as the most importantand green as second most important.)

Architecture
Pipelines
Pixel/Vertex Shaders
Core Speed (here you could know if you could overclock it. Nvidia has base boost feature)
Shader Speed
Memory Speed
Memory Bus Width ( 64bit/128bit/256bit etc.)
Memory Type (GDDR5/4/3)
Memory Size (ng GPU) (here we usually look at which we should not.  the 2GB 1GB…)
Technology
Power Consumption
DirectX Support (11 up)
OpenGL Support
Physx Support ( Nvidia only)
CUDA

How to Reset Your WordPress Password From the Database

From time to time you may encounter an unusual situation wherein you need to reset your WordPress password but you no longer have access to the email address associated with your account.

Here’s a quick MySQL snippet that will change your password

# Reset Password
UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';

Instructions for use:
1. Replace the new_password with your new password.
2. Replace your-username with your username.
3. Fire up phpMyAdmin and go to your database.

Open the SQL tab.
Paste the above snippet into the text field and click on the Go button.
You should now be able to log in to your WordPress site using your new password.