Setup MySQL error on Ubuntu 14.04

May 10, 2014 25.5k views
Hi, Excuse me for my ignorance, but I have a problem. I am using Ubuntu 14.04 and just create it. In "Step Two - Install MySQL Data to Manage Site" (https://www.digitalocean.com/community/articles/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-14-04), appears this Warning: 140510 18:00:33 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. Soon after, in step "sudo mysql_install_db" appears: Installing MySQL system tables... 140510 18:01:58 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. OK Filling help tables... 140510 18:01:58 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h MaisSolutions password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ What can be? Do you have a solution? Thank you very much! Best regards, Leandro Naves
3 Answers
As it told you, use "key_buffer_size" in /etc/mysql/my.conf instead of "key_buffer" :-)

Best.

What this bug affects ? because i see that is ok even with it :-/

Have another answer? Share your knowledge.