|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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? |
|
#2
|
||||
|
||||
|
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 =) |
|
#3
|
|||
|
|||
|
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. ![]() |
|
#4
|
||||
|
||||
|
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 |
|
#5
|
|||
|
|||
|
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. |
|
#6
|
|||
|
|||
|
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?
![]() |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Mysql - access denied for user |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|