MariaDB Knowledge Base Comments for: mysql_secure_installationhttps://mariadb.com/kb/en/mysql_secure_installation/+comments/feed/en-usMon, 16 Oct 2017 22:03:47 +0000Re: mysql_secure_installationhttps://mariadb.com/kb/en/mysql_secure_installation/+comments/2684<p>As of Ubuntu 15.10, the root user is authenticated using the unix_socket and it seems that the other steps in this script are completed during installation.</p>
<p>So is the ALLCAPS disclaimer no longer true for Ubuntu 15.10+?</p>
<p>NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!</p>
https://mariadb.com/kb/en/mysql_secure_installation/+comments/2684Re: mysql_secure_installation initial passwordhttps://mariadb.com/kb/en/mysql_secure_installation/+comments/2676<p>This seems normal. If there's a root password it needs to be specified. Only if there is none does simply pressing enter work.</p>
Ian Gilfillanhttps://mariadb.com/kb/en/mysql_secure_installation/+comments/2676Re: mysql_secure_installation initial passwordhttps://mariadb.com/kb/en/mysql_secure_installation/+comments/1549<p>On arch I followed these these steps</p>
<p>sudo zfs create -o recordsize=8k -o primarycache=metadata -o mountpoint=/srv/data zdata/data
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/srv/data
sudo systemctl start mysqld
sudo mysql_secure_installation</p>
<p>The last command asks for the current password. Dispite it saying that the password should be empty, this does not work:</p>
<p>Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)</p>
<p>Please update this description and correct the error. </p>
<p>Thanks!</p>
John Kinghttps://mariadb.com/kb/en/mysql_secure_installation/+comments/1549