Posts Tagged ‘standpoint’

USB Stick – Holy Scriptures of Roman Catholic Bible

Saturday, June 16th, 2012

While browsing the internet, I've found an interesting "gadget" a USB made to look like a holy bible cover. The Holy Bible distributed is Roman Catholic. This probably means Roman Catholics has already approved and blessed the distribution of the Holy Bible in digital form.


Though I think the digital distribution of Holy Bible is a good think I think it is better the primary source of distribution of the Holy Bible be the now almost old fashioned paper form. If the Holy Bible (Holy Scriptures) and livings of the saints are primary distributed in a digital form over the internet. This could mean that there disappearance could happen very quickly if the Internet is filtered or the information on the Internet gets encoded not to include certain texts. Though from current standpoint encoding certain content on the Internet seems like impossible, I'm quite sure in the short future this will be possible. In a way that certain texts which are talking things against the governmental powers could be possibly filtered out … I truly hope this will never happen but it is one possible scenario that might come true.  Bill Gates has already a vision for disappearance of the paper all around the world.Gates desire for abondoning the paper  is stated in his books The Road Ahead. I truly hope Gates book predictions will never come true.

How to make a mysql root user to login interactive with mysql cli passwordless

Wednesday, June 29th, 2011

MySQL Logo Passwordless root login .my.cnf

I’m using access to the mysql servers via localhost with mysql cli on daily basis.
With time I’ve figured out that it’s pretty unahandy to always login with my root mysql password, I mean each time to enter it, e.g.:

root@mysql-server:~# mysql -u root
Enter password:
...

Thus to make my life a way easier I decided to store my mysql root password in order to allow my root admin user to be able to login to my mysql server without asking for password. This saves time and nerves, as I’m not supposed to look up for the password file I store my server mysql root pass.

To allow my mysql cli interface, to login passwordless to the SQL server I had to create the file /root/.my.cnf readable only for my root user and store my MySQL username and password there.

Here is a sample /root/.my.cnf file:

root@mysql-server:~# cat /root/.my.cnf
[client]
user="root"
pass="mysecretMySQLPasswordgoeshere"

Now next time I use the mysql console interface to access my mysql server I don’t have to supply the password, here is how easier is the mysql login afterwards:

root@mysql-server:~# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3520
Server version: 5.0.77 Source distribution

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

mysql>

The only downside of using .my.cnf to store permanently the mysql server root and password is from security standpoint.
If for instance somebody roots my servers, where I have stored my root user/pwds in .my.cnf , he will be able immediately to get access to the MySQL server.

Another possible security flaw with using the mysql passwordless login “trick” is if somebody forgets to set proper file permissions to, .my.cnf

Once again the file should possess the permissons of:

root@mysql-server:~# ls -al /root/.my.cnf
-rw------- 1 root root 90 Apr 2 00:05 /root/.my.cnf

Any other permissons might allow non-privileged users to read the file and gain unathorized admin access to the SQL server.