Hello.
> mysqladmin:connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2)' ........................... > 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 Looks like mysqld didn't started properly. What is in the error log? > 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. We'll check this after solving the problem with the daemon's start. Deniss Hennesy <[EMAIL PROTECTED]> wrote: > 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?!?? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]