FreeBSD6.0 assistance under MySQL I MYSQL Based version is 5.1 Tacit consent of the installation is the use of ports MySQL is no problem started I began setting up MySQL #/usr/local/bin/mysql Mysql Mysql>UPDATE user SET passwd= 'passwd' where user= 'root' Mysql>FLUSH PRIVILEGES Then the question comes on the other machines in my browser http://IP/phpmyadmin.index.php importation : Management pages out, but I found passwords to root landing wrong, I can only input the root password can be entered without a user ID But operational restrictions I landed test server #/usr/local/bin/mysql U root-p Access to the database did not suggest that mistakes ERROR 1045 (28000) Access denisd for user 'root' @ 'localhost (using password:YES) Note : my internal LAN machine testing is not the domain name Please help me look at how to solve Which Please tell me if the order is related to UNIX novice : D Under passwords to be able to test air Thank you for the password to be empty upstairs But there are no acquiescence database The new database without authority Use password ( 'xxxx') down Top try my way upstairs to see okay ^_^ , 4th Floor, still good friends with your approach The problem is the same ........ Root no authority? We never came across any. You have no way to root recorded with the authority also changed anything? 8 floor, I understand that the solution to this problem is not the need to re-install after the installation of mysql deinstall UPDATE user SET Password=PASSWORD ( 'password') WHERE User= 'root'; FLUSH PRIVILEGES; Try playing Give you the correct solution Chown-R mysql /path/to/msqldata And then set up the authority for mysql [ Closed window ]