Access denied for user root
Posted by: KarappoDB (198.163.179.---)
Date: October 31, 2016 08:44PM

Hello!

We're trying to connect to the sql database we've created and our initialization script returns an error. We are running it as root and it confirms we're using the correct password. What's coulda be the issue?

We're using Windows Server 2012 (no R2) 64-bit
WampServer version 3.0.6 64-bit
Apache Version 2.4.23
PHP version 5.6.25/7.0.10
MySQL version 5.7.14
WampServer icon is colored green smiling smiley

We have access to the localhost and phpMyAdmin

Here is a picture of our error: [i.imgur.com]
and our php script: [i.imgur.com]

We just blurred out the password and database bit for reasons. I'm ensuring ya'll that the password and database are correct! smiling smiley

Any suggestions would be appreciated. Thanks in advance smiling smiley

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
smiling smiley Triggered smiling smiley

Options: ReplyQuote
Re: Access denied for user root
Posted by: Otomatic (Moderator)
Date: October 31, 2016 09:09PM

Hi,

After install of Wampserver 3.0.6, the only declared user for MySQL is root without password.

.as you have access to PhpMyAdmin, you can see that in the Users tab.

So,if you didn't add a password to root or didn't create another MySQL user, you cannot use a password to connect to your database. Authorized users and passwords are in Mysql own database, not in your database.

Note I don't like to have to go elsewhere to see images that. Are only text.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 10/31/2016 09:13PM by Otomatic.

Options: ReplyQuote
Re: Access denied for user root
Posted by: KarappoDB (198.163.179.---)
Date: October 31, 2016 09:17PM

That makes sense. Thank you very much! Our problem is now solved smiling smiley

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
smiling smiley Triggered smiling smiley

Options: ReplyQuote


Sorry, only registered users may post in this forum.