[Bitnami] mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Got into this error while trying to run "mysql_upgrade" command

bitnami@server:~$ mysql_upgrade --force -uroot -p
Enter password:
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

Solution:

Just do a symbolic link for the mysql.sock file.

bitnami@server:~$ ln -s /opt/bitnami/mysql/tmp/mysql.sock /tmp/mysql.sock

Wahlah! Problem solved!

bitnami@vulcan-clients:/tmp$ mysql_upgrade --force -uroot -p
Enter password:
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK...

Comments

  1. Contact to MySQL Technical Support to Solve Error 2002 in MySQL
    After adequately foundation of MySQL if you going to reboot your system then suddenly you will get a misstep message which clothing you "Can't connect with close-by MySQL server through connection" this is the bumble of 2002 where you are not prepared to interface with neighborhood MySQL server. Possibly possible this screw up occurs if you haven't started your MySQL Server. Check the whole circumstance before long if up 'til now defying a comparative thing by then undertaking to contact Cognegic's MySQL Remote Support or MySQL Remote Service for honest to goodness assurance of this error message.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete

Post a Comment

Popular posts from this blog

225019099301.apps.googleusercontent.com

Generate GoDaddy SSL Certificate (.crt) for Azure Websites (.pfx)

Backup MySQL to Azure Storage in 30 Seconds