Not the answer you're looking for? When people brag about their abilities and belittle their opponents before a battle, competition, etc Zipped hard drive image very big Can one be "taste blind" to the sweetness of stevia? Reloading the privilege tables will ensure that all changes made so far will take effect immediately. mysql -u repl -p123 -h127.0.0.1 Believe it or not, mysql would attempt [email protected] again. http://rlegsoftware.com/mysql-error/1045-error-mysql.php
Using existing password for root. 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 If you don't make backups of your important data, your data is obviously not important to you. Now the user is allowed to login share|improve this answer edited Apr 20 '15 at 11:49 Jon 4,35142141 answered Apr 20 '15 at 11:19 vigremrajesh 311 It worked for http://stackoverflow.com/questions/489119/mysql-error-1045-access-denied
Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting). $ mysqld --skip-grant-tables Execute these statements. $ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; I have uninstalled mysql completley and reinstalled but I still get asked for a password. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y Success. Add to Want to watch this again later?
Thank you, @Mario Flores –SpacePope 1 hour ago add a comment| You must log in to answer this question. Length of i in Vergilius' "ferentis" How to indicate you are going straight? Don't forget to flush the privileges before quiting the client. Mysql Error 1045 Dreamweaver It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
Adv Reply September 1st, 2011 #2 Wim Sturkenboom View Profile View Forum Posts Private Message I Ubuntu, Therefore, I Am Join Date Jan 2005 Location South Africa Beans 2,098 DistroUbuntu Mysql Error 1045 Using Password Yes current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. While installing Drupal 7 in localhost0MySQL - access denied for user [email protected] Hot Network Questions Is it correct to say my domestic name is? Why are some programming languages turing complete but lack some abilities of other languages?
Roberto Carlos Bustillos Duran 35,398 views 9:29 Mysql 4.1 error : Error Nr. 1045 access denied for user 'root'@'localhost' - Duration: 2:35. Mysql Error 2003 [email protected]:~$ mysql -u repl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) [email protected]:~$ mysql -urepl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) Would doing this help ? Plural of "State of the Union" i love yOu i lOve you i love yOu!
New password: Re-enter new password: If you see it says ...
I know mySQL is running because when I type in: ps -ef | grep mysql I get mysql 1149 1 0 20:23 ? 00:00:00 /usr/sbin/mysqld jeremy 2314 2283 0 20:34 pts/0 Access Denied Using Password No Aaron Hu 03/06/2008 10:53PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Benjamin Clement 03/21/2008 04:30AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Mysql Error 1045 28000 Not the answer you're looking for?
Type 'help;' or '\h' for help. navigate here CREATE USER 'repl'@'localhost' IDENTIFIED BY '123'; But I do not want to restrict the user to some host, I would prefer to have any host. –davidjhp Mar 28 '13 at 20:02 Please set a new password. u'll be succeeded.. Mysql Error 1045 Windows
Go to My Computer > C Drive > (Your Local Server Folder, WAMP/MAMP/XAMPP) > APPS > PHPMYADMIN > config.inc.php Find this line of code: $cfg['Servers'][$i]['password'] = ''; // MySQL password Change When in doubt, check the manual –deucalion May 26 '15 at 11:39 3 It needs to be edited in to the answer –Canadian Luke May 26 '15 at 14:31 1 This is why the error message says Access denied for user 'repl'@'localhost' (using password: YES). http://rlegsoftware.com/mysql-error/1045-error-mysql-nr.php That file contains a password; paste that password when prompted for it.
Nizam LZ 38,474 views 11:56 Tutorial - Como resolver ERROR no MySQL "Can't connect to MySQL server on 'localhost' " - Duration: 3:04. Mysql Create User What are the holes on the sides of a computer case frame for? Preparing an old Windows XP computer for Xubuntu and installing it Potion of Longevity and a 9 year old character How does the Booze-Rat fuel its defensive mechanism?
If you get an Error #1045 in phpMyAdmin it will look like the image below: Step 1: Open your MySQL console. TheMikeyKam 104,877 views 3:04 2003 - Can't connect to MySQL (FIX!) - Duration: 0:56. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. http://rlegsoftware.com/mysql-error/1045-error-in-mysql.php Loading...
Yes, of course I'm an adult! What does the path '/../' mean? hashan maduranga 09/28/2010 03:37PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Willie Jackson 07/11/2007 11:44AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Adv Reply September 4th, 2011 #6 Wim Sturkenboom View Profile View Forum Posts Private Message I Ubuntu, Therefore, I Am Join Date Jan 2005 Location South Africa Beans 2,098 DistroUbuntu
What are the holes on the sides of a computer case frame for? How to deal with a DM who controls us with powerful NPCs? share|improve this answer answered Jan 7 '14 at 10:47 falconer 9,87721746 add a comment| up vote 2 down vote In simple words your "root" session do not know password to mysql Using WAMP, left click your WAMP icon located at the bottom right of your desktop and click on MySQL Console.
This is intended only for testing, and to make the installation go a bit smoother. Should I include him as author? You can modify these tutorials. This ensures that someone cannot guess at the root password from the network.
MySQL error number 1045. Ambar Hasbiyatmoko 1,473 views 2:35 MySQL Error number 1045 solved - Duration: 2:42. Grant the user admin with password using GRANT command once again mysql> GRANT ALL PRIVILEGE ON *.* TO 'admin'@'%' IDENTIFIED by 'password' then check the GRANT LIST the out put will Draw a line under a figure that match the figure lentgh What does the path '/../' mean?
Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 16 Thread: mySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost Thread Tools Show Printable Version Subscribe