Change ddev password for a single project

  ddev, docker, mysql

I try to change a ddev database password for a single project.

I need to check sign-escaping for a project, because I want to know how and if that works.

How can I change a database password in a single ddev-project?

I use

  • Docker 3.5.1 (66090)
  • ddev 1.17.2
  • macOS Catalina 10.15.7

I got answers in slack, thanks for that, but I run into those errors, if I do so:

ddev mysql

MariaDB [db]> GRANT ALL PRIVILEGES ON *.* TO 'db'@'%';
ERROR 1045 (28000): Access denied for user 'db'@'localhost' (using password: YES)


MariaDB [db]> ALTER USER 'db'@'localhost' IDENTIFIED BY 'test/test:[email protected]?test#test&test"';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
MariaDB [db]> ALTER USER 'db'@'db' IDENTIFIED BY 'test/test:[email protected]?test#test&test"';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

Source: Docker Questions

LEAVE A COMMENT