Howto: Create a mysql user and give it permissions on a specific database

If you want to create a user and give it permissions to a specific database you can use these commands

CREATE USER 'myusername'@'localhost' IDENTIFIED BY 'mypass';

If you are using a existing user you might want to remove its access to other databases with this command. If you only invoked the previous command you can skip this step

REVOKE ALL PRIVILEGES,GRANT OPTION from myusername;

The following command will give the user all rights to a specific database:

GRANT ALL ON databasename.* TO 'myusername';

Thats it. You can test if it worked by logging in to mysql using command line (or a program like phpmyadmin) like this:

mysql -u myusername -p

Now enter the password from the user and do:

show databases;

You will now only see the database the user has access to and the information_schema database

Change brightness on Fedora lxde

This tutorial was written for the Fedora lxde spin.

When you are new to Lxde – like me – it can be hard to find some basic options at first. The brightness settings -also called backlight settings- took me a while to figure out.

To change your brightness in Fedora 16 lxde:

Use your preferred editor to change the value in this file: 

/sys/class/backlight/acpi_video0/brightness

The minimum value is 0 (darker) and the maximum value is 7 (brighter).

Skype will not start on fedora 64bit

If you have this problem its because the standard install from the website is missing some libraries.

In a terminal window:

ldd /usr/bin/skype

It is possible you will get this:

not a dynamic executable

This solved that for me:

yum install ld-linux.so.2

And then do this again:

ldd /usr/bin/skype

You will get a list of libraries. the once who return not found need to be installed.
You can do this with:

yum install libraryname

Do this for all the libraries and Skype should work

Having a problem with using the android sdk on Fedora?

I had this error while installing Android sdk today:

error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

When I locate the file it was there but it seemed to look in the wrong place. So I was setting path’s and making symlinks but that did not solve the problem. The solution is actually more simple:

yum install glibc.i686 glibc-devel.i686 libstdc++.i686 zlib-devel.i686 ncurses-devel.i686 libX11-devel.i686 libXrender.i686 libXrandr.i686

The reason this happens is because you are using a 64 bit system and the android sdk is 32 bit. The packages above are the 32bit packages.

If it still doesn’t work you need to set your path.

More info on the Fedora Wiki.

Remember ACS Law? Good news!

Remember ACS Law? The guy who thought it was a good idea to blackmail and extort people because they had downloaded some music. Of course it was all perfectly “legal” and they where making nice money of us hard working people, until Anonymous started to target them as part of “operation payback”. The result: a dead law firm and a destroyed career for the evil guy: Andrew Crossley.

Crossley got suspended for 2 years yesterday. Read more about it on torrentfreak.

Hurray!

 

Piwik

I started using Piwik on this site.

Piwik is a statistic tool like Google Analytics that you can host yourself. And best of all: It is open source.

It supports some cool functions like real time statistics, customisable widget dashboard and nearly all the things you know from Google Analytics .

If you are looking for some decent stats and don’t want to google all about your site try Piwik.