Databases :: MySql :: 1044 access denied for user admin@localhost (using password: YES) |
|||
By: IceCoffee  |
Date: 01/08/2003 00:00:00  |
Points: 125 | Status: Answered Quality : Excellent |
|
here it is: i have Windows 2000 server installed latest stable version of mysql on server executed WinMySQLAdmin and set my admin username and password than when i tried to connect to database with Mysql front program or execute my php script that connects to database i get error: Access denied for user: admin@localhost (Using Password: YES) i tried granting user access from console but than i get same error in console! hope this is enough information! |
|||
| By: slyong | Date: 01/08/2003 11:42:00 | |
Type : Comment |
| Not sure how it works under windows... but admin@localhost... is not a default user for mysql... have you added the user admin into mysql database? Try use root@localhost in WinMySQLAdmin to see if it connects... If it does.. there is something wrong with the admin user.. just create the admin user using the console mysql client... |
|||
| By: IceCoffee | Date: 02/08/2003 21:43:00 | |
Type : Comment |
| on windows when you rund winmysqladmin for first time you are asked to create one user that is admin/root (whatever you want to call it) and i named it admin and now i get that error with my admin/root account! |
|||
| By: VGR | Date: 03/08/2003 19:21:00 | |
Type : Answer |
| 1) restart MySql server with --skip-grant-tables 2) mysql --user=root 3) select * from mysql.user 4) check that 'admin' is there with a correct (unreadable-MD5) password set AND FOR Host='localhost' 5) if yes, then you mistyped your 'admin' password. Change it 6) if not, then change the 'admin' entry, like this : update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin'; flush privileges; exit; 7) restart MySql server normally (no more --skip-grant-tables) 8) try again 9) come back here to tell us if this worked or not :D |
|||
| By: IceCoffee | Date: 03/08/2003 19:42:00 | |
Type : Comment |
| This is what i get: i restart server with -skip-grant-tables and it's ok than i type mysql -user=root; it welcomes me to mysql monitor then when i type select * from mysql.user i get this: 1044: Access denied for user: '@localhost' to database 'mysql' :( |
|||
| By: VGR | Date: 03/08/2003 20:32:00 | |
Type : Comment |
| --user, not -user the message means MySql considers you logged in without a username... disconnect and try again... |
|||
| By: IceCoffee | Date: 03/08/2003 21:20:00 | |
Type : Comment |
| thank you! ;) |
|||
| By: VGR | Date: 03/08/2003 22:42:00 | |
Type : Comment |
| cool 8-) anyway, it's surprising... that the password you had set up using the GUI third party tool was not accepted afterwards... very weird... |
|||
|
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)
