In a Fedora system, I need to convert the Owncloud’s SQLite database into a MySQL/MariaDB database
I started installing MySQL:# systemctl enable mysqld # systemctl start mysqld $ mysql_secure_installation
then
$ mysql -u root -p CREATE USER 'owncloud_user'@'localhost' IDENTIFIED BY '12345'; CREATE DATABASE IF NOT EXISTS owncloud; GRANT ALL PRIVILEGES ON owncloud.* TO 'owncloud_user'@'localhost' IDENTIFIED BY '12345';
and let’s assume that owncloud_user’s password is
12345
Now, from Owncloud 7.0 admin manual, entering# php occ db:convert-type --all-apps mysql owncloud_user 127.0.0.1 owncloud
I have been prompted for:
What is the database password?
Database password? I only created a password for user owncloud_user, so I entered the password
12345
but I obtain error[PDOException] SQLSTATE[HY000] [1045] Access denied for user 'owncloud_user'@'localhost' (using password: YES)
Additional infos:
the machine has IPv6 enabled
MariaDB [(none)]> SELECT user, host FROM mysql.user; +---------------+-----------+ | user | host | +---------------+-----------+ | root | 127.0.0.1 | | root | ::1 | | owncloud_user | localhost | | root | localhost | +---------------+-----------+
Answer
You need to reload the privileges from the grant tables in the mysql database.
You can do this with:
$ mysql -u root -p
FLUSH PRIVILEGES;
EXIT;
Attribution
Source : Link , Question Author : Germano Massullo , Answer Author : dgrimbergen