Softaculous

Topic : MySQL Said: Access Denied

Posted By: MiguelRSolans on April 25, 2016, 3:18 pm

Good afternoon, morning or night depending on the place you're reading this thread.

Very recently I have started a school project, and for that I must learn this MySQL PHPmyAdmin. However, I'm not being successful to access as it always returns with this message: "MySQL Said: Cannot connect: invalid settings.". Also, I can't turn on MySQL in AMPPS Control Center. I've followed many tutorials already on how to fix this - changing the username and password, some lines of code, I managed to connect the MySQL however I still get the same message.

I am using OS X El Capitan (latest update version 10.11.4), many people have said this is a bug but can be fixed, however no one to date explained me how to fix this issue.

As the project must be delivered within weeks, I'm running against the time to finish this thing. I will be very thankful if anyone manages to help me!

Waiting for replies,

Miguel Solans

Posted By: Rishi_P on April 26, 2016, 8:52 am | Post: 1

Hi,

MySQL password is saved in /Applications/AMPPS/data/my.conf file.

Did you changed MySQL default password ?

If yes then go to /Applications/AMPPS/data directory, open my.conf and check your password is correct or not.

To resolve this problem ,a fast and always working way is the "Password Resetting" .
Open Terminal and run following commands:

Code

sudo killall mysqld (run 2-3 times)

cd /Applications/AMPPS/mysql/bin

./mysqld --skip-grant-tables

Now open second Terminal and run following commands to reset MySQL password.

Code

cd /Applications/AMPPS/mysql/bin

mysql -u root

FLUSH PRIVILEGES;

USE mysql

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

FLUSH PRIVILEGES;

quit;

Now open my.conf file ( /Applications/AMPPS/data/my.conf) type only mysql and save it.

Restart AMPPS MySQL from control panel.

Also check if there is another version of MySQL is installed on your machine or not.

If you are still facing the same issue then please open support ticket here:
https://www.softaculous.com/support/