Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : #1045 - Access denied


Poll
Poll Question : Do the Post has more elaboration to its issues
Good (0) (0%)
Bad (0) (0%)
True (0) (0%)
False (0) (0%)

Total Votes : 0


2


Threaded Mode | Print  

#1045 - Access denied
fimaruf
Group: Member
Post Group: Newbie
Posts: 1
Status:
I am having the same problem on Mac OS Sierra. Nothing is working after several tries. Any help ?
IP: --   

#1045 - Access denied
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

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

#1045 - Access denied Hope MySQL password is patch
W4CO
Group: Member
Post Group: Newbie
Posts: 8
Status:

W4C Technical Support Team
Using AMPPS 3.8 32 bit | Win10 64bit Installed at E;/ampps with PHP 7.x | MySQL 5.6 | Port 3306

Note :: AMPPS softculous installation were for 'https://' (SSL) and not 'http://' which worked for many project for almost a months. But all of a sudden hope the third party software had overridden the mysql password (don't know which project). But the changes were made to root config which were not changed in the PHPmyadmin and 'my.conf'. We have verified the configuration --> 3.8  has mutliple directories correpsondeing to pre and post installation for which softaculous should have done some exraordinary depiction to avoid conflict of config for pre installation and post installation.

Worked almost a six month without any issue with new install and worked fine.

A week ago, started with all config, but dead with PHPmyadmin Connect to mysql with the password 'mysql' default.
Tried changing password - did not work
Use flushing privileges + failed a/w taskkill
innodb force recovery (adding and removing)
and all other steps as in this forum but failed.

Indeed 'mysql' in the my.conf is no accepted by server. Could be some issue with 'patch' or 'cache' but even using cluster of unused browsers connected to loclhost perfectly but failed to connect mysql server.

This is the major issue with no permanent fix.

Upgrading to AMPPS 3.9 had failed various project in the past, thus no further chane been taken for upgrade. Satisifed with 3.8

Used MySQL workbench and finally end just before last mile to connect mysql@localhost:3306, but again failed for password. Neither "blank", nor "mysql" nor any other tehnciquie seems to work. Just sake thought that 'mysql' from PHPmycinfig / mysql using password 'mysql' although working but failed.

Have kind to this issue and justify.
IP: --   

#1045 - Access denied
nnasco3k
Group: Member
Post Group: Newbie
Posts: 2
Status:
Sorry about the inconvenient.
The best way to have AMPPS access denied fix is manually.
Follow the steps and measure things are in place accordingly.

1. Download and install AMPPS.

2. Once installed, open the AMPPS on desktop. If the MySQL button didn't run,

3. Click on MySQL SETTINGS and then, click on CONFIGURATION to open on notepad.

4. Stroll down a little bit and sure PASSWORD, PORT are set to:
(a) password = mysql
(b) port = 3306 (for MySQL button to run, change 3306 to any 4 digit port number of your choice. and wherever you see 3306 should be equally be change to same number of your choice along the settings path when through down).

(C) socket = "{$path}/mysql/mysql.sock"

Please don't include a,b,c in brackets. This are my own of listing the steps for easy to follow. After change port number, save and close the notepad. After saving settings, close and  Restart AMPPS.

5. If MySQL button runs, click on HOME ???? at the top and when it open on the window address as localhost/ampps/
Click on PHPMYADMIN to try to access login section.
When the LOGIN section opens, if access denied or when you are trying to login failed (with username: root and default password: mysql).

6. Goto the root folder of your AMPPS where it's saved in C:\ drive. That's, C:\Ampps
and open the exact folders after it like this:
C:\Ampps\phymyadmin\config.inc.php

Right click and open config.inc.php on text editor and made changes to:

$cfg['servers'][$i]['port'] = 'insert your 4 digit number here';

Remove the 'insert your 4 digit  number here' . This are my own statement. My way of explaining it for easy to understand.
Example:
$cfg['servers'][$i]['port'] = '3390';
Replace it with number of your choice you first use in settings.

7.
$cfg['servers'][$i]['auth_type'] = 'cookie';

Config is changed to cookie. Save it.

8. Goto C:\Ampps\data\my.conf
Open my.conf on test editor and make sure the default password is : mysql

Save it.

9. Goto C:\Ampps\phpMyAdmin\config.sample.inc.php
Click and open config.sample.inc.php on test editor.
$cfg['servers'][$i]['auth_type'] = 'cookie';
????
Make it's set to cookie. Save it.

10. $cfg['servers'][$i]['AllowNoPassword'] = false;
????
It's your choice to decide.
If you want to allow the use of password, set it to:  $cfg['servers'][$i]['AllowNoPassword'] = false;

If you don't want to allow the use of password, set it to:  $cfg['servers'][$i]['AllowNoPassword'] = true;

Save your settings and close it.
After all the steps are followed, restart your AMPPS.
Click on HOME ???? and click on phyMyAdmin to either login with your default username: root and default password: mysql depending on what you choose in [AllowNoPassword] = TRUE or FALSE to have access to  phpMyAdmin index.
Thanks.
IP: --   

« Previous    Next »

Threaded Mode | Print  

2


Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 2:50 am.

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