MySQL Problem '/tmp/mysql.sock' (2)

[fokume01 0]

Hello friends, 

 

today I installed my new server. And if I want start my server with "sh start.sh" write error :

PUBLIC_IP: 130.xxxx.12.20 interface em0

HOSTNAME: channel99

mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

PUBLIC_IP: 130.xxxx.12.20 interface em0

HOSTNAME: channel99

mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

   failed, retrying in 5 seconds

 

 

I have MySQL 5.6.

I saw some topics on forum, but nothing helped..

Please. Can someone help me?

 - Sorry for my bad english.

Regards

[Reboot 764]

Here is the solve :

 

Make a backup on you actual mysql the copy/paste this command :

cd /var/db && rm -rf mysql && cd /tmp && rm -rf mysql.sock && shutdown -r now

After creeate a new mysql user :

mysql -u root

GRANT ALL PRIVILEGES ON *.* TO root@"%";
IDENTIFIED BY 'parola' WITH GRANT OPTION;

flush privileges;

Then copy from backup : account, common,log,hotbackup ,player on /var/db/mysql

 

Then go to var /db and click propety on mysql folder ( mysql, mysql) Permission 7777

You should not overwrite the folder created after you put mysql command.

 

 

 

reboot server.

 

DONE.

 

Give me best answer if it works.

[fokume01 0]

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core1

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

   failed, retrying in 5 seconds

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core2

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

 

 

  Thank you, now this.. :X 

[Reboot 764]

 

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core1

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

   failed, retrying in 5 seconds

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core2

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

 

 

  Thank you, now this.. :X 

 

Check my post: 

Best answer is not like 

[fokume01 0]

 

 

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core1

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

   failed, retrying in 5 seconds

PUBLIC_IP: 130.xxx.12.20 interface em0

HOSTNAME: channel1_core2

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

 

 

  Thank you, now this.. :X 

 

Check my post: 

Best answer is not like 

 

THX !!