Linux stuff

New Mysql Database (and user)

2012-10-30T11:37:11+01:00

Alrighty, it's an easy one, but I keep going astray. So here's how to set up a new MySQL database and add a user while at it. All at the command line, of course.

$ mysql -u ''adminusername'' -p

mysql> CREATE DATABASE ''databasename'';
mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" IDENTIFIED BY "''password''";
mysql> FLUSH PRIVILEGES;
mysql> EXIT

Pack it up, dude

2011-10-03T14:20:53+02:00

Okay, I just realized that giving instructions on how to unpack archives is neat - but about creating tar.gz archives?

Easy: Just use

tar -cvpzf <output filename> <directory>
this means:
-c = create new archive
-v = be verbose
-p = preserver permissions
-z = compress using gzip
-f = filename to create for the new archive

for the directory dont to "directory/*" just to "directory" with no slash

filenames should end in ".tar.gz" as they are tarr'ed then zipped

Finding a string in text files

2011-04-11T21:33:50+02:00

One of the great things with Linux is that almost all files are out there in the open. Configuration of the OS, application config files, php files of your webserver, etc. There's only one problem: there's way too many files to find what you're looking for. Now what?

Unpack that stuff

2011-03-29T23:18:51+02:00

Well, well, the old lady let you move back in, did she? Time to unpack your bags, then.

In case you happen to be a Linux or Unix server, that might be a bit of an issue. Sure, we all know what to do with zip files in Windows - but what about them tar or gz files? No worries - Bubba to the Rescue.

Here's what you do:

To unpack a tar.gz file, you can use the tar command from the shell. Here's an example:

tar -xzf bubba.tar.gz

The result will be a new directory containing the files.

Of course, this was the way we did things back then in the old days. Nowadays, when you download the tar.gz from a web browser, a lot of times an unpacker will open - and you can just use that. But that's for whimps. Or Yankees. Or both.

For just .gz (.gzip)

In some cases the file is just a gzip format, not tar. Then you can use:

gunzip bubba.gz