DeveloperSide.NET Forums
December 06, 2019, 04:08:46 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: denied for user root@localhost (using password: YES) plz help  (Read 14573 times)
0 Members and 1 Guest are viewing this topic.
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« on: July 12, 2007, 07:51:07 PM »

How can i fix this?  the same error keeps coming up
Logged
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #1 on: July 12, 2007, 07:55:42 PM »

Open the command prompt [run cmd.exe], within it change to directory that the mysql binary is in, and type 'mysql -uroot -p', enter password, if it does not allow you in than that's not the set password.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« Reply #2 on: July 12, 2007, 07:57:55 PM »

well, is there anyway possible that I can download a Mysql client that I would know the password to? 

If there is any, can you give me a link to it please
Logged
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #3 on: July 12, 2007, 08:07:23 PM »

There is no password set for user root with the default mysql install.
Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« Reply #4 on: July 12, 2007, 08:17:17 PM »

Apparently so, cause it keeps on saying that error.  This is so confusing, I really need 2 get Mysql up to. This is making me mad.

Here is wat i did:

1. Choose typical setup
2. then click install
3. Once installed, i clicked next, and next again
4. then i checked the 'configure mysql server now', then clicked finish
5. i clicked next and chose standard configuration
6. Checked the install as windows service box, and from the drop down menu, i chose Mysql, and i checked the 'launch my server automatically' box. then hit next
7. I checked the Modify Security Settings box, and i typed in 'root' for both password boxes, and i checked 'enable root access from remote machines' box, and hit next
8. Then i clicked execute.

and now it says:  Error Nr. 1045
                        Access denied for user 'root'@'localhost'(using password:NO)


what did I do wrong here?

Logged
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« Reply #5 on: July 12, 2007, 08:19:53 PM »

But when I run the Mysql Server Config Wizard, and i type in root for all 3 of the boxes, it says

denied for 'user'@'localhost' (Using password: YES)
Logged
night2dark2
Jr. Member
**
Posts: 98


Yeah Dont really ask.

mfaiotto@msn.com
View Profile WWW
« Reply #6 on: July 12, 2007, 08:24:27 PM »

if your using the one with the default user from the stack from here its

Code:
USERNAME : root@LOCALHOST
PASSWORD : rootwdp
PORT : 3306

:)
Logged

Revolution Gamers Host.
Master of all Gunz Server Hosting Needs.
Revolution Gamers International Gaming Commmunity
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« Reply #7 on: July 12, 2007, 08:25:18 PM »

so, when it asks for the p/w i have to type in rootwdp?
Logged
xxsnipemasterxx
Member
*
Posts: 13


View Profile
« Reply #8 on: July 12, 2007, 08:27:29 PM »

I am not good with this kind of stuff, idk what you meant by what you just said, i little bit of help plz
Logged
admin
Administrator
Master of All Subjects
*****
Posts: 3272


View Profile WWW Email
« Reply #9 on: July 12, 2007, 10:52:15 PM »

He is not using out Server Suite, just some standalone mysql installation... It has no password for root set.

The only thing I can think of is you already have some other instance of mysql installed, that had a password set for user root.

Logged

DeveloperSide.NET
Advanced PHP and MySQL Solutions for your Web Design and Development needs with Web.Developer Server Suite.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!