Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL Access Denied after Windows 10 upgrade



Threaded Mode | Print  

 MySQL Access Denied after Windows 10 upgrade (7 Replies, Read 3638 times)
pb1uk
Group: Member
Post Group: Newbie
Posts: 6
Status:
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
IP: --   

MySQL Access Denied after Windows 10 upgrade
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
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
IP: --   

MySQL Access Denied after Windows 10 upgrade
pb1uk
Group: Member
Post Group: Newbie
Posts: 6
Status:
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.
IP: --   

MySQL Access Denied after Windows 10 upgrade
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

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

MySQL Access Denied after Windows 10 upgrade
pb1uk
Group: Member
Post Group: Newbie
Posts: 6
Status:
Hi Rishi,

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

Thanks,

pb1uk
IP: --   

MySQL Access Denied after Windows 10 upgrade
pb1uk
Group: Member
Post Group: Newbie
Posts: 6
Status:
Hi Rishi,

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

Thanks,

pb1uk
IP: --   

MySQL Access Denied after Windows 10 upgrade
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

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

MySQL Access Denied after Windows 10 upgrade
pb1uk
Group: Member
Post Group: Newbie
Posts: 6
Status:
Thank you, i've added the link to this thread within the ticket #675626

Thanks,

pb1uk
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 30, 2024, 12:26 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.023