If you can open a terminal window and do "mysql -uroot -p{whatever}", then MySQL is properly installed.
However, you also need MySQL to talk to QT3; if you compiled QT3 yourself, you needed to select the -qt-sql-mysql option.
I have never tried to install Rivendell under Ubuntu, but if it's like Debian 9, MySQL comes installed with a plugin "unix_socket" that only allows root to log in to MySQL as root.
You need to log in to mysql as root, select the 'mysql' database, and type:
SELECT plugin FROM user WHERE user = 'root'; If it shows 'unix_socket', change it to NULL. Rob -- Я там, где ребята толковые, Я там, где плакаты "Вперёд", Где песни рабочие новые Страна трудовая поёт. On Sun, 21 Oct 2018, Luigino Bracci wrote:
Maybe MySQL is not correctly installed? Try removing mysql-server and mysql-server-5.7, then run sudo apt-get clean and sudo apt-get autoremove and try to install both packages again. El dom., 21 de oct. de 2018 a la(s) 19:34, Pedro Picoto ([email protected]) escribió: Hmmm.... Upon # Stop MySQL sudo service mysql stop "Failed to stop mysql.service: Unit mysql.service not loaded." On Sun, Oct 21, 2018 at 10:37 PM Luigino Bracci <[email protected]> wrote: Maybe you need to reset the password of the MySQL user. Remember that, in MySQL 5,7 (the one that comes with Ubuntu 18.04), you must be sudo to access the MySQL root user ("sudo mysql -u root -p"). If you don't remember the MySQL's root password, follow this guide: https://coderwall.com/p/j9btlg/reset-the-mysql-5-7-root-password-in-ubuntu- 16-04-lts Regards El dom., 21 de oct. de 2018 a la(s) 11:24, Pedro Picoto ([email protected]) escribió: Thank you all! "Unable to connect to mySQL" Something messed up on the setup process, for sure. But what?... On Sun, Oct 21, 2018 at 3:33 PM Fred Gleason <[email protected]> wrote: On Oct 21, 2018, at 07:54, Pedro Picoto <[email protected]> wrote: Following the offer of the fellow member Luigino Bracci, I've downloaded and installed the packages but now I'm stucked 'cause I don't remember the user/pw for the first ride on the rdadmin. It's been a very long time since I played with Rivendell, hence this blank spot (perhaps lots of others too) in my brain… ‘admin’ with no p/w. Cheers! |----------------------------------------------------------------------| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |----------------------------------------------------------------------| | A room without books is like a body without a soul. | | -- Cicero | |----------------------------------------------------------------------| _______________________________________________ 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
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
