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 […]

Categories
Server

The Best Linux Distribution for your Web Server

So you have made the step into the world of server management and maintenance, either with a local or cloud based server. The next step is to choose which Operating System you want on your server, and if you have a decent brain on your head you will decide to use a linux kernel for […]