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;
Author: me
Categories
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 […]
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
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 […]
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 […]