Developing a Dynamic Website 2014 - Part 7 - Creating the MySQL Database

[kamaboko]

Thanks.  I'm really enjoying this tutorial.  

[iagroupmedia]

excellent video tutorial, I'm using Dreamweaver and XAMPP 5.6 and I'm using updated files for jquery and bootstrap for 2017, so far so good :)))

[zerogravity]

Fix: Access denied for user 'username'@'localhost'(using password: YES)

when u add user in phpmyadmin under username u need to set Host on Local
hope this helps :)

[ranicorn]

Hey, thanks for the such in depth education! I have loved the videos so far!

When following this video though, I ran through the error on my web page a bunch of time and I had no idea why. I played around to find a solution and I seemed to fix the problem by directing my host to be local host instead of  any host, like directed in the video. Why has that happened to me? Will it be an issue in the long run?

[TheDigiCraft]

David, I go through errors so that we know how to address them as developers.  I would assume that people planning to use what I am building will modify it at least to some degree. Otherwise the whole series is technically showing everyone how to do what they want with it ;-)

[abhayshikhare]

i followed your steps which you showed at 3:37 where i need to specify details about localhost, username, password and databasename. But not matter how many times i follow correct instructions it always gives me an error which you have shown at 4:04....Please hep me out here.

[Robert-opii]

thanks for the fix. 
here it is for any one else.

Open PhpMyAdmin
Click on Users (sometimes called Privileges)
Edit the user
Change the host from Any Host to Local or type "localhost" in the text field (no quotes)

[DiddleDot]

While creating the user and giving them privileges, I had to set the host to "localhost "instead of "any host" to get it to work. 

[TravisHi_YT]

+SkriptKitty Thanks, you saved me heaps of time on this one!

[cjrdrums]

When I was creating a new user for the database I was using, I had to select 'localhost' under 'host' to get a connection. Whereas when it was selected as 'any' as you did, it came up with the connection error? Everything else was correct, but changing that seemed to help. Any idea why?

[DavidAshby]

At this point I want to use the Bootstrap Contextual backgrounds, have followed the bootstrap code but it does not show up formatted as required.  i.e. I have OR die('<p class="bg-danger">Error: We apologise for the inconvenience but we cannot connect you to the database at this time.</p>');

Where have I gone wrong ?  Thanks

[JDMedia]

my problem solved
if anybody facing the same issue, try this way
go to xaamp folder in your computer open mysql folder create new folder as named "lib" create another folder inside "lib" folder as named "plugin"

[PouyaAtaei]

Dear friends, if you do not have the privilege tab just like I do, go ahead and delete your cookies or use another browser, this will help :) 

[stevegenius]

please ...make another website photoshop tutorial. so that we can combine this dynamic series skilss together with the designing a web  in photoshop

[benotaku]

when i try to set the privileges, i keep getting this message:

"SHOW PLUGINS SONAME LIKE '%_password_check%'
MySQL said
#1018 - Can't read dir of 'C:\xampp\mysql\lib\plugin\' (errno: 2 "No such file or directory")"

can someone help me please?

[igeekglobal]

Parse error: syntax error, unexpected '$q' (T_VARIABLE) in C:\wamp\www\Series\index.php on line 5

[turkkent]

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'dev@'localhost' (using password: YES) in on line 9
 please help about this what can i do

[DanielNicolasFrenchCookies]

Hi.  I follow everything correctly (I presume) but I get this error : Warning: mysqli_connect(): (HY000/1045): Access denied for user 'dev'@'localhost'(using password: YES) in C:\xampp\Xampp on line 5
Could not connect because:Access denied for user 'dev'@'localhost'(using password: YES)

HOw can I change the New User password

[mariamshqair]

any person have these kind of error :
Warning: mysqli_connect(): (HY000/1045): Access denied for user
'dev'@'localhost'(using password: YES) in on line 4

just put @ at the connect cod like this:

[JDMedia]

when i try to set the privileges, i keep getting this message:

"SHOW PLUGINS SONAME LIKE '%_password_check%'
MySQL said
#1018 - Can't read dir of 'C:\xampp\mysql\lib\plugin\' (errno: 2 "No such file or directory")"
can someone help me please?