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?
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4d27a8a6-cc74-416c-a782-397e5cce3206%2Fb478b522-54ef-4095-bd9a-366d0f85ba3f%2Fycfbk3a_processed.png&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4d27a8a6-cc74-416c-a782-397e5cce3206%2Fb478b522-54ef-4095-bd9a-366d0f85ba3f%2Frvcvj7e_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education