Tags » Mysql

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

When i have try to login mysql, I got below error

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

I have searched a lot, and finally got following result…

128 more words
PHP

Clearing Magento after testing

***********for categories********************
TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`; 994 more words

Magento

Konfigurasi apache sebagai backend dan nginx untuk frontend

seperti yang kita ketahui bahwa nginx dan apache keduanya sama-sama webserver
lalu kenapa harus menggunakan keduanya?

Nginx merupakan webserver yang ringan dan minim penggunaan resource memory, 788 more words

Programing

The Power of a simple SET...

Recently, I installed a new local MySQL Server with the purpose to log debug messages.

But because I had to log a lot of messages disk space became an issue. 89 more words

Using case in query

using case to choose select conditions when selecting could be based on variable ( > 0 , NOT NULL …). For ex:

select *, case…

137 more words
MySQL

Fixing column encoding mess in MySQL

The column (actually the whole table) was created with DEFAULT CHARSET cp1251. Most of the data was in proper cp1251 national encoding indeed. However, because of web application failure to properly set the encoding, some of the rows were actually in UTF-8. 164 more words

Mysql

MySQL - List All Tables and Describe Tables

Connect to the database:

mysql [-u username] [-h hostname] database-name

To list all databases, in the MySQL prompt type:
show databases

Then choose the right database: 23 more words

DataBase