I am using Remote MySQL (RDS on AWS) and I ran into this error when creating a new site.
root@ip-:# wo site create newdomain.com --php74 --wp
Adding repository for MySQL, please wait...
Updating apt-cache [OK]
Installing APT packages [OK]
Tuning MariaDB configuration
Stop : mysql [OK]
Start : mysql [OK]
Running pre-update checks [OK]
Setting up NGINX configuration [Done]
Setting up webroot [Done]
Downloading WordPress [Done]
Setting up database Traceback (most recent call last):
File "/usr/local/bin/wo", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.6/dist-packages/wo/cli/main.py", line 102, in main
app.run()
File "/usr/local/lib/python3.6/dist-packages/cement/core/foundation.py", line 882, in run
return_val = self.controller._dispatch()
File "/usr/local/lib/python3.6/dist-packages/cement/core/controller.py", line 471, in _dispatch
return func()
File "/usr/local/lib/python3.6/dist-packages/cement/core/controller.py", line 471, in _dispatch
return func()
File "/usr/local/lib/python3.6/dist-packages/cement/core/controller.py", line 477, in dispatch
return func()
File "/usr/local/lib/python3.6/dist-packages/wo/cli/plugins/site_create.py", line 357, in default
wo_wp_creds = setupwordpress(self, data, vhostonly)
File "/usr/local/lib/python3.6/dist-packages/wo/cli/plugins/site_functions.py", line 284, in setupwordpress
data = setupdatabase(self, data)
File "/usr/local/lib/python3.6/dist-packages/wo/cli/plugins/site_functions.py", line 201, in setupdatabase
.format(wo_db_name))
File "/usr/local/lib/python3.6/dist-packages/wo/core/mysql.py", line 72, in execute
connection = WOMysql.connect(self)
File "/usr/local/lib/python3.6/dist-packages/wo/core/mysql.py", line 35, in connect
pymysql.connect(read_default_file='/etc/mysql/'
File "/usr/local/lib/python3.6/dist-packages/pymysql/init.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 325, in init
self.connect()
File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 599, in connect
self.request_authentication()
File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 861, in request_authentication
auth_packet = self.read_packet()
File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 684, in read_packet
packet.check_error()
File "/usr/local/lib/python3.6/dist-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self.data)
File "/usr/local/lib/python3.6/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)")