mysql instal in linux os. mysql successfully instal. But not Connected database;current_user: root@localhostError Affect: Password mismatch..
Have you set root password ? If so, please try changing it and see what happens then. mysqladmin -u root password PASSWORD Code (markup):
You can also run 'mysql_secure_installation' and set your MySQL 'root' password there. If that still doesn't help you, then please provide more information about your setup, such as what linux distro you are running on, how are you trying to connect to your database etc....
However, if you want to change (or update) a root password, then you need to use following command $ mysqladmin -u root -p'oldpassword' password newpass
when i install MySQL-server-5.5.28.1.rhel5.i386.rpmls:/var/lib/mysql/*.err: no such file or directoryls:/var/lib/mysql/*.err: no such file or directory
I would uninstall it and use Yum to install the whole package. Assuming you're using RHEL or CentOS, there's no reason to install by RPM if you don't have to.