Apache Friends Support Forum

I set a password for the root user in mysql, but I can still go run mysqladmin from a comand line without having to log in using mysqladmin -u root password 'password' Also, when I run WinMysqlAdmin 1.4 there is no password listed under my.iniSetup What is there is:
[WinMySQLadmin]
Server="C:/Program Files/xampp/mysql/bin/mysqld.exe"
#user=root
#password=
I dont want to play with this, but I must be doing something wrong.

I would loginto mysqladmin via phpmyadmin, but it won't take the username and password I set for it.

Also, when I CD Collection under Demos I get this message:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\Program Files\xampp\htdocs\xampp\cds.php on line 64
Could not connect to database!
Is MySQL running or did you change the password?

Also, when I connect to mysql via a commant prompt and try to log in, I get:

C:\Program Files\xampp\mysql\bin>mysqladmin -p root
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

Before I set up a password in xampp for mysql everything worked fine, so I don't know why it suddenly won't let me in.

one more bit of info here. In the WinMySQLAdmin 1.4 window under MyODBC it says in gray text:
Not Found
Driver 3.51 Not Found

Could this be the problem? Should I try to re-install MySQL?

Here is what I've done thus far that seems to be getting me somewhere:
I downloaded the missign driver (mysql-connector-odbc-3.51.12-win32.zip), installed it. The environment tab under MyOBDC now says:
Not Found

Driver Version
Driver C:\WINDOWS\system32\myodbc3.dll
API Level
setup C:\WINDOWS\system32\myodbc3.dll
SQL Level

I still could not connect to mysql, nor was there any information listed in WinMySQLAdmin about the database in nay of the tabs.

Next thing, I found the my.ini file in the windows directory and renamed it my.ini.old. Then I ran WinMySQL Amdmin and was prompted to set up a user and passwprd I used root with the password I want to use. And yes, now I have information about the SQL server listed in all the tabs, although the MyODBC section looks the same. Now only that, but I can;t connect to MSQL.

After a little thought, I desided to look for a my.cnf file and found I don't have one on my computer. According to mysqladmin I'm supposed to have one. Hmmm. That's my next step. Does anyone know about this file?

In the xampp control panel stop the mysql service. Uncheck the checkbox to the left and click start again. Very weird but it did the job for me.

>C:\Program Files\xampp\mysql\bin>mysqladmin -p root
i think it should be
C:\Program Files\xampp\mysql\bin>mysqladmin -uroot
??