Categories
Server

Debian 7 (WheezY) Cheat Sheet

Check php version (command line): php -i unzip a .tar: tar -xvf file.tar unzip a .tar.gz: tar -xzvf file.tar.gz Virtual Host Setup: 1. Place the WebSite Files in /var/www/[Folder name] 2. Navigate to /etc/apache2/sites-available 3. Create a new file [SiteName], and nano the vhost 4. Create a symlink in /etc/apache2/sites-enabled with: a2ensite [siteName] 5. Restart […]

Categories
Database SQL

Create a New MySQL User that only has access to a Particular Schema and Table

Create New MySQl User with Privileges GRANT ALL PRIVILEGES ON dbTest.* To ‘user’@’hostname’ IDENTIFIED BY ‘password’; So for example: Log in to Mysql… mysql -u [root] -p Then type: GRANT ALL PRIVILEGES ON [schema]. To ‘[user]’@'[hostname]’ IDENTIFIED BY ‘[password]’; How to View Current Users and Privileges SHOW GRANTS; or select user,host from mysql.user;

Categories
Wall of Shame

DO NOT BUY From Rampage Gaming

Never Buy From Rampage Gaming This post serves as a warning to all potential clients of Rampage Gaming. It is a fraudulent company, that receives payments but does not deliver the goods. Please make sure that you DO NOT BUY anything, ever from Rampage Gaming.           The Website (Online Store) of […]

Categories
Uncategorized

Starting a Project with Yii Framework

Downloads to Start with: 1. XAMPP 2. MySQL Workbench 3. Yii Framework   Steps to Get Environment Set Up: 1. Extract Yii Framework folder to a directory in xampp, create a new folder called library. 2. There is a folder in the yii directory called requirements, take that copy and paste into /xampp/htdocs 3. open: […]

Categories
Uncategorized

Cheat Sheet

View Hidden Files and Folders from:   windows: dir /a   linux: ls -a Remove a folder cmd:   rmdir /s /q “C:\xampp\htdocs\[folder_name]” View PhpInfo from CMD: php -i or php -r “phpinfo();” Create an Empty File (.htaccess) CMD: echo.>.htaccess Per Site Config Chnges in .htaccess Add the following to .htaccess: php_flag display_startup_errors on php_flag […]