We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Issue connecting to MySQL from PHP
Issue connecting to MySQL from PHP
Hi,
I created a database and a user.
Database name is admin_wp (entered wp), username is the same.
Password is xyz (not really :) )
Then I do this :
$db = new mysqli('localhost', 'admin_wp', 'admin_wp', 'xyz');
And I get this error :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'admin_wp'@'localhost' (using password: YES) in ...
Am I supposed to use a different user? I can access phpymyadmin with this user, so I don't know what I'm doing wrong.
Thanks!
I created a database and a user.
Database name is admin_wp (entered wp), username is the same.
Password is xyz (not really :) )
Then I do this :
$db = new mysqli('localhost', 'admin_wp', 'admin_wp', 'xyz');
And I get this error :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'admin_wp'@'localhost' (using password: YES) in ...
Am I supposed to use a different user? I can access phpymyadmin with this user, so I don't know what I'm doing wrong.
Thanks!
Re: Issue connecting to MySQL from PHP
Also, I tried this :
mysql -u admin_wp -p
And that worked. So no idea why it's not working from my simple PHP script.
mysql -u admin_wp -p
And that worked. So no idea why it's not working from my simple PHP script.
Re: Issue connecting to MySQL from PHP
Tried making a new user :
(don't worry, it's a temp password)
(note, made it a couple of times with different host but same password)
Result :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'web'@'localhost' (using password: YES)
Code: Select all
grant all on admin_wp.* to 'web'@'%' identified by 'c3cg5yTqXNsJzcq9';
Code: Select all
+---------------+-----------+
| user | host |
+---------------+-----------+
| admin_default | % |
| admin_wp | % |
| web | % |
| web | 127.0.0.1 |
| admin_default | localhost |
| admin_wp | localhost |
| phpmyadmin | localhost |
| root | localhost |
| roundcube | localhost |
| web | localhost |
+---------------+-----------+
Code: Select all
$db = new mysqli('127.0.0.1', 'web', 'admin_wp', 'c3cg5yTqXNsJzcq9');
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'web'@'localhost' (using password: YES)
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Issue connecting to MySQL from PHP
Due to official documentation looks like youre wrong with arguments order.
Re: Issue connecting to MySQL from PHP
i got same problem
-
- Posts: 25
- Joined: Thu Dec 30, 2021 10:04 am
- Os: CentOS 7x
- Web: apache
Re: Issue connecting to MySQL from PHP
Did the issue resolved after looking into database?