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 <deniss.hennesy@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
