8

I am following this digital ocean tutorial for Ubuntu 14.04 to install mysql on Ubuntu 16.04 for my Rails projects. I had, maybe wrongly, assumed that the procedure would be the same.

However, when I run the command sudo mysql_install_db, I receive the following error:

2016-06-15 18:40:36 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2016-06-15 18:40:36 [ERROR]   The data directory needs to be specified.

How can I complete the setup? I have successfully followed the same procedure several times in the past on Ubuntu 14.04.

amc
  • 7,292
Jawad Khawaja
  • 183

2 Answers2

9

Installation of the MySQL server involves roughly three steps: 1) unpacking the software; 2) creating a default database; 3) creating a default user/password (and storing this in the database).

Should you accidentally lose the database files (usually located in /var/lib/mysql) then you can start again without completely reinstalling the server package. This is done with the command mysqld --initialize. If you run this command while a database is already in place, it will report an error ("File exists") and it won't attempt to overwrite the database. However, if you're unsure if the installation procedure has completed correctly, it's OK to delete the directory /var/lib/mysql and re-initialize the database.

The --initialize flag will cause MySQL to generate a root user and a random password, which is then written to the log file. For more information, see man mysqld.

Jos
  • 30,529
  • 8
  • 89
  • 96
5

First check the version of Mysql using mysql --version.

If you have version 5.7.6 or later, the data directory would be initialized automatically and no need for running sudo mysql_install_db.

some more info on installing mysql on DigitalOcean server is on https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04

Faisal M
  • 51