[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. UnknownJuly 19, 2018 at 3:07 PM

    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
  2. BloggerFebruary 25, 2020 at 3:42 PM

    As reported by Stanford Medical, It is really the ONLY reason this country's women get to live 10 years more and weigh an average of 42 pounds lighter than us.

    (By the way, it is not about genetics or some secret diet and absolutely EVERYTHING to related to "how" they are eating.)

    P.S, I said "HOW", not "WHAT"...

    TAP on this link to determine if this short test can help you unlock your real weight loss potential

    ReplyDelete
  3. UnknownFebruary 26, 2020 at 2:35 AM

    Did you realize there is a 12 word phrase you can communicate to your man... that will induce intense feelings of love and impulsive attractiveness to you buried within his chest?

    Because deep inside these 12 words is a "secret signal" that fuels a man's impulse to love, admire and care for you with his entire heart...

    ===> 12 Words That Trigger A Man's Love Response

    This impulse is so hardwired into a man's genetics that it will make him work better than before to love and admire you.

    Matter of fact, fueling this influential impulse is so essential to achieving the best possible relationship with your man that once you send your man one of the "Secret Signals"...

    ...You will immediately notice him open his heart and soul to you in such a way he's never experienced before and he will identify you as the one and only woman in the galaxy who has ever truly attracted him.

    ReplyDelete

Post a Comment

Popular posts from this blog

[Azure Websites PHP] Cross Domain request results in blank response page after Preflight HTTP OPTIONS

-
Image
THE PROBLEM I've deployed a REST API application ( CodeIgniter with Phil Sturgeon's Rest-Server library ) on Azure Websites. Although I've set the Access-Control-* header in my PHP application: header('Access-Control-Allow-Credentials: true'); header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: GET, POST, DELETE, OPTIONS'); header('Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept'); (If you need a working test file, here's the gist for the test file) But Azure Websites server doesn't return the headers in response. And thus all requests to the server failed with the error message: Origin http://example.azurewebsites.net is not allowed by Access-Control-Allow-Origin.   In order to make sure there's no problem with my application, I've deployed the same code to Appfog.com . And as expected, the application works just fine. The same application d...
Read more

[Magento] Create Contact Form with Dynamic Recipient

-
There are many ways of creating contact forms to email to multiple recipient. I'm going to describe a way that uses Javascript a the frontend to change the target recipient. Advantage of this method: Easy to add in new emails in the future. Disadvantage of this method: For those who are particularly concern email privacy, you might not want to use this method. You can modify the email checking to the backend (controller) instead. Okay enough talking, lets get started. Step 1: Set up HTML form fields I'm going to use an example of drop down select to change the email. Of course, this is fairly easy to modify with other forms as well. Open up app/design/frontend/default/<theme>/template/contacts/contacts.phtml Insert the following snippets anywhere between the <form>...</form> tag. <select name="interest" id="interest" title="<?php echo Mage::helper('contacts')->__('Please select department t...
Read more