fokume01 0 Posted January 14, 2015 Share Posted January 14, 2015 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 Link to comment Share on other sites More sharing options...
Reboot 772 Posted January 14, 2015 Share Posted January 14, 2015 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. 2 Link to comment Share on other sites More sharing options...
fokume01 0 Posted January 14, 2015 Author Share Posted January 14, 2015 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 Link to comment Share on other sites More sharing options...
Reboot 772 Posted January 14, 2015 Share Posted January 14, 2015 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 1 Link to comment Share on other sites More sharing options...
fokume01 0 Posted January 14, 2015 Author Share Posted January 14, 2015 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 !! Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now