error 1045 sql
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss error 1045 mysql the workings and policies of this site About Us Learn more about sql error 1045 access denied for user Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Sql Error 1045 HeidisqlJobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
Sql Error 1405Join them; it only takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote 238 down vote favorite 116 First let me mention that I've gone through many suggested questions and found no relevent answer. Here is what I'm doing. I'm connected to my Amazon EC2 instance. I can sql error 18456 login with MySQL root with this command: mysql -u root -p Then I created a new user bill with host % CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass'; Granted all the privileges to user bill: grant all privileges on *.* to 'bill'@'%' with grant option; Then I exit from root user and try to login with bill: mysql -u bill -p entered the correct password and got this error: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) mysql access-denied share|improve this question edited Sep 6 at 17:44 Jaap 1,2101431 asked Apr 24 '12 at 13:42 Ali 1,86581738 14 Did you FLUSH PRIVILEGES? –eggyal Apr 24 '12 at 14:10 1 Nope. Let me try that –Ali Apr 24 '12 at 14:15 1 Okay, I tried this without any success. Any other suggestion please. –Ali Apr 25 '12 at 4:35 1 What version of the server are you running? I've seen 5.1 behave oddly about this. –Poodlehat Jun 27 '12 at 14:27 1 This happened to me while install
08 Oct: Cross apply 08 Oct: HeidiSQL + SQLite 08 Oct: Title bar buttons flicker in Windows 10 07 Oct: Help with query 07 Oct: Postgres tree 07 Oct: Feature Request 07 Oct: Revision 4514 "Donate" button(s) 07 Oct: UI bug in window: User Manager? 06
Sql Error 1045 Access Denied For User Root@localhostOct: ERROR: syntax error at or near "DETERMI ... 06 Oct: Crash when accessing database sql error 1045 sqlstate 28000 tab. 06 Oct: php query 06 Oct: Help.. lost connection to mysql server ... 06 Oct: Bug: Crash showing tooltip of MediumTex ... phpmyadmin error 1045 05 Oct: 2 minor suggestions 05 Oct: Multiple "From IP"s in user manager 05 Oct: Remember queries between sessions (?RFC) 05 Oct: error: Received disconnect from 89.17.1 ... 05 Oct: Display issues with binary values DonateHow to donate http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw List of donors HelpRequirements Connecting to a server Command line switches The database tree Creating a table Creating a view Creating a stored procedure Creating a trigger Creating a scheduled event The Data tab Running SQL queries SQL export HeidiSQL portable License Credits SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES) New topic Register Log in 1 posts nickoo1234 posted 6 years ago in Creating a connection When I try to connect to http://www.heidisql.com/forum.php?t=7568 Heidi SQL for my World of Warcraft private server, I get this error message: SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES) Ive tried putting in NO password, I've tried ascent, AND I've tried root. Nothing works at all! Can somebody please help me fix this, this is very stressful. 34 posts Rapid-eraser posted 6 years ago If you can connect local with phpmyadmin it seams that your credentials don't have remote access ( or mysql server its self doesn't accept remote access) Try connecting through ssh tunneling where users don't have to be granted spacial remote access (read my posts for who to configuration plink+putty). If you don't want to use tunneling give remote access to your user reload privileges and try again. 785 posts kalvaro posted 6 years ago I assume you have forgotten the password you chose when you installed MySQL. Try this: How to Reset the Root Password 2 posts kevin39 posted 8 months ago You may across error #1045 Access Denied for user ‘root’@’localhost’ when yu try to access phpMyAdmin after complete installation of local host server. Main reason for this reason to take place is when the local host is not assigned with complete accessing authority or may be the password that is facilitated is incorrect. In order to solve this error you can try doing as
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start 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 http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no Learn more about Stack Overflow the company Business Learn more about hiring developers or https://www.digitalocean.com/community/questions/setup-mysql-on-ubuntu-droplet-getting-error-error-1045-28000-access-denied-for-user-root-localhost-using-password-yes posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. 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 error 1045 rise to the top ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no ) up vote 32 down vote favorite 10 I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no sql error 1045 ) But it's okay when I enter mysql -u root -p I can't figure out what the problem is. permissions mysql share|improve this question edited May 12 at 8:31 oerdnj 3,8461439 asked Jan 7 '14 at 10:42 user232705 161123 6 Try this: mysql -u root -p mysql Enter password: and you will get: mysql> –user273774 Apr 24 '14 at 18:47 add a comment| 3 Answers 3 active oldest votes up vote 28 down vote That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports: Access denied for user 'root@localhost' (using password: no ) Obviously when you give the password with the -p switch you succeed. share|improve this answer answered Jan 7 '14 at 10:47 falconer 9,91721846 add a comment| up vote 2 down vote In simple words your "root" session do not know password to mysql root user. If you want to make easier to access your mysql create .my.cnf in /root/ and put in it [mysqladmin] user = root password = mysqlrootpassword [mysql] user = root password = mysqlrootpassword [mysqldump] user = root password = mysqlrootpassword where offcourse mysqlrootpassword is your password for mysql's root p