Creating MySQL database and user from command line

Posted on 2010-12-21 by Mikko Ohtamaa

This serves as my own notes – I always forget the syntax.

Prerequisitements

How to deal with UNIX command line programs

Use MySQL command to login to running MySQL instance. If this is on local host you can try

mysql -uroot # no password

mysql -uroot -p # asks for password

Use -H option to connect to external MySQL host (on shared hosting).

Then create a new database using CREATE DATABASE command. Here we create a database called joomla.

mysql> create database joomla;
Query OK, 1 row affected (0.00 sec)

And then we create a MySQL user whose access is limited to this database only. In this case we create admin user with admin password. Note that MySQL accepts local connections only by default, so MySQL or this user is not exposed to Internet (and potential attacks).

Username is joomla and password is joomladbpassword.

GRANT ALL ON joomla.* TO 'joomla'@'localhost' identified by 'joomladbpassword';

… and now you can proceed to install Joomla.

$\"\"$ Subscribe to RSS feed Follow me on Twitter Follow me on Facebook Follow me Google+

How to fix OSX: Cannot login: FileVault is corrupted

Posted on 2010-12-15 by Mikko Ohtamaa

OSX provides home folder encryption system called FileVault. FileVault is effectively a sparsebundle file in your home folder, storing all your data, and is mounted as a loopback volume during the login.

If your Mac loses power on a wrong moment FileVault might become corrupted. This will lead to a situation that you cannot login to the system anymore. The login dialog will just tell “Volume is corrupted. Would you like to repair?” And then it says something along lines “login failed”.

Don’t lose your hope here. You can usually still fix the corrupted FileVault sparsebundle file as root user.

1. To create a root user

Use OSX installation DVD to add new admin user to the system with non-protected folder
…or in the case you have non-admin user accounts on the system already, use them to login, navigate to System preferences -> Accounts and create a new admin account. Note that you can use your credentials from the corrupted user to make admin level system changes even if the logged in user is not admin – just click the lock icon in the System preferences.
An admin user can enable root user. To enable root user, you need to navigate to /Macintosh HD/System/Library/CoreServices open Directory Utility and choose Enable root user from the menu (Snow Leopard)
Logout. Then login dialog should have new option “Other” where it allows you to type in username and password. Now login as root with the password you set for it earlier.

2. To fix the damaged sparsebundle file

Login as root
Open Application -> Utilities -> Disk utility
From menu choose Open
Choose /Macintosh HD/Users/corruptedusername/corruptedusername.sparsebundle file
Disk Utility will complain about something it cannot mount volume, but the volume still will appear in the right hand disk list
In the disk list choose the corrupted volume
Hit repair
The repair process will take minutes, but completes succesfully

After the repair process is complete, logout as the root user and login as the user who had damaged FileVault. This time the login success.

3. More info

Repairing a FileVault protected Home folder

$\"\"$ Subscribe to RSS feed Follow me on Twitter Follow me on Facebook Follow me Google+

Paste as plain text in Google Chrome – The most useful hidden feature

Posted on 2010-12-10 by Mikko Ohtamaa

Background: you are writing blog post or rich text email in a web browser and you want to include text from other web page. The normal copy-paste functionality copies the styles of the source material, usually messing up your blog post or message.

It doesn’t have to be so.

In Google Chrome web browser, you have Paste as plain text functionality. Just hit CTRL+SHIFT+V for paste as plain text. You don’t need no longer recycle all text through Notepad or other plain text editor.

This functionality is not available through menus, only through this keyboard shortcut.

$\"\"$ Subscribe to RSS feed Follow me on Twitter Follow me on Facebook Follow me Google+

python.fi – Finland interest group has now web presence

Posted on 2010-12-09 by Mikko Ohtamaa

I finally managed to squeeze together some workhours to launch a web site for Python Interest Group Finland.

python.fi

The site is in Finnish as the target audience mostly speaks this ancient mumbling. If you have any updates please follow the insructions on the site to post them.

Our next goal is to organize the second Python event in Finland and/or create a non-profit organization around Python activities here.

The site runs on Google Appengine. All code is licensed under permissive open source licenses and available from Github. Thanks for Hexagon IT for kindly hosting the domain name.

$\"\"$ Subscribe to RSS feed Follow me on Twitter Follow me on Facebook Follow me Google+

Open Source Hacker

Pushing the boundaries of free technology

Monthly Archives: 2010-12

Creating MySQL database and user from command line

Paste as plain text in Google Chrome – The most useful hidden feature

python.fi – Finland interest group has now web presence