Hello ... my name is Brent ..and im using the latest version of mysql on a Freebsd box with apache & php3 & php4. My problem is that ive set a
password for the root mysql user by doing: /usr/local/bin/mysqladmin -u root password 'xxxxx' then i installed phpMyAdmin ..and set the correct username & password within phpMyAdmin's config file ..and it connects to mysql with no problems. However ..i wrote a form with php3 & html ...to connect using the same username & password and it will not connect. I know that the form is correct in its code...in that ...i moved the form to another server (running the same versions of mysql & such) and it connected with no issues. Ive seen this problem on other servers that i have administerd in the past and have not been able to get it to work correctly without totally uninstalling and re-installing mysql. When i set a password in the form for root@localhost to connect to mysql i get the following error: Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /usr/local/www/data/index.php3 on line 25 Warning: 0 is not a MySQL link index in /usr/local/www/data/index.php3 on line 26 to get around this issue temporarily i have set the root@localhost user with NO password ( i hate doing this as i know its not secure) Id rather not run mysql with "skip grant tables" ... whenever i add a user & password to mysql and then set a form to use that UN & PW ...it will not connect however if i take that user out and just use a root user with NO password ..it will work......can anyone give me a clue as to what i can do ..?? Any and ALL help is greatly appreciated.. thank you Brent --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php