if your wordpress links not working, is redirected or url have this text: eval(base64_decode($_SERVER[HTTP_REFERER])) your WordPress Has Been Hacked! Malicious codes, especially those that interpreted with eval() or base64_decode() command been inserted into WordPress PHP files or in database. Solution for nasty ...

Linux - for mysql tunning use MySQLTuner script. MySQLTuner is a script written in perl that will assist you with your MySQL configuration & make recommendations for increased performance and stability. Download the latest MySQLTuner version in plain text to your ...

Solution is simple, use mysql_insert_id() php function. mysql_insert_id() returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement. Use this function after you have performed an INSERT statement into a table that contains an AUTO_INCREMENT field, ...

Dupa un update recent la ultima versiune pentru phpMyAdmin am avut surpriza sa nu ma pot loga in mysql ( baza de date ). Eroare: #1045 - Access denied for user 'root'@'localhost' (using password: NO) ce este de facut. Intrati in folderu /usr/share/phpMyAdmin/ si ...

MySQL tuning - MySQL query cache: To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini) For linux /etc/my.cnf 1st: set query_cache_type to 1. (There are 3 possible ...

Default config file installed by RPM is : /etc/my.cnf so read /etc/my.cnf should be like: [mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock ... Default databases (datadir) is located in: /var/lib/mysql/