some question (newbie)

[bugs]

hello there.
i'm quite verry new with cpanel & web host manager, so i vahe two basic questions.
how can i setup my mysql server. i can't create any database because it tells me in phpMyAdmin that i have the wrong username or password. and when i click on Change a User or Database Password, it gives me ERROR 2002: Can't connect to mysql server though socket '/tmp/mysql.sock' (111).

The secound question, is, after i make the hosting pack's, how can i add users? i tried to add them from Account Function -> Create a new account, it tells me that is done, but i can't connect.

I have only one ip for the moment, the rest of them must come in a few days.

thank you.

 

[bijo]

Hello,

Mysql is not running on the server. Did you try to restart the mysql service from WHM?. if not try it now. If it don't help, try the following scripts from shell.

/scripts/mysqlup

What error did you get?.

 

[bugs]

Ok, i've done what you said. But when i restarted the mysql service the following error occured :

Attempting to restart mysql  	
Waiting for mysql to restart.... . . . . . . . . . . finished.

mysql status

root     27104  0.0  0.0  2040 1048 ?        S    14:28   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/opticknet.com.pid
mysql    27373  9.4  0.0 22204 8164 ?        R    14:29   0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/opticknet.com.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").

When I typed /scripts/mysqlup in shell it told me this :

/scripts/mysqlup
MySQL Setup Script Version 6.1
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Unable to retrieve file
Done
This is the MySQL  installer release number  for platform
MySQL- is up to date
Install Complete

then i tryed to restart the mysql from WHM and the same error occured. What is wrong ?

 

[bijo]

Hello,

Try the command and then restart mysql

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

 

[bugs]

not working

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
ln: `/tmp/mysql.sock': File exists

 

[bugs]

It's done

ok, 10x, but i haved managed to get it worked.
i found a topic here with the same problem.

 

[Izzee]

For future users who might have the same issue would you mind either linking to the topic where you found the solution or posting your fix here please.
Thanks.