Dear Simon, Let me answer your root question. There is a user root in the Linux system. There is also a user root in the MySQL system. The user root is considered SuperUser and by default has all privileges (in both systems).
They are however two separate entities in that one does not have to be logged into the system's root user to log into the database as root (Mysql does not check to see what user in Linux you are). Now - the mysql command has parameters. The -u and then a user name is which user you would like to use. So, when you entered "mysql -u root", it attempts to log you into the Mysql server as the user root. You did not include the -p parameter, so it will not prompt you for a password. So - when you did the echo command - you were basically logging into Mysql as root, and changing the user root password to "mylousypassword". Previous to issuing that echo command - root had NO password. >From that moment on you will have to provide your password when logging in as >root. When you issued the echo command again, you did not provide a password, so it did not let you log into the root user. To log into root from now on - you will have to say mysql -u root -p and provide a password when prompted. If you leave off -p it assumes the user you are trying to log into has no password thus the message (using password:NO). Hope that helps. Todd Baker Radio Free Asia Washington D.C. From: "Simon Frech" <[email protected]> To: "Mike Carroll" <[email protected]> Cc: "User discussion about the Rivendell Radio Automation System" <[email protected]> Sent: Thursday, May 14, 2020 6:58:04 PM Subject: Re: [RDD] last steps of Rivendell 3 install Interesting, looks like the Mac on which I write this email changes the straight single quote to a curly one in this font. I just realized this as I entered it again here. So this was not likely the problem. So I opened up a terminal but neglected to do “su -“ and was therefore logged in as rd. I entered echo "SET PASSWORD FOR root@localhost = PASSWORD('mylousypassword');" | mysql -u root and I received command prompt indicating the command was successful. But am I not supposed to be root to execute this command? I changed to root, entered the same command, now I get ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO) Thanks On May 14, 2020, at 1:46 PM, Mike Carroll < [ mailto:[email protected] | [email protected] ] > wrote: Verify your quotes are correct. In the command you pasted, the single quote in front of the password phrase is a smart/curly quote, not a single quote like the one after the password phrase. The command shell thinks you are entering a long string that needs more than one line, and is prompting you to enter more text. To get out of the prompt, press Control-C. Or close the window. Both will work <smile>. On Thu, May 14, 2020 at 1:18 PM Simon Frech < [ mailto:[email protected] | [email protected] ] > wrote: BQ_BEGIN I finally managed to install CentOS and Rivendell 3 according to the instructions at [ http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html | http://static.paravelsystems.com/rivendell-install-rd3/rivendell-install-rhel7.html ] It looks good, very familiar, I haven’t yet got to the point of actually using it or setting up beyond installation. I named the host simonserver, so in the terminal I'm logged in as root@simonserver. The last instruction in Final Steps is baffling to me. 4. Set the MariaDB administrator password with the following command (substitute your password for pwd ): echo "SET PASSWORD FOR root@localhost = PASSWORD(' pwd ');" | mysql -u root I entered echo "SET PASSWORD FOR root@simonserver = PASSWORD(‘ k258bq ');" | mysql -u root but now the Terminal just displays the > below my entry. I must have misunderstood. What am I doing wrong? The instructions are really good, but I’m misreading something. Thanks, Simon _______________________________________________ Rivendell-dev mailing list [ mailto:[email protected] | [email protected] ] [ http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev | http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ] BQ_END _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
