Mariadb by defaults uses UNIX_SOCKET plugin to authenticate user root. I had seen somewhere that the default login for root wasn't any password, but was authenticated via a socket connection, but I have not been able to find out more about that. But even still I don't really want to RESET any passwords, I am starting with a fresh installation. I have gone through other examples of how to reset the password (-skip-grant-tables and such) with no luck. Your MariaDB connection id is 26 Server version: 10.1.23-Ĭopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. $ sudo mysql Welcome to the MariaDB monitor. I can login to mysql with just sudo any no password, but this does not solve the problem of needing non sudo access. I am sure I used the correct password (and have actually gone through this process a couple times). Password: ERROR 1698 (28000): Access denied for user $ Thanks for using MariaDB! $ mysql -u root -p Enter Success!Īll done! If you've completed all of the above steps, your MariaDB However when it is all done, and I try and log in. Setting the root password ensures that nobody can log into the MariaDB rootĪgain, I used not password, just pressed enterĪnd I can continue Down through setting up new password, disabling remote login, etc. Now, If I run the same install script with sudo $ sudo mysql_secure_installationĮnter current password for root (enter for none): OK, successfully used Now I had pressed enter, no password which should be the case since it is a brand new install. Root password yet, the password will be blank, so you should just pressĮnter current password for root (enter for none):ĮRROR 1698 (28000): Access denied for user current password for root (enter for none): If you've just installed MariaDB, and you haven't set the In order to log into MariaDB to secure it, we'll need the current passwordįor the root user. SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB Installed mysql sudo apt-get install mysql-serverĮRROR 1698 (28000): Access denied for user I tried $ mysql_secure_installation I know there are many, many threads on this, but hear me out before marking it as a duplicate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |