Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old December 27th, 2004, 10:46 AM
keyboard keyboard is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 4 keyboard User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 16 sec
Reputation Power: 0
Mysql - access denied for user

I have a big problem with the Mysql server running as a service.
I work with IIS, php, Mysql and installed mysql-4.0.16-win.
IIS works fine. The rootdirectory is d:\wwwroot (localhost)
With an anonymous login and using Mysql Control Center a made a database with 2 tables with are stored in the directory c:\mysql\data.
I tried to make a connection in Dreamweaver 2004 but DW generated an internal server error.
I cannot login the mysql server although I installed a user (see the my.ini).

When I log in at the command prompt (c:\mysql\bin\mysql.exe -uroot -pazerty) I get the message: Error 1045 Access denied for User <Using password: YES>
When I log in anonymous I get the Welcome message.

This is the my.ini:
#This File was made using the WinMySQLAdmin 1.4 Tool
#19/12/2004 19:33:41

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=192.168.0.143
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=azerty

Can anyone help me?

Reply With Quote
  #2  
Old December 27th, 2004, 03:00 PM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
Try: c:\mysql\bin\mysql.exe -uroot -p

Then you will be prompted twice for your password...
I hope you didn't post your password here, and swapped it with a fake password...
It would be a huge security flaw if you had...
In the future, avoid doing that =)

Reply With Quote
  #3  
Old December 29th, 2004, 06:07 AM
keyboard keyboard is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 4 keyboard User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 16 sec
Reputation Power: 0
Question

I am only prompted for a password once and ... still 'Access denied'.
I have to start ASAP with DW but I cannot begin until this problem is solved.

Reply With Quote
  #4  
Old December 29th, 2004, 10:26 AM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
My mistake, it only prompts once...

Try omitting the -p altogether.
Perhaps you don't have a password set on the root account.

Try: c:\mysql\bin\mysql.exe -uroot

Reply With Quote
  #5  
Old January 2nd, 2005, 04:54 PM
keyboard keyboard is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 4 keyboard User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 16 sec
Reputation Power: 0
I have now the solution:
I don't think you've created a user. Try logging on as root with no password (this is the default) setting. If you can log on as root with no password, you can change it by doing this:

Code:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
To make another user read this: dev.mysql.com.

Reply With Quote
  #6  
Old January 14th, 2005, 05:07 AM
Dulcinea Dulcinea is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 23 Dulcinea User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 50 m 49 sec
Reputation Power: 0
Send a message via Yahoo to Dulcinea
Question mysql database

i've experienced da same problem once i change my username and my password. When i reinstalled mysql, i jus use root as da username with no password because i dunt want to face da same problem when i try to log in mysql in da future. i know it is not secure but how can i guarantee that once i update the user and da password, i wont face any problem to log in mysql?


Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Mysql - access denied for user


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT