Welcome to Ubuntu Eoan Ermine (development branch) (GNU/Linux 5.2.0-15-generic x86_64) I found the following address: 192.168.1.10 Now you have an ssh server and a user with a password, and you can log in remotely to your persistent live system :-)Ĭonnect to your network and identify your IP address ip a Select a good password with at least 8 characters. The default live user needs no password to run sudo, just press the Enter key, when it asks for password.Īnd follow the instructions in the graphical user interface. In order to get users-admin and of course sudo apt install openssh-server Get packages (unless you have them already) sudo apt install gnome-system-tools Create a persistent live drive with mkusb from your iso file.I tested with a recent iso file of Lubuntu Eoan (to be released as 19.10), but I think the method is general and should work for many versions, flavours and re-spins based on Ubuntu including Linux Mint. I found a way to connect to a persistent live Ubuntu based distro via ssh. But ssh wants a password, so it does not work to log in remotely via ssh into a persistent live drive. When asked for a password, for example to run sudo, you simply press the Enter key. There is no (publicly known) password for the default user in Ubuntu based flavours and distros. After this, you have a new MySQL repo in your Software Sources.įinally, install MySQL: sudo apt install mysql-serverĪnd now I was prompted to provide root password! Hope it helps for others with this same experience.No (publicly known) password for the default user The default option is 8.0 but I changed it to 5.7. Next, run it with dpkg: sudo dpkg -i mysql-apt-config_0.8.10-1_all.debĪt the installation setup, choose the MySQL version that you'd like to install. I opened MySQL download page ( ) for apt repo and clicked Download button at the bottom right. NONE works.Īfter hours of unproductive works, I decided to reinstall MySQL from the official page. I uninstalled (purging all dpkgs with mysql in its name) and reinstalled again from the default Linux Mint repositories. I googled here and there and tried various answers I found on the net, including the accepted answer above. As a result I wasn't able to login into MySQL. I installed MySQL 5.7 from the repo ( sudo apt install mysql-server) and surprisingly during installation, the setup didn't prompt to enter root password. I just installed Linux Mint 19 (based on Ubuntu 18.04) on my machine. => To zap this alternate authentication mode and return the MySQL root user to using passwords: ALTER USER IDENTIFIED WITH mysql_native_password BY 'SOME_NEW_ROOT_PASSWORD' |īecause it's using auth_socket, the root password cannot be changed: the SET PASSWORD command fails, and mysql_secure_installation desn't attain anything. | user | plugin | HEX(authentication_string) | Mysql> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Ĭomparing "me" with "root": mysql> SELECT user, plugin, HEX(authentication_string) FROM er WHERE user = 'me' or user = 'root' To login as the MySQL root user, one can use sudo: sudo mysql -user=rootīut how to then change the root password? To illustrate what's going on, I created a new user "me", with full privileges, with: mysql> CREATE USER IDENTIFIED BY 'my_new_password' It allows a password-free login, provided that one is logged into the Linux system with the same user name. The default installation uses auth_socket for authentication, in lieu of passwords! MySQL server 5.7 was already installed by default on my new Linux Mint 19.īut, what's the MySQL root password? It turns out that: UPDATE er SET authentication_string=PASSWORD('new_password') where user='root' Įnter password: // Yay! 'new_password' now works! Mysql> COMMIT // When you don't have auto-commit switched onĮither: mysql> ALTER USER IDENTIFIED BY 'new_password' Mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root' | debian-sys-maint | localhost | mysql_native_password | | mysql.sys | localhost | mysql_native_password | | ssion | localhost | mysql_native_password | Mysql> SELECT User, Host, plugin FROM er Note the lines which read: user = debian-sys-maintĮnter password: // type 'blahblahblah', ie. With special credit to this answer for digging me out of the frustration on this. Here's what worked for me, on Ubuntu 18.04, from the top There's so many answers out there saying to reinstall mysql or use some combo of mysqld_safe -skip-grant-tablesĪnd / or UPDATE er SET Password=PASSWORD('password')
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |