Databases :: MySql :: Access denied to user MY_USER@localhost (User passwrod: YES) |
|||
By: Squibi  |
Date: 18/10/2004 00:00:00  |
Points: 125 | Status: Answered Quality : Excellent |
|
Let me start by saying that i am running Windows XP I have just installed mySQL as i am intressed to use it... i also download the control center... i seem to be getting this error when i try to connecto to my database... Access denied to user MY_USER@localhost (User password=YES) CAN ANYONE HELP??? |
|||
| By: paullamhkg | Date: 18/10/2004 12:11:00 | |
Type : Answer |
| ok, normally after you install the mysql all users can access it without using password, in your case you provide a password for MY_USER while trying to login/access mysql. try this mysql -u MY_USER, you will able to get into it. eg. C:\mysql\bin>mysql -u root (root is the superuser of mysql) Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.12-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> without password for root is risky, so now try to assign a password to the root do this mysql> SET PASSWORD FOR root@localhost=PASSWORD('[the new password for root]'); Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.16 sec) you can also do the above for the user(s) having password to login. Try to read the doc. at <A HREF="http://www.mysql.com">www.mysql.com</A> |
|||
| By: VGR | Date: 18/10/2004 16:25:00 | |
Type : Assist |
| just a detail : apparently, this syntax works better and nobody knows why :D mysql --user=root --password=thepassword or (if no root password yet) mysql --user=root |
|||
| By: paullamhkg | Date: 18/10/2004 16:30:00 | |
Type : Comment |
| because you are the expert's expert :) I did know after I read the mysql manual, that why reading the doc. on the mysql web or manual also the way to find a solution :) |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
