Here’s an update for anyone who decides to go down this rocky route: Warning: The password gets stored in the history file if you’re working with bash, so logout then login again and execute this: Now the root’s password must be set in the Webmin MySQL module. Ln -s /etc/systemd/system//rvice /etc/systemd/system/rvice Mysqld -user=mysql -init-file=/tmp/sql-init & (as mentioned in the OP, remove MariaDB and disable the mysql builtin repo) yum install mysql-community-server -yĮcho "ALTER USER IDENTIFIED BY 'MY-ROOT-PASSWORD' ">/tmp/sql-init The solution is to reset the root password right after the installation by performing the following dance (as detailed at MySQL :: MySQL 8.0 Reference Manual :: B.3.3.2 How to Reset the Root Password): In the log the password is not output, and instead there are messages that encourage to run a command to change the root password, which does not run, of course, because the root password is not known… Ugh! Installation using RPM packages generates an initial random password, which is written to the server error log.īut no, that’s not correct. To save head-scratching and hair-pulling of anyone intending to do this, here’s how it goes:Īccording to MySQL :: MySQL 8.0 Reference Manual :: 2.10.4 Securing the Initial MySQL Account : Is there an easier way to have Oracle’s MySQL instead of MariaDB? Using Virtualmin’s post-installation setup wizard also fails saying Warning! Incorrect MySQL password at the step of setting up a MySQL root password. Now the problem at the last step is that the root password is not getting accepted: ~]# mysql_secure_installationĮrror: Access denied for user (using password: ~]#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |