GRANT ALL PRIVILEGES ON mydatabase.* TO 'my_new_user'@'localhost' IDENTIFIED BY 'a great password';
Creates user and gives them privileges at once. Probably follow up with FLUSH PRIVILEGES
Categories
Categories
Moving Site Off Nginx
When you move a website and change its DNS A record you will need to delete it from the old Nginx server. Otherwise when Nginx reboots (e.g. after a certificate renewal) it will fail DNS resolution.
I believe this can be changed, but by default Nginx will break when the DNS connection (even of an unrelated site) changes.
Categories
Laravel 5.5 Carbon Wrapper
Tip: if you are on #Laravel 5.5 and enjoy Carbon, be sure to use IlluminateSupportCarbon instead of CarbonCarbon. It's a wrapper class, 100% macroable, and allows you to set a custom json serializer. ? pic.twitter.com/mE8xbpYrAu
— Raul (@rcubitto) December 20, 2017
Categories
Mac Homebrew Dev Environment Stuff
Restart Apache
sudo apachectl restart
Apache Config
/usr/local/etc/apache2/2.4
Categories
.htaccess force SSL
[code]RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.example.com/$1 [R,L][/code]
From inMotion Hosting
Categories
KEYBOARD LAYOUT
Left Alt + Shift to revert to correct keyboard layout.
I never remember this.
Categories
Shopify
https://twitter.com/noncototient/status/905629388758073344
Timber — opinionated, good for getting started
Dhopify — blank slate, more control & more advanced
Categories
Laravel New command not finding Composer
When calling ‘laravel new myapp’ this error is given:
sh: composer: command not found
Composer is aliased in ~/.bash_profile, which apparently doesn’t help the laravel installer find it (despite being in $PATH).
The solution was to copy /Users/me/composer.phar to /usr/local/bin/composer
The Laravel installer could then use Composer to setup the application.
Categories
Mac OS X / Homebrew Notes
which apachectl
/usr/local/bin/apachectl
I expect that response if the Homebrew version of Apache is running.
Restarting PHP FPM on Ubuntu 16.04
Probablyservice php7.3-fpm restart
Maybesystemctl restart php-fpm.service
Homebrew Locally
sudo brew services restart php74