Access Denied For User 'root'@'localhost' (using Password: No) Xampp Mac

Posted on

I am getting two errors when I try to go to my phpmyadmin localhost. Access denied for user 'root'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

C: xampp mysql>resetroot 100312 12:44:43 [Warning] Can't create test file usr local mysql data dan-pc.lower-test 100312 12:44:43 [Warning] Can't create test file usr local mysql data dan-pc.lower-test mysql bin mysqld.exe: Can't change dir to ' usr local mysql data ' (Errcode: 2) 100312 12:44:43 [ERROR] Aborting 100312 12:44:43 [Note] mysql bin mysqld.exe: Shutdown complete Passwoerter fuer Benutzer 'root' und 'pma' wurden nicht geloescht! Passwords for user 'root' and 'pma' were not deleted! Press any key to continue.. Note that I'm using WindowsXP, so I'm not surprised it can't find ' usr local mysql'! I don't know where it's getting that path from.

I've had this problem a few times before, and ended up reinstalling xampp to fix it. It works initially - and I can't find any pattern to what makes it suddenly stop working.

Newegg.com offers the best prices on computer products, laptop computers, LED LCD TVs, digital cameras, electronics, unlocked phones, office supplies, and more with fast shipping and top-rated customer service. Newegg shopping upgraded ™. Usb c to hdmi best buy, usb c to displayport and hdmi, usb c to hdmi 3ft, samsung s8 usb-c to hdmi adapter, usb c 4k 60hz hub, displayport alternate mode usb c, satechi usb c hub hdmi, usb c to. Mac computers can use an HDMI cable or adapter to connect to an HDTV, display, or other HDMI device. Mac computers that have any of the following ports can connect to HDMI devices. Learn how to identify the ports on your Mac. NOT SUPPORT Mac or other systems ] 【USB to HDMI Adapter】 The USB to. USB to HDMI Adapter, Hamkot USB 3.0 Converter to HDMI 1080P Video Multi Monitor Converter with Audio Output for Laptop HDTV TV PC with Windows XP / 7 / 8 /10 ( No Mac / Vista, Aluminum Silver ) by Hamkot. Usb in to hhdmi for mac. 1-16 of over 2,000 results for 'usb hdmi mac' USB to HDMI Adapter (Display Link Chipset), CableCreation USB 3.0 External Video Card for Windows, Mac and More, Most Compatible Resolution for USB to Display, Black. By CableCreation. $32.29 $ 32 29 Prime. FREE Shipping on eligible orders.

Thanks for any help with this, Dan. Posts: 8 Joined: 12. March 2010 12:55. You have to edit the config.inc.php file in xampp phpMyAdmin. Change lines 18-22: Code: /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '; $cfg['Servers'][$i]['AllowNoPassword'] = true; to: Code: /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'password'; $cfg['Servers'][$i]['AllowNoPassword'] = true; replacing 'password' with your actual password. Save the file and try to access phpMyAdmin again.

Access Denied For User

It should work. Posts: 148 Joined: 20. February 2010 20:13.

100424 12:15:50 [Warning] Can't create test file usr local mysql data Yoda.lowe r-test 100424 12:15:50 [Warning] Can't create test file usr local mysql data Yoda.lowe r-test mysql bin mysqld.exe: Can't change dir to ' usr local mysql data ' (Errcode: 2) 100424 12:15:50 [ERROR] Aborting 100424 12:15:50 [Note] mysql bin mysqld.exe: Shutdown complete Passwoerter fuer Benutzer 'root' und 'pma' wurden nicht geloescht! Passwords for user 'root' and 'pma' were not deleted! Press any key to continue.. Again, I don't know why it's looking for this directory. I've installed to 'C: ApacheFriends xampp ' as I'm on Vista 32 bit (and installing to Program Files is a bad thing so I've read).

I used the latest April 2010 XAMPP windows.exe installer. Install soup for maya 2016 mac download. I fixed up the directories as prompted during the configuration command prompt.

So having set up and being fairly new to this, somehow after following the suggestion to change my root user password I either set it to a hash value, or removed the root priveleges. (The page I did this on didn't explain very well what it was for, however it did allow my to change the password. It certainly wasn't the page). Myphpadmin at this point would no longer let me log in because it required a password that I didn't know.