## Answer Please refer to the following manual and perform additional steps. --- ## Limitations 1. When configuring a MySQL with separate web and DB servers, use Pleasanter version 1.4.10.0 onward. Pleasanter has supported MySQL since version 1.4.9.0 onward, but the above additional steps can only be performed with version 1.4.10.0 or later. 2. The above additional steps are not required for SQL Server and PostgreSQL. ## Description Due to MySQL specifications, the information of the connection source is managed in MySQL user account management. Because of this specification, an error occurs when trying to connect to MySQL using Pleasanter (and CodeDefiner) processing on an unregistered server. ### When MySQL and Pleasanter coexist on the same server The above additional steps are not required.  [Pleasanter's Standard Setup Procedure](https://pleasanter.org/ja/manual?category=0092) is a procedure that assumes that a root account (hereinafter referred to as "root@localhost") that can only connect to localhost was created during MySQL setup. When executing CodeDefiner in the Pleasanter setup procedure, the root account is used to create tables in the DB, but as mentioned above, root@localhost is created during MySQL setup, so if MySQL and Pleasanter coexist on the same server, no additional steps are required. ### If you want to separate the MySQL and Pleasanter servers You need to execute "".  In a configuration with separate servers, the CodeDefiner server will connect to the MySQL server during setup, so you must create an account for "root@server where Pleasanter (and CodeDefiner) is deployed" on MySQL in advance. Note that Pleasanter and CodeDefiner use a total of three MySQL user accounts (root and two additional accounts), so in the additional steps, run SQL to create a total of 3 new MySQL user accounts. ## Supported Versions |Supported versions|Body| |:--|:--| |1.4.10.0 onward|A FAQ has been published to resolve the issue where Owner and User connections may be rejected due to MySQL's access control function.<br>*Pleasanter has been compatible with MySQL since version 1.4.9.0 onward, but the steps shown in the answer to this FAQ can only be carried out with version 1.4.10.0 onward. |