So my assignment is to display a chart as a webpage using phpMyAdmin running code out of visual studio code. When I try to run the page, which should display my chart, I get a mysqli_connect(): (HY000/1045): Access denied error message. Which I believe has something to do with the permissions in phpMyAdmin, but I don't know how to access that. Thoughts?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

So my assignment is to display a chart as a webpage using phpMyAdmin running code out of visual studio code. When I try to run the page, which should display my chart, I get a mysqli_connect(): (HY000/1045): Access denied error message. Which I believe has something to do with the permissions in phpMyAdmin, but I don't know how to access that. Thoughts? 

ecpi UNIVERSITY
MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224
Topology Content Status Windows 10
8
File Edit Selection View Go Run Terminal Help user_list.php - cis224_week3_gp1 - Visual Studio...
▷ Launch
user_list.php x {} launch.json
user_list.php > ...
<?php
VARIABLES
Run and Debug (Ctrl+Shift+D)
✓ WATCH
✓ CALL STACK
BREAKPOINTS
Caught Exceptions
Uncaught Except...
> BROWSER BREAKPOINTS
1
2
3
4
>
567000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
PROBLEMS
$hostname
$username
$password
$dbname
$conn
?>
<style>
=
table {
=
=
$query
"SELECT * FROM userinfo";
$result = mysqli_query($conn, $query);
=
"localhost";
"ecpi_user";
"Password1";
"cis224_wk3gp";
mysqli_connect($hostname, $username, $password, $dbname)
=
}
th, td {
border-spacing: 5px;
}
table, th, td {
border: 1px solid black;
border-collapse: collapse;
Home Reservation
padding: 15px;
text-align: center;
DEBUG CONSOLE
80
Filter (e.g. text, !exclude)
-
micpor9577
Time Remaining
1 13
hrs. min.
Mar
Ex^X
Transcribed Image Text:ecpi UNIVERSITY MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224 Topology Content Status Windows 10 8 File Edit Selection View Go Run Terminal Help user_list.php - cis224_week3_gp1 - Visual Studio... ▷ Launch user_list.php x {} launch.json user_list.php > ... <?php VARIABLES Run and Debug (Ctrl+Shift+D) ✓ WATCH ✓ CALL STACK BREAKPOINTS Caught Exceptions Uncaught Except... > BROWSER BREAKPOINTS 1 2 3 4 > 567000 8 9 10 11 12 13 14 15 16 17 18 19 20 21 PROBLEMS $hostname $username $password $dbname $conn ?> <style> = table { = = $query "SELECT * FROM userinfo"; $result = mysqli_query($conn, $query); = "localhost"; "ecpi_user"; "Password1"; "cis224_wk3gp"; mysqli_connect($hostname, $username, $password, $dbname) = } th, td { border-spacing: 5px; } table, th, td { border: 1px solid black; border-collapse: collapse; Home Reservation padding: 15px; text-align: center; DEBUG CONSOLE 80 Filter (e.g. text, !exclude) - micpor9577 Time Remaining 1 13 hrs. min. Mar Ex^X
ecpi UNIVERSITY
MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224
Windows 10
Topology Content
localhost/127.0.0.1/cis224_wk3 x +
Recent Favorites
New
cis224
← → C℗ localhost/phpmyadmin/sql.php?server=1&db=cis224_wk3gp&table=userinfo&pos=0
phpMyAdmin
Server: 127.0.0.1 » Database: cis224_wk3gp >> Table: userinfo
Browse Structure
Search
Insert
Hcis224_porter
cis224_wk3gp
New
- userinfo
HII Columns
New
EMail (varchar)
Indexes
+ information_schema
+- mysql
Expand/Collapse
phpmyadmin
test
mweek1
✔Status
Ⓒ
FavoriteNum (int)
FirstName (varchar
LastName (varchar
UserNo (PRI, int)
chema
SELECT * FROM `userinfo
U
+ Options
+T→
U
Showing rows 0 - 3 (4 total, Query took 0.0061 seconds.)
Show all Number of rows: 25
Edit - Copy
Edit - Copy
Edit Copy
Edit - Copy
localhost/phpmyadmin/sql.php?server=1&db=cis22...
Check all
Print
Console
Delete
Delete
Delete
Delete
Query results operations
SQL
Show all Number of rows:
With selected:
Copy to clipboard
Home
Profiling [Edit inline] [Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
UserNo
FirstName LastName EMail
1
Admin
2
YourFirst
3 Joe
4 Jane
25 ✓
Edit
Reservation
Export
a ☆
Filter rows: Search this table
Copy
Display chart
Export More
Administrator admin@admin.com
YourLast
Smith
Jones
you@you.com
jsmith@joe.com
jjones@jane.com
Delete
micpor9577
Filter rows: Search this table
Time Remaining
1 13
hrs. min.
Create view
Export
Sort by ke
Favorite Nui
Sort by ke
Transcribed Image Text:ecpi UNIVERSITY MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224 Windows 10 Topology Content localhost/127.0.0.1/cis224_wk3 x + Recent Favorites New cis224 ← → C℗ localhost/phpmyadmin/sql.php?server=1&db=cis224_wk3gp&table=userinfo&pos=0 phpMyAdmin Server: 127.0.0.1 » Database: cis224_wk3gp >> Table: userinfo Browse Structure Search Insert Hcis224_porter cis224_wk3gp New - userinfo HII Columns New EMail (varchar) Indexes + information_schema +- mysql Expand/Collapse phpmyadmin test mweek1 ✔Status Ⓒ FavoriteNum (int) FirstName (varchar LastName (varchar UserNo (PRI, int) chema SELECT * FROM `userinfo U + Options +T→ U Showing rows 0 - 3 (4 total, Query took 0.0061 seconds.) Show all Number of rows: 25 Edit - Copy Edit - Copy Edit Copy Edit - Copy localhost/phpmyadmin/sql.php?server=1&db=cis22... Check all Print Console Delete Delete Delete Delete Query results operations SQL Show all Number of rows: With selected: Copy to clipboard Home Profiling [Edit inline] [Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh] UserNo FirstName LastName EMail 1 Admin 2 YourFirst 3 Joe 4 Jane 25 ✓ Edit Reservation Export a ☆ Filter rows: Search this table Copy Display chart Export More Administrator admin@admin.com YourLast Smith Jones you@you.com jsmith@joe.com jjones@jane.com Delete micpor9577 Filter rows: Search this table Time Remaining 1 13 hrs. min. Create view Export Sort by ke Favorite Nui Sort by ke
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Form and its Elements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education