Hi, I have had to change mysql root passwd My procedure is just below
shell> mysql -u root -p mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql> flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old password or without password. Now neither new passwd nor old passwd also empty passwd is not acceped I change my mind and I tried that procedure shell> kill `cat /var/db/host_name.pid` shell> mysqld_safe --skip-grant-tables & shell> mysqladmin -u root flush-privileges password "newpwd" mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysql is running and that the socket:'/tmp/mysql.sock' exits! 3rd way is shell>/usr/local/etc/rc.d/mysql-server.sh stop then shell>safe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid --skip-grand-tables & [1] 28712 shell> Starting mysql deamon with databses from /var/db/mysql 050303 21:04:02 mysql ended So I suppose that it is not initialize MySQL deamon isnt it??? How I can recover mysql password?!?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]