September 17, 2011 | Web/Software Development

MySQL

While creating a MySQL user on the command line, you might run into this error: mysql> GRANT ALL PRIVILEGES ON mydb.* TO ‘myuser@localhost’ WITH GRANT OPTION; ERROR 1470 (HY000): String ‘myuser@localhost’ is too long for user name (should be no longer than 16) The problem is that the single quotes surround both the username and [...]

Continue ...

Explore related content: , , , ,


April 29, 2010 | Developer

MySQL

A handy tool to manipulate MySQL is the MySQL MySQL Query Browser. It’s from MySQL AB (the company that makes MySQL).

Click through to find out how to create a database using the Query Browser.

Continue ...

Explore related content: , , , , ,


January 5, 2010 | Developer

MySQL

I blogged before about the different versions of the MySQL database, which is the most commonly deployed database on the Internet, the one favored by most free and open source software, and the one that WordPress uses. Monty Widenius, the erstwhile head developer for MySQL, sold his company to venture capitalists, and later the company [...]

Continue ...

Explore related content: , , , , , , , ,


April 12, 2009 | Developer, Web/Software Development

I was surprised to know that Facebook runs on PHP. It also uses C++ and Java in places, but it’s the fact that it uses the little scripting language that could (PHP) is what is interesting. Aditya Agarwal of Facebook describes how the social networking giant does it in a presentation at QCon SF 2008. [...]

Continue ...

Explore related content: , , , ,


April 3, 2009 | Developer, Software and Downloads, Web/Software Development

Of late, there isn’t just one version of MySQL being used anymore. First, there’s the version of MySQL offered at mysql.com by the former MySQL, AB, which was bought by Sun for one billion dollars. Then, there’s MariaDB being offered by Monty Widenius, former head at MySQL, AB. Percona claims to be the high-performance MySQL [...]

Continue ...

Explore related content: , , , ,