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 [...]
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.
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 [...]
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. [...]
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 [...]