Mysql New User Error 1045
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 site About Us Learn more about Stack Overflow the company Business Learn more about error 1045 sqlstate 28000 access denied for user 'root'@'localhost' hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Mysql Drop Anonymous User
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each mysql access denied for user using password yes other. Join them; it only takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote 240 down vote favorite 118 First let me mention that I've gone through many suggested
Mysql Access Denied For User Root
questions and found no relevent answer. Here is what I'm doing. I'm connected to my Amazon EC2 instance. I can 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 #1045 access denied for user localhost using password yes 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,88081738 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 installing Magento and I made a much sillier mistake. Putting 'mysql -u magento -p magento' was prompting me for a password and instead of the default password I was putting the root password in. –AmirHd Oct 29 '13 at 3:26 | show 4 more comments 26 Answers 26 active oldest votes up vote 282 down vote accepted You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'. As per the manual: When multiple matches are possible, the server must determine which of them to use. It resolves this issue as follows: (...) When a client attempts to connect, the server looks through the rows [of table mysql.user] in sorted order. The server uses the first row th
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Error 1045 Mysql Windows
of this site About Us Learn more about Stack Overflow the company
Mysql Access Denied For User Using Password No
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges #1045 - access denied for user 000webhost Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw Sign up MYSQL - access denied to new user with specific permissions - MYSQL error 1045(28000) up vote 0 down vote favorite I was setting up mysql on my prod server, this is actually the first time i set up a prod installation of mysql. I've logged in as root, created my DBs, and then i've created 2 users as follow: User1/permissions http://stackoverflow.com/questions/30621294/mysql-access-denied-to-new-user-with-specific-permissions-mysql-error-10452 on database1 CREATE USER 'jhon'@'localhost' IDENTIFIED BY 'passwd'; GRANT CREATE ON database1 TO 'jhon'@'localhost'; GRANT INSERT ON database1.* TO 'jhon'@'localhost'; GRANT SELECT ON database1.* TO 'jhon'@'localhost'; GRANT UPDATE ON database1.* TO 'jhon'@'localhost'; User2/permissions on database2 CREATE USER 'jhonjhon'@'localhost' IDENTIFIED BY 'passwdpasswd'; GRANT CREATE ON database2 TO 'jhonjhon'@'localhost'; GRANT INSERT ON database2.* TO 'jhonjhon'@'localhost'; GRANT SELECT ON database2.* TO 'jhonjhon'@'localhost'; GRANT UPDATE ON database2.* TO 'jhonjhon'@'localhost'; and then FLUSH PRIVILEGES; exit; Now i'm trying to log in as 'jhon' or 'jhonjhon', with the command: mysql -u jhon -p but both attempts give me ERROR 1045 (28000): Access denied for user 'jhon'@'localhost' (using password: YES) I've also tried to select the database directly with -D option, accordingly with the permissions set above..but nothing, Mysql still denies access. Where am i wrong? thanks EDIT Users List: | root | 127.0.0.1 | | root | ::1 | | debian-sys-maint | localhost | | root | localhost | | jhon | localhost | | jhonjhon | localhost | System Info: Ubuntu 14.04 LTS - MYSQL Ver 14.14 Distrib 5.5.43 mysql denied share|improve this question asked Jun 3 '15 a
have one accepted answer. Are you sure you want to replace the current answer with this one? Yes, I'm sure. Changed your mind? You 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 previously marked this answer as accepted. Are you sure you want to unaccept it? Yes, I'm sure. Sign Up Log In submit Tutorials Questions Projects Meetups Main Site logo-horizontal DigitalOcean Community https://www.devside.net/wamp-server/mysql-error-1045-28000-access-denied-for-user-localhost Menu Tutorials Questions Projects Meetups Main Site Sign Up Log In submit View All Results By: greg535417 Subscribe Subscribed Share 0 Setup MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): access denied Access denied for user 'root'@'localhost' (using password: YES) December 3, 2015 28.3k views MySQL Hi guys, I am very new to using a service like digitalocean (opposed to a one click setup of mediatemple or godaddy) and I am trying to setup and configure a new DB using MySQL but I keep getting the error ERROR 1045 (28000): Access denied for access denied for user 'root'@'localhost' (using password: YES) I have googled this, and searched the community for answers but cannot seem to solve this issue. Am I missing something? I have tried running it as root, and running it with sudo through another user and cannot get around it. If I offer no password it gives the same error but instead of using password: YES, it's NO. Thanks. 3 comments 0 mikionline20 January 19, 2016 I faced like this error while i want check my database ERROR 1045 (28000): Access denied for user 'user02'@'localhost' (using password: NO) do you have solution about this 0 CrypticDesigns January 19, 2016 Same solution, just login as root and then change password of the user: update user set password=PASSWORD("YOURPASSWORDHERE") where User='user02'; 0 sergeyvlasov July 3, 2016 Experienced the same problem. This particular explanation and solution made sense for me and helped as well: http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw Log In to Comment Leave a Comment Add comments here to get more clarity or context around a question. To answer a question, use the “Answer” field below. Log In to Comment 5 Answers 5 CrypticDesign
Server Enabling IonCube Loader in WAMP Enabling Zend Guard Loader for PHP 5.4, 5.3, or Zend Optimizer for PHP 5.2 Installing and Using ImageMagick with Imagick PHP Extension (php_imagick.dll) on WAMP Recent Posts Changing WampDeveloper's Default Text Editor and Browser How to automatically restart Apache Service on Windows (and recover from crash) Running Apache and MySQL side-by-side with IIS (or WebMatrix and Web Platform) Using Dropbox To Host or Backup Websites and Database Folders on Windows Disabling SSLv3 in Apache By Setting SSLProtocol (be aware of VirtualHost issue) Categories Blog WAMP Developer Server MySQL ERROR 1045 (28000): Access denied for user ‘db_user_name'@'localhost' I have software that requires direct access to the MySQL database. If I run it on the same computer as WAMP it works, but if I access the database with this software from another computer, it then reports error: MySQL ERROR 1045 (28000): Access denied for user 'db_user_name'@'localhost' (using password: YES) Create the same database user (i.e., with the same name + password as the existing user) in MySQL (via \phpmyadmin), except set the "Host:" field to either the connecting remote IP address, or to "%" (which means any IP can connect). This way you'll be able to use this user to access the database from 127.0.0.1 (Host:127.0.0.1), and also from an outside system (Host:%). Also make sure that you have already: Re-bound MySQL from IP 127.0.0.1 to 0.0.0.0 Opened incoming port 3306 requests in Windows Firewall (and removed any existing blocking MySQL rules). Port-forwarded port 3306 in the Router from WAN:3306 to LAN-IP:3306 (if accessing from outside the LAN). And that this database user has all permissions granted on the specific database(s), and the outside application is using the proper: IP, database name, user name, user password - to establish the connection. If you have the mysql client on the remote system, you can also manually test this from the command-line via: mysql -u db_user_name -p -h ip.address.here -P 3306 Accessing MySQL or phpMyAdmin From Outside Posted on June 11, 2015Author adminCategories WAMP Developer ServerTags FAQ Leave a Reply Cancel reply Your email address will not be published. Name Email Website Comment You may use these HTML tags and attributes:
Post navigation Previous Previous post: Running .NET 3.5 App on .NET 4.5 of Windows 8 and Server 2012Next Next post: Laravel - No supported encrypter found. The cipher or key length are invalid. Proudly