Author Topic: [SOLVED] Zentyal 6.0: installing moodle and mySQL root password problem  (Read 3103 times)

erotavlas

  • Zen Apprentice
  • *
  • Posts: 40
  • Karma: +9/-0
    • View Profile
Hi,
I recently discovered zentyal. I'm trying it for my main server and I would like to install moodle 3.7 e-learning. I'm having an issue with mySQL root password. I already read https://forum.zentyal.org/index.php?topic=30806.0 about how to find the mySQL zentyal user password. However, I'm not able to create new user nor viewing the current users:
Code: [Select]
select * from mysql.user;How can I add a root user? I tried the standard command https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html but it does not work for insufficient privilege.
Zentyal is based on ubuntu server, however the behaviour in this situation is quite different. Do you have any suggestion?
Thank you
« Last Edit: June 12, 2019, 04:37:03 pm by erotavlas »

Thanatos

  • Zentyal Staff
  • Zen Apprentice
  • *****
  • Posts: 10
  • Karma: +8/-0
    • View Profile
Re: Zentyal 6.0: installing moodle and mySQL root password problem
« Reply #1 on: June 11, 2019, 04:20:58 pm »
You can find mysql password here:
Code: [Select]
/var/lib/zentyal/conf/zentyal-mysql.passwd
“THERE'S NO JUSTICE, said Mort. JUST US.”

erotavlas

  • Zen Apprentice
  • *
  • Posts: 40
  • Karma: +9/-0
    • View Profile
Re: Zentyal 6.0: installing moodle and mySQL root password problem
« Reply #2 on: June 11, 2019, 07:05:31 pm »
You can find mysql password here:
Code: [Select]
/var/lib/zentyal/conf/zentyal-mysql.passwd
Thank you for the reply. As I wrote in the previous post, I know how to retrieve the mySQL password for the user zentyal. However, by logging into mySQL with such account I have not root privilege. How can I get it?
Moreover, I installed phpMyAdmin and during the installation it prompted me a choice for the Web server (apache or nginx) and for the mySQL password for phpmyadmin user. Then by using phpMyAdmin I'm able to log in only with zentyal and phpmyadmin account. No one has root access.

erotavlas

  • Zen Apprentice
  • *
  • Posts: 40
  • Karma: +9/-0
    • View Profile
Re: Zentyal 6.0: installing moodle and mySQL root password problem
« Reply #3 on: June 12, 2019, 04:35:34 pm »
I solved by myself.
Zentyal uses a very strange policy for mySQL password.
Zentyal user (limited privileges) password is located at:
Code: [Select]
/var/lib/zentyal/conf/zentyal-mysql.passwdYou can log in as:
Code: [Select]
mysel -u zentyal -pRoot user without any password:
Code: [Select]
sudo mysql