MySQL starting problems

English Applications
#1

Hi all,

I hope I’m on the right forum, if not, please accept my apologies and do indicate where I have to go …

I type at the prompt :

mysqladmin -u root password pwd

then I get the message :

mysqladmin : connect to server at ‘localhost’ failed
error : ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ 13’
Check that mysqld is running and that the socket ‘/var/lib/mysql/mysql.sock’ exists!

What did I do wrong ? I just want to start with MySQL and I can’t even give a password ?

Thanks for a reaction,

W

#2

You haven’t started the mysql server. You do this from YaST > System > System Services (Runlevel).

#3

Is that different from this ?:
mysql -u root -p

Most of my notes on mysql and the errors I’ve encountered are at work,
and that pc is turned off. :frowning:

wba wrote:

>
> Hi all,
>
> I hope I’m on the right forum, if not, please accept my apologies
and
> do indicate where I have to go …
>
>
> I type at the prompt :
>
> mysqladmin -u root password pwd
>
> then I get the message :
>
> mysqladmin : connect to server at ‘localhost’ failed
> error : ‘Can’t connect to local MySQL server through socket
> ‘/var/lib/mysql/mysql.sock’ 13’
> Check that mysqld is running and that the socket
> ‘/var/lib/mysql/mysql.sock’ exists!
>
> What did I do wrong ? I just want to start with MySQL and I can’t
even
> give a password ?
>
> Thanks for a reaction,
>
> W
>
>

#4

Yes, he was trying to change the MySQL admin password. Your command is for logging in and using the MySQL command interface. In either case the backend server must be running first.

#5

I’ll give it a try and will come back if this hint would fail.

Thank you for your answer,

W