Softaculous

Topic : MySQL Access Denied after Windows 10 upgrade

Posted By: pb1uk on July 5, 2016, 9:03 pm

Hello,

My laptop did an auto upgrade to windows 10 and since i've not been able to connect to mysql through ampps. I get the following access denied error https://postimg.org/image/ei9gt87wx/

Please can anyone shed any light on what the problem could be? I've had a look around on Google and tried a few different things but still get the same error.

Kind regards,

pb1uk

Posted By: Rishi_P on July 6, 2016, 6:57 am | Post: 1

Hi,

Reset MySQL password.

Open command prompt and run following commands.

cd /path/to/your/Ampps/mysql/bin

mysqld --skip-grant-tables --skip-networking &

nesxt open second command prompt window and run following commands.

cd /path/to/your/Ampps/mysql/bin

mysql -u root

FLUSH PRIVILEGES;

USE mysql

UPDATE user SET Password = PASSWORD('mysql') WHERE Host = '%' AND User = 'root';

FLUSH PRIVILEGES;

quit;

Now restart MySQL from Ampps control Panel.

Edited by Rishi_P : July 6, 2016, 7:57 am

Posted By: pb1uk on July 6, 2016, 5:51 pm | Post: 2

Hello,

Thanks for your quick reply. I've tried the steps with no joy. Please see https://postimg.org/image/rdep7pqyf/ for the results I see in the command prompt windows.

In the first window I get a warning when running the command. In the second window on the mysql -u root command I get an access denied error and with the following command it says flush is not recognised as an internal or external command.

Not sure what i'm doing wrong, please can you advise?

Thanks.

Posted By: Rishi_P on July 7, 2016, 7:47 am | Post: 3

Hi,

Copy here last few line of mysql error log.
AMPPS Control Panel --> MySQL --> error Log Files.

Posted By: pb1uk on July 7, 2016, 6:33 pm | Post: 4

Hi Rishi,

I've pasted here: http://pastebin.com/zYbcvJR4

Thanks,

pb1uk

Posted By: pb1uk on July 7, 2016, 6:34 pm | Post: 5

Hi Rishi,

I've pasted here: http://pastebin.com/zYbcvJR4

Thanks,

pb1uk

Posted By: Rishi_P on July 8, 2016, 4:00 am | Post: 6

Hi,

Please open support ticket here.
https://www.softaculous.com/support/

Posted By: pb1uk on July 8, 2016, 4:47 pm | Post: 7

Thank you, i've added the link to this thread within the ticket #675626

Thanks,

pb1uk