Mysql Error 1045 Fix
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: ERROR 1045 (28000): Access denied for user mysql error 1045 access denied for user 'root'@'localhost' 'root'@'localhost' (using password: NO) New Topic Advanced Search EASY FIX error 1045 mysql windows to Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Marta N error 1045 sqlstate 28000 access denied for user 'root'@'localhost' () Date: January 31, 2011 04:45AM Easy Fix is to make sure that the user that you are connecting with have settings to access db from
#1045 - Access Denied For User ''@'localhost' (using Password: Yes)
both ALL HOSTS (%) AND from LOCALHOST. If you are using mysql Administrator to manage your DBs go to User Administration (link on left side) choose or create user that you want to connect with to db then right click on this user pick add host choose any host and ok (it should add #1045 - access denied for user 000webhost @ % sign under user) then do the same but this time add localhost (this also will be indicated under your user) And at last the most important thing Apply Changes to this user so it will keep the settings. As addition later you can play with privilages of your user by clicking on schema privileges tab and assigning additional privilages from available list. Enjoy your administration Marta Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 01:16PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 07:49PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) carminda timas 05/11/2007 02:20PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Eric Okorie 05/21/2007 10:57PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) pigeret john 07/22/2007 01:59AM Re: ERROR 1045 (28000): Acce
MySQL/PHPMyAdmin #1045 Error TNWProduction's channel SubscribeSubscribedUnsubscribe3030 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the video? Sign in to report inappropriate content. Sign mysql access denied for user 'root'@'localhost' in Transcript Statistics 44,212 views 30 Like this video? Sign in to make your
#1045 - Access Denied For User (using Password: Yes) 000webhost
opinion count. Sign in 31 29 Don't like this video? Sign in to make your opinion count. Sign in 30 Loading... Loading...
Access Denied For User ''@'localhost' (using Password: No)
Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Uploaded on Feb 20, 2012Hello youtube! http://forums.mysql.com/read.php?11,34014,405579 This video is showing you how to fix the error #1045 when trying to get into PHPMyAdmin. Although my PHPMyAdmin wouldn't load up due to not being connection my server, if you do it right, and go to localhost/phpmyadmin/ it should load up with phpmyadmin in the corner, and on the right tell you your apache, server #, and mysql # Category Howto & Style License Standard YouTube License Show more Show less https://www.youtube.com/watch?v=AYOK_gUB0h4 Loading... Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next MySQL Error number:1045 Resolved - Duration: 4:39. RGN TAMIL 74,977 views 4:39 wamp phpMyAdmin error #1045 - Access denied for user root@locahost Fixed! - Duration: 4:56. locslikes 35,678 views 4:56 Error #1045 de Mysql generado en phpMyAdmin (Resuelto) - Duration: 9:29. Roberto Carlos Bustillos Duran 36,146 views 9:29 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Duration: 2:46. Solution Cone 76,034 views 2:46 How to fix error #1045 - Access denied for user 'root' in phpmyadmin - Duration: 4:31. E Angkor 62,260 views 4:31 WAMP Error 1045 phpMyAdmin : 'root'@'localhost' (using password: NO) - Duration: 3:04. TheMikeyKam 105,218 views 3:04 PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD- - Duration: 11:26. RiverCityGraphix 284,428 views 11:26 How to fix phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection - Duration: 2:28. Jhon Smith 25,829 views 2:28 XAMPP 'attempting to start ...' ERROR - HOW TO FIX! - Duration: 1:19. Chinaaatheboss 39,604 views 1:19 WAMP error: Forbidden You don't have permission to access /phpmyadmin/ on this server - Duration: 1:30. Sooraj Mohan 64,159 views 1:30 How to remove error number 2003 on mysql server - Duration: 3:46. Irfan Ahmad Ganie 4
Resolved RGN TAMIL SubscribeSubscribedUnsubscribe1,7241K Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the video? Sign in https://www.youtube.com/watch?v=BfnTSo5XM1A to report inappropriate content. Sign in Transcript Statistics 75,012 views 410 Like this video? Sign in to make your opinion count. Sign in 411 16 Don't like this video? Sign in to make http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost your opinion count. Sign in 17 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This feature is not available right access denied now. Please try again later. Published on May 27, 2012Its the perfect solution for MySQL Error number 1045.. All u have to do is just follow the video and do the same.. u'll be succeeded.. if not just inform through comments i'll provide u a better solution Category Howto & Style License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, access denied for a suggested video will automatically play next. Up next Error #1045 de Mysql generado en phpMyAdmin (Resuelto) - Duration: 9:29. Roberto Carlos Bustillos Duran 36,146 views 9:29 Mysql 4.1 error : Error Nr. 1045 access denied for user 'root'@'localhost' - Duration: 2:35. Ambar Hasbiyatmoko 1,749 views 2:35 How to Fix MySQL/PHPMyAdmin #1045 Error - Duration: 3:53. TNWProduction 44,003 views 3:53 MySQL Error number 1045 solved - Duration: 2:42. faazaunlimited 48,496 views 2:42 How To Install mySQL in Windows 10 - Duration: 8:23. DENRIC DENISE - INFO 82,186 views 8:23 Tutorial - Como resolver ERROR no MySQL "Can't connect to MySQL server on 'localhost' " - Duration: 3:04. NappaPlayer 59,327 views 3:04 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Duration: 2:46. Solution Cone 76,034 views 2:46 wamp phpMyAdmin error #1045 - Access denied for user root@locahost Fixed! - Duration: 4:56. locslikes 35,678 views 4:56 MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to it - Duration: 8:50. primetubervideos 662,121 views 8:50 2003 - Can't connect to MySQL (FIX!) - Duration: 0:56. Misterblacjack 43,762 views 0:56 How to remove error number 2003 on mysql server - Duration: 3:46. Irf
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 site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top mysql how to fix Access denied for user 'root'@'localhost' up vote 52 down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | game_data | | test | +--------------------+ Then I try to create a new user and notice something is wrong with the PRIVILEGES. So I deleted the new users, and I guess I removed the 'root' and 'Admin' accidentally. Then I try to create 'root' again, but get Access denied error when doing grant all privileges. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) If I login mysql again using $ mysql -u root -p, and show databases, +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ All the other databases are gone. How do I fix mysql now? I cannot cannot find the database 'mysql', cannot create database, create user, anything I try to do will get an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Should I reinstall mysql using macports? If reinstall, I will lost the database 'game_data', right? mysql user-accounts login privileges share|improve this question edited Dec 31 '15 at 11:36 Eric Leschinski 2,73742642 asked Jun 3 '13 at 7:32 Vogelsire 363146 migrated from stackoverflow.com Jun 3 '13 at 8:32 This question came from our site for professional and enthusiast programmers. Try accesing the server with 'root'@'127.0.0.1' which is diferent from 'root'@'localhost'. Then issue a command to create the user 'root'@'localhost' a