How to solve Failed! Error: SET PASSWORD has no significance for user ‘ ’ as the authentication To start the secure script, utilize the given command and it will ask various questions ranging from profile password to the level of password validation: sudo mysql_secure_installationĪnd when I choose my password and security validation level, it gave me the following error:Īnd if you are on Ubuntu, you will probably get the same error so let's resolve this issue first. MySQL is vulnerable just after installation and this is the reason why it is pre-bundled with a secure script. Once you are done with the installation, you can check for the installed version by appending -version to the mysql command: mysql -version Securing MySQL install with a secure script Then you will have to install MySQL client instead of server using the given command: sudo apt install mysql-client You will get a MySQL server which is helpful when you want to host a database server on your system but what if you connect to a MySQL server as a client? So here's the command to update your existing repos and install MySQL in Ubuntu: sudo apt update & sudo apt install mysql-server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |