yii2-template | Restful 模板,提供企业号微信扫码登录——Yii2 React ant-design
kandi X-RAY | yii2-template Summary
kandi X-RAY | yii2-template Summary
yii2-template
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Renders WxJs .
- Synchronize users .
- upload a file
- Confirm user login
- Initializes the alert box .
- Add user .
- Create table .
- validate nonce
- Upload file .
- Login action .
yii2-template Key Features
yii2-template Examples and Code Snippets
Community Discussions
Trending Discussions on yii2-template
QUESTION
I'm creating new app on Heroku. Installed add-on "JawsDB Maria" successfully - I can open it's dashboard
In PHP on connection to DB I receive error:
SQLSTATE[HY000] [1044] Access denied for user 'vcgu1h273742rn5l'@'%' to database 'jeyx2j66ipgtqe11'
I'm sure that problem is not in PHP, because the same error I receive even on MariaDB dashboard trying to Create New Databite - https://prnt.sc/rj4dr4 .
Looks like solution is to GRANT ALL PRIVILEGES
to user. But using dashboard I can't execute even SHOW GRANTS
.
Questions:
- Can somebody help how to solve this problem?
- Or, at least, which way I can
GRANT ALL PRIVILEGES
?
I've tried:
- read Heroku docs: JawsDB MySQL, PHP + DB
- searching for similar problems in Heroku support, Google, SO:
- the best match I found is here. But
heroku pg:psql
- it's tool only for PostgreSQL.
- the best match I found is here. But
- tried to find useful command for my case in Heroku CLI Commands
Additional info - I'm sure it is not important, but just in case it is:
- project is based on Yii2
- for easy deployment on Heroku installed "purrweb/yii2-heroku"
ANSWER
Answered 2020-Mar-19 at 17:36You probably know how to read your error message. At any rate, my superpower is explaining the obvious. So, ... here goes.
SQLSTATE[HY000] [1044] Access denied for user 'vcgu1h273742rn5l'@'%' to database 'jeyx2j66ipgtqe11'
Tells you your php program couldn't get to the MySQL server. That operation goes in these steps.
Make a TCP/IP network connection to the server. SUCCESS.
Present a user name and password to the server. SUCCESS.
But the server rejected those credentials. FAILURE
Access the database schema mentioned in the connect request. Not attempted yet. So we have no information about whether the named database actually exists.
The success of step 1 means there are no firewall or network-routing issues. That's good.
The success of step 2 gives us even more confidence about firewall issues.
The failure of step 3 tells us that we're not using a username and password that the MySQL server knows about.
Step 4 is incomplete. So, even if we fix the username and password issues, we still might get another issue before this mess is behind us.
Heroku assigns those usernames to their customers. So, check on the appropriate Heroku control panel to see whether you're using the right username / password credentials. Your error message says you've got wrong credentials.
Next step? Ask your vendor for help. Is Bruce Schneier is reading this? Maybe he can fix this for you from his earbuds while he's riding on the subway. But none of the rest of us here on SO can fix it.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install yii2-template
PHP requires the Visual C runtime (CRT). The Microsoft Visual C++ Redistributable for Visual Studio 2019 is suitable for all these PHP versions, see visualstudio.microsoft.com. You MUST download the x86 CRT for PHP x86 builds and the x64 CRT for PHP x64 builds. The CRT installer supports the /quiet and /norestart command-line switches, so you can also script it.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page