AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Mamp phpmyadmin mysql access denied12/1/2023 ![]() I'm not reinstalling MAMP Pro every time I restart my computer. I don't know what else to try, and google hasn't been much help since the problem isn't my mysql credentials. The contents of the file may seem complicated in understanding, but. As a text editor, I use the TextEdit app, but you can use any other editor. In the Finder, go to the folder Applications MAMP bin phpMyAdmin. I deleted those site files and decided to try installing Magento again, and sure enough, I got the same error message when trying to add a database. If the MAMP app is running, click the Stop Servers button and quit the app. CRITICAL : exception 'PDOException' with message 'SQLSTATE Access denied for user This is roughly how the first line of that log file said: main. Instead there was an error message telling me to view the details in the exceptions log. Then, I updated my PC, and the site was no longer working. I was finally able to install Magento 2 after uninstalling and reinstalling MAMP Pro a couple of days ago. I've tried multiple databases and users, with and without passwords, and get the same result each time. The problem is not the database credentials. Console: php artisan cache:clear php artisan config:cache Now it works for me. Meant to say too thick for it.I've been trying to install Magento for weeks, and I keep running into this error when I try to add a database. DBCONNECTIONmysql DBHOST127.0.0.1 DBPORT3306 DBDATABASEyour database name DBUSERNAMEyour MySQL username DBPASSWORDyour MySQL password MySQL admin: SELECT user, host FROM er Thank you, spencer7593. ![]() Perhaps I am just too new to Mysql and PHP. If you need more info about this, please ask! ![]() 1 It will open in notepad as shown in figure. htaccess file if you don't have access to that file). So, you have to open XAMPP Control Panel ->Click MySql Config->Click my.ini XAMPP control panal fig. However I just used apache authentication in nf (or use a. If you are connecting directly via phpMyAdmin, then I think the following line in phpMyAdmin/ has something to do with it: $cfg = 'config' // Authentication method (config, http or cookie based)? Just login as moodle admin and then you can access the If you are connecting using the moodle db package, you don't need to doĪnything. What I still haven't sussed out is how to secure the root and still be able to access database admin via web access. For security reasons, you shouldn't use the root password for web accessible software - create a new one instead. Go to My Computer > C Drive > (Your Local Server. If you can still access your mysql database using another database username that has broad privileges, then you should be able to add a new username and password and then put the same in the moodle config.php. Xampp localhost Phpmyadmin Access denied for user rootlocalhost (using password: YES). I had set up another user with all the privileges and can still log into mysql and mysqladmin, but tring to restore user using command line prompts didn't work. If you know the password, then make sure it is correct in config.php. But it sounds like you may not be sure what the password is now. That suggest that the password you supplied in moodle's config.php is wrong (it doesn't match that for the moodle database). So I can't go into phpmyadmin or anything. Any access to the site via a browser shows that error message.
0 Comments
Read More
Leave a Reply. |