1045 Mysql Error Xampp
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this xampp mysql error log site About Us Learn more about Stack Overflow the company Business Learn more
Xampp Phpmyadmin Error
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x joomla mysql error Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error #1045 php mysql error phpmyadmin xampp w7 up vote 0 down vote favorite I installed xampp, I've run mysql and apache, but when I access to phpmyadmin gives me error # 1045.I've tried different things like going to the configuration file of phpmyadmin and change some settings but nothing changes. The problem is that before it went, but then I set the local root user for a random psw
#1045 - Access Denied For User 'root'@'localhost' (using Password No) Xampp
and I do not know, and from there it gives me access denied to the localhost. Is there a way to be able to solve this problem!? Very important!! HELP ME!! phpmyadmin xampp localhost windows-7-x64 mysql-error-1045 share|improve this question asked Mar 29 '14 at 15:10 Andrea 14 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote The first thing you need to do is revert the changes you did in config.inc.php. Make sure the root settings looks like this $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; Use the following procedure to reset the root password for localhost: Start the xampp control panel as an administrator and stop mysql Create a text file containing the following statements. Replace the password with the password that you want to use. UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES; Write the UPDATE and FLUSH statements each on a single line. The UPDATE statement resets the password for all root accounts, and the FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change. Save the file. For this example, the file will be
ad-free videos and music with YouTube Red. Working... No thanks Try it free Find out whyClose Error #1045 in phpMyAdmin www.2tech.me SubscribeSubscribedUnsubscribe979979 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this phpmyadmin error 1045 cannot log in to the mysql server video to a playlist. Sign in Share More Report Need to report the video? phpmyadmin access denied xampp Sign in to report inappropriate content. Sign in Statistics 3,577 views 5 Like this video? Sign in to make your
Mysql Said: Documentation #1045 - Access Denied For User 'root'@'localhost' (using Password: No)
opinion count. Sign in 6 2 Don't like this video? Sign in to make your opinion count. Sign in 3 Loading... Loading... Loading... Rating is available when the video has been rented. This feature http://stackoverflow.com/questions/22732801/error-1045-phpmyadmin-xampp-w7 is not available right now. Please try again later. Published on Oct 15, 2014After installing a local server and trying to access phpMyAdmin, you could possibly encounter the error: #1045 Access Denied for user 'root'@'localhost' (using password: YES).to solve this error Following this tutorial will help guide you on bypassing this error, for any local host server using phpMyAdmin.If You like this Video dont Forget to Subscribe Website: https://www.youtube.com/watch?v=1eVfJ_DRONQ http://www.2tech.meFacebook Page : https://www.facebook.com/pages/2techm...Gppgle+: https://plus.google.com/+2techMe/YouTube Channel: http://www.youtube.com/Mamdoohza Category Education License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next MySQL said: Cannot connect invalid settings error | XAMPP Phpmyadmin - Duration: 3:28. maliki abdel nasser 6,829 views 3:28 Erro #1045 - Access denied for user 'root'@'localhost' (using password: NO) - Duration: 9:53. Marcio Ribeiro 436 views 9:53 How to fix error #1045 - Access denied for user 'root' in phpmyadmin - Duration: 4:31. E Angkor 56,918 views 4:31 localhost error : forbidden and phpmyadmin access denied for user root - Duration: 4:48. Ambar Hasbiyatmoko 248 views 4:48 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) - Duration: 4:53. Mohammad Sheam 52,611 views 4:53 how to solve #1045 - Access denied for user 'root'@'localhost' (using password: YES) - Duration: 2:29. Abhishek Gakhar 3,962 views 2:29 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Duration: 2:46. Solution Cone 73,694 views 2:46 SoluciĆ³n al problema acceso denegado | Phpmyadmin - Duration: 4:26. MegaCasalta 16,633 views 4:26 Error establishing a database connection in 000webhost - Duration: 1:53. Learner's TV 18,205 views 1:53 Wamp Server #
error #1045 - Access denied for user 'root' in phpmyadmin E Angkor SubscribeSubscribedUnsubscribe960960 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign https://www.youtube.com/watch?v=oz6BTvpn3qY in Share More Report Need to report the video? Sign in to report inappropriate content. Sign in Statistics 57,998 views 57 Like this video? Sign in to make your opinion count. Sign https://ubuntuforums.org/showthread.php?t=1617399 in 58 20 Don't like this video? Sign in to make your opinion count. Sign in 21 Loading... Loading... Loading... Rating is available when the video has been rented. This feature is mysql error not available right now. Please try again later. Published on Oct 17, 2015#1045 - Access denied for user 'root'@'localhost' (using password: NO or YES), if have problem like this , please try Category Education License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next MySQL said: Cannot connect invalid settings #1045 - access error | XAMPP Phpmyadmin - Duration: 3:28. maliki abdel nasser 6,829 views 3:28 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) - Duration: 4:53. Mohammad Sheam 52,611 views 4:53 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Duration: 2:46. Solution Cone 73,694 views 2:46 How to install PHPmyadmin for 000webhost - Duration: 6:29. jozsi jozsika 16,686 views 6:29 wamp phpMyAdmin error #1045 - Access denied for user root@locahost Fixed! - Duration: 4:56. locslikes 34,888 views 4:56 Erro #1045 - Access denied for user 'root'@'localhost' (using password: NO) - Duration: 9:53. Marcio Ribeiro 436 views 9:53 XAMPP mysql error Solved - Duration: 3:36. Solution Cone 22,452 views 3:36 how to solve #1045 - Access denied for user 'root'@'localhost' (using password: YES) - Duration: 2:29. Abhishek Gakhar 3,962 views 2:29 Error establishing a database connection in 000webhost - Duration: 1:53. Learner's TV 18,205 views 1:53 How to fix phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection - Duration: 2:28. Jhon Smith 24,856 views 2:28 localhost error : forbidden and phpmyadmin access denied for user root - Duration: 4:48. A
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support New to Ubuntu [SOLVED] XAMPP/phpMyAdmin: 1045: Access denied for user '[root]'@'localhost' (using password.. Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 2 of 2 Thread: XAMPP/phpMyAdmin: 1045: Access denied for user '[root]'@'localhost' (using password.. Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode November 9th, 2010 #1 flameproof View Profile View Forum Posts Private Message Frothy Coffee! Join Date Nov 2006 Location Hong Kong Beans 192 DistroUbuntu XAMPP/phpMyAdmin: 1045: Access denied for user '[root]'@'localhost' (using password.. I get sooo annoyed, every time I install XAMPP on Windows or Ubuntu (or now Xubuntu) I get when I type http://localhost/phpmyadmin/ sooner or later 1045: Access denied for user '[root]'@'localhost' (using password.... Then I forget how to fix it and search, search search and finally reinstall XAMPP. But it's actually very easy to fix: 1. Open config.inc.php file in the phpmyadmin directory 2. Find line 21: $cfg['Servers'][$i]['password'] = '' 3. Change it to: $cfg['Servers'][$i]['password'] = 'your_password'; 4. Restart XAMPP This should often work in Windows and Linux. PS: I just post it here so I know where to look and find it next time. Last edited by flameproof; November 9th, 2010 at 11:43 PM