Monday, March 16, 2015

MySQL database and user creation reminder

MySQL database and user creation reminder 



CREATE DATABASE DATABASENAME;

GRANT ALL PRIVIEGES ON DATABASENAME.* TO "USER"@"HOST" IDENTIFIED BY "PASSWORD";

FLUSH PRIVILEGES;

Enable Permalink/Clean URLs (hebrew) in WordPress

Wordpress notes: 

Enable "clean URLs" :


For hebrew ,
1-  change apache default encoding to utf-8
2- enable mod_rewrite :

To enable it the rewrite module, run "apache2 enable module rewrite":
sudo a2enmod rewrite
You need to restart the webserver to apply the changes:
sudo service apache2 restart
If you plan on using mod_rewrite in .htaccess files, you also need to enable the use of .htaccessfiles by changing AllowOverride None to AllowOverride FileInfo. For the default website, edit /etc/apache2/sites-available/default:
    
            Options Indexes FollowSymLinks MultiViews
            # changed from None to FileInfo
            AllowOverride FileInfo
            Order allow,deny
            allow from all
    
After such a change, you need to restart Apache again.
3. Change Settings->Permalink settings in WP