problem with mysql

shifter · 03-30-2010, 02:00 PM

I've installed mysql on Zenwalk 6.2. I have the following questions:

1) How can to access into mysql prompt. I have the following error:

root[tmp]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

2) How can to set mysql user and password?

regards,
savio

ursusca · 03-30-2010, 02:27 PM

Hello,

When the installation of a MySQL Server completes there is a ROOT user account only. By default the ROOT user doesn't have any password set. To login from unix shell (use -h only if needed):

Code:

#mysql -h hostname -u root

You can set password for a root account:

Code:

mysqladmin -u root password your-new-password

To login:

Code:

#mysql -h hostname -u root -p

GrapefruiTgirl · 03-30-2010, 07:35 PM

Please post your question in one location only, so that the discussion remains in one place and it is easier for others to help you.

This thread is being closed, since it is a duplicate of: http://www.linuxquestions.org/questi...-mysql-798941/

Thanks,

Sasha