Skip to content

Instantly share code, notes, and snippets.

View realpack's full-sized avatar
💩
I do shit, again

pack realpack

💩
I do shit, again
View GitHub Profile
local blur = Material("pp/blurscreen", "noclamp")
function draw.DrawBlur(x, y, w, h, amount)
render.ClearStencil()
render.SetStencilEnable( true )
render.SetStencilReferenceValue( 1 )
render.SetStencilTestMask( 1 )
render.SetStencilWriteMask( 1 )
render.SetStencilCompareFunction( STENCILCOMPARISONFUNCTION_NEVER )
render.SetStencilFailOperation( STENCILOPERATION_REPLACE )
@realpack
realpack / super_user_mysql.md
Last active February 20, 2020 07:10
Create User for phpMyAdmin

In terminal, log in to MySQL as root. You may have created a root password when you installed MySQL for the first time or the password could be blank, in which case you can just press ENTER when prompted for a password. If you have forgotten your root password, you can always Reset the MySQL Root Password.

sudo mysql -p -u root Now add a new MySQL user with the username of your choice. In this example we are calling it pmauser (for phpmyadmin user). Make sure to replace password_here with your own. You can generate a password here.

The % symbol here tells MySQL to allow this user to log in from anywhere remotely. If you wanted heightened security, you could replace this with an IP address.

CREATE USER 'pmauser'@'%' IDENTIFIED BY 'password_here';

Now we will grant superuser privilege to our new user.