Hi,
I want to change the DB Password in mysql for the NC DB.
How can I do that and in which configs I must change the parameters?
NC give’s a own DB PW and User after the first install…
Hi,
I want to change the DB Password in mysql for the NC DB.
How can I do that and in which configs I must change the parameters?
NC give’s a own DB PW and User after the first install…
You can try mysql -u root -p
ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';
but that’s just guessing as I know nothing about your setup
it’s just in the config/config.php
file on Nextcloud side.
Ok, the password in the config.php is crypted. How can I make a cryption of my new DB Password to write it in the config?
I there Problem to give the root User of mysql a Password?
How can I change the DB Password for the user ncp in the database?
Oh, is that new? Mine is still unencrypted (NC 18) …
Unencrypted on my NC19…
Same 19.0.3.1
Your password cannot be encrypted unless you added custom source code!.
Yes it is okay to have a password for the root user.
No We do not use root for normal usage!
Did you setup mysql_secure_installation
change the password for user ncp by connecting to the mysql database as root to administrate the user.
mysql -u root -p
will connect to mysql as -u defines user root and -p requires you to enter the root password.
use mysql;
now use database mysql where the users are stored.
ALTER USER ‘ncp’@‘hostname’ IDENTIFIED BY ‘NEW_PASS’;
Where ncp is the username
where hostname should be localhost which is enough or % to have access from any ip.
and where NEW_PASS equals your new non encrypted password.