Mysql Connect 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 hiring error 1045 sqlstate 28000 access denied for user 'root'@'localhost' developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Error 1045 Mysql Windows
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;
Mysql Access Denied For User Using Password Yes
it only takes a minute: Sign up ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) up vote 50 down vote favorite 37 I am an electrical engineering who mainly play around with power system instead of
Mysql Drop Anonymous User
programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge on mySQL at all, actually. I have done the following installations on my Ubuntu. sudo apt-get update sudo apt-get install mysql-server-5.5 sudo apt-get install mysql-client-5.5 sudo apt-get install mysql-common sudo apt-get install glade sudo apt-get install ntp Then I do me@ubuntu:~/Desktop/iPDC-v1.3.1/DBServer-1.1$ mysql -uroot -proot <"Db.sql" I ended up with the following error message. ERROR 1045 (28000): Access denied for user 'root'@'localhost' mysql access denied for user root (using password: YES) How may I fix it and continue? mysql linux ubuntu share|improve this question asked Feb 21 '14 at 20:52 Sibbs Gambling 3,2621042104 1 This does not seem to be strictly programming-related to me. I flagged it for migration to SuperUser –Uli Köhler Feb 21 '14 at 20:55 add a comment| 12 Answers 12 active oldest votes up vote 54 down vote accepted The default root password is blank (i.e. empty string) not root. So you can just login as: mysql -u root You should obviously change your root password after installation mysqladmin -u root password [newpassword] In most cases you should also set up individual user accounts before working extensively with the DB as well. Update: For MySQL 5.7+ please see answer from @Anshu to this question. That contains more current information. share|improve this answer edited Aug 29 at 13:40 answered Feb 21 '14 at 20:54 Mike Brant 51.7k54670 Thanks for the quick answer. Could you please explain what the -proot <"Db.sql part does? –Sibbs Gambling Feb 21 '14 at 20:57 @FarticlePilter The -p flag specifies the password, so after you change your root password you would do like mysql -u root -p[newpassword]. The < [filename] is using std input to execute an SQL file at the path given via the user credential you provide. –Mike Brant Feb 21 '14 at 21:00 3 I tried as t
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 mysql access denied for user using password no Us Learn more about Stack Overflow the company Business Learn more about hiring mysql access denied for user 'root'@'localhost' (using password no) developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange #1045 access denied for user localhost using password yes is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL - ERROR 1045 (28000): Access denied for user up vote 5 down vote favorite 3 I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root: david@server1:~$ mysql -u root -p123 I created a new user http://dba.stackexchange.com/questions/38803/mysql-error-1045-28000-access-denied-for-user called repl. I left host blank, so the new user can may have access from any location. mysql> CREATE USER 'repl' IDENTIFIED BY '123'; Query OK, 0 rows affected (0.00 sec) I checked the user table to verify the new user repl was properly created. mysql> select host, user, password from mysql.user; +-----------+------------------+-------------------------------------------+ | host | user | password | +-----------+------------------+-------------------------------------------+ | localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | server1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | ::1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | localhost | | | | server1 | | | | localhost | debian-sys-maint | *27F00A6BAAE5070BCEF92DF91805028725C30188 | | % | repl | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | +-----------+------------------+-------------------------------------------+ 8 rows in set (0.00 sec) I then exit, try to login as user repl, but access is denied. david@server1:~$ mysql -u repl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ mysql -urepl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ Why is access denied? mysql share|improve this question edited May 16 at 18:59 culix 1035 asked Mar 28 '13 at 19:44 davidjhp 2141313 have you tried creating this user with a specific
Us MySQL ERROR 1045 (28000): Access denied for user 'root' - Solution Contents[Hide]Symptom:Solution: 1.Symptom: Unable to access MySQL database remotely using root account. Any attempt to access MySQL database will https://linuxconfig.org/mysql-error-1045-28000-access-denied-for-user-root-solution result in error: ERROR 1045 (28000): Access denied for user 'root'@'ip-address' (using password: YES) 2.Solution: The above MySQL error message is a default behavior of the MySQL server to disallow a Root user to connect remotely as by default the Root user is allowed to connect to MySQL server on from localhost that is 127.0.0.1. The solution is to create a new admin access denied user. The below SQL commands will create new user called admin and grant remote access: mysql> CREATE USER 'admin'@'%' IDENTIFIED BY ''; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) Alternative but not recommended solution is to grant remote MySQL access to root user: mysql> GRANT access denied for ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) The above line will grant a privilege to the root user to connect remotely: $ mysql -u root -ppassword -h 172.17.0.14 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 41 Server version: 5.5.43-0+deb8u1 (Debian) Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> Bye Please enable JavaScript to view the comments powered by Disqus. Free Linux eBooks Linux® Quick Fix Notebook Understanding the Linux® Virtual Memory Manager Introduction to Linux - A Hands on Guide An Introduction to Design Patterns in C++ with Qt 4 Open Source Security Tools Ubuntu Linux Toolbox: 1000+ Commands Self-Service Linux®: Mastering the Art of Problem Determination Linux® Patch Management Managing Linux® Systems with Webmin™ The Official Samba-3 HOWTO and Reference Guide Linux Device Drivers, 2nd Edition User Mode Linux Java™ Application Development on Linux Tradepub EbooksIntroduction to Linux - A Hands on Guidehttp://linuxconfig-org.tradepub.com/free/w_mach01/?p=w_mach01Understanding the Linux® Virtual Memory Managerhttp://linuxconfig-org.tradepub.com/free/w_infk10/?p=w_infk10User Mode Linuxhttp://linuxconfig-org.tradepub.com/free/w_infk09