Tuesday April 18, 2006.

The Solution for the preview problem is that you should prevent clients from connecting as anonymous users without a password, you should either assign a password to each anonymous account or else remove the accounts. For example:

// get rid of the test database.
DROP DATABASE test;

// deal now with the mysql database, which contains administrative information.
USE mysql;

// check that privilege specifications for test% databases exist
SELECT * FROM db WHERE db LIKE 'test%';
// and delete them
DELETE FROM db WHERE db LIKE 'test%';

// check that anonymous users exist for this server
SHOW GRANTS FOR ''@'localhost';
// revoke their privileges
REVOKE ALL ON *.* FROM ''@'localhost';

// and delete them
DELETE FROM user WHERE user = '' AND host = 'localhost';

//Finally, clean up by clearing any caches
FLUSH PRIVILEGES:

Friday April 14, 2006.

In a typical installation, the default access privileges (see http://dev.mysql.com/doc/mysql/en/default-privileges.html) are determined (the default grant tables are created) by running the mysql_install_db utility. These default are insecure:

• Two root users are created, both with empty passwords. A root user can connect from localhost, and other can connect from the same host as the server or the same IP address.
• Two anonymous users are created who have all privileges on databases named test. As with root, one of these users can connect from localhost, the other can connect from the same host only on unix or from any others host en windows. Again, they have not passwords.

Monday March 13, 2006.

Is Open Source and Free Software the Same?

Have you ever used the term open source and free software interchangeably? If yes, you are making a mistake. I find this quite annoying when people who call themselves GNU/Linux gurus does not even know the differences between the two. Most of them consider them the same.

• The gratis/libre ambiguity in the term "free software" produces approximately 80 percent false-positive rate in web searches. After 20 years of advocacy, "free software" is still effectively synonymous with "freeware."
• Use of the term "free software" is in long-term decline, and older or obsolete pages form a larger part of its share than for "open source."

Tuesday February 28, 2006.

The last weekend i was in the Mario Uscanga Exposition, he is painter and lives in Tlaxcala. The Arts painting are excelents and very good, if you want to see the Uscanga Exposition, please enter to the Uscanga Gallery. A demo is this picture.