Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL Said: Access Denied



Threaded Mode | Print  

 MySQL Said: Access Denied, Can't access phpmyadmin (1 Replies, Read 2314 times)
MiguelRSolans
Group: Member
Post Group: Newbie
Posts: 1
Status:
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
IP: --   

MySQL Said: Access Denied
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
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/
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 16, 2024, 12:35 pm.

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