Home / server / Questions / 643766
Accepted
Germano Massullo
Asked: 2014-11-13 04:32:47 +0800 CST

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

  • 772

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 |
+---------------+-----------+
mysql

2 Answers

  1. Can you try specifying 127.0.0.1 and/or ::1 , like this

    $ mysql -u root -p
  CREATE USER 'owncloud_user'@'127.0.0.1' IDENTIFIED BY '12345';
  CREATE USER 'owncloud_user'@'::1' IDENTIFIED BY '12345';
  CREATE DATABASE IF NOT EXISTS owncloud;
  GRANT ALL PRIVILEGES ON owncloud.* TO 'owncloud_user'@'127.0.0.1';
  GRANT ALL PRIVILEGES ON owncloud.* TO 'owncloud_user'@'::1';

    The reason is this: http://dev.mysql.com/doc/refman/5.0/en/connecting.html

    On Unix, MySQL programs treat the host name localhost specially, in a way that is likely different from what you expect compared to other network-based programs. For connections to localhost, MySQL programs attempt to connect to the local server by using a Unix socket file.

    • 1
  2. Best 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;
    • -1