[MDEV-8165] Initial db installation sets a root password Created: 2015-05-15  Updated: 2016-03-07  Resolved: 2016-03-07

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: johannes kingma Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback


 Description   

using these steps to create a database will block at the attempt to logon without a root password. 

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

Leaving the password blank is not an option:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)



 Comments   
Comment by Ian Gilfillan [ 2015-05-20 ]

I don't understand what needs to be documented here?

Comment by Sergei Golubchik [ 2016-02-04 ]

What MariaDB version was it?

Comment by Elena Stepanova [ 2016-02-06 ]

... and which MariaDB packages are you using?

Also, please attach your cnf file(s) and paste the error log contents. It's particularly interesting to see how you pass the datadir location to the server when you start it via systemctl.

Comment by Elena Stepanova [ 2016-03-07 ]

If you have more information on the issue, please comment to re-open.

Generated at Thu Feb 08 07:25:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.