new to php, apache, mysql. I installed mysql 3.23 on my Windows 95 machine. I am running PHP4 with Apache server. It's all done locally (on my computer). the whole reason I am doing it is to test phpBB, which is working just fine on my "web" server 🙂.
In mysql, after the install, I changed the root password as instructed in the mysql manual:
mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password');
then did
mysql> FLUSH PRIVILEGES;
when I try to log into the mysql database with the user 'root' and password 'mypassword', it works fine. From the shell when I try to do a mysqladmin -p ping, it asks for a password, I enter it (thinking it's the password I just set for root), and I get "can't log inm access denied for ODBC@localhost, using password yes..." Now, if I just do a mysqladmin -p ping and hit enter without putting in a password, it works. Please explain to me what's going on. I thought I had set the password for mysqladmin, but it seems I didn't. I did read all I could in the docs at mysql.com, but I can't figure it out. Is this a ODBC issue? WHAT IS ODBC?
Thank you,
radu
