{"id":7509,"date":"2022-06-16T22:32:48","date_gmt":"2022-06-17T03:32:48","guid":{"rendered":"https:\/\/abudinen.com\/blog\/?p=7509"},"modified":"2022-10-15T17:57:07","modified_gmt":"2022-10-15T22:57:07","slug":"linux-sql","status":"publish","type":"post","link":"https:\/\/abudinen.com\/blog\/2022\/06\/16\/linux-sql\/","title":{"rendered":"Linux sql"},"content":{"rendered":"\n

Can’t connect to local MySQL server through socket ‘\/var\/run\/mysqld\/mysqld.sock’ https:\/\/stackoverflow.com\/questions\/37365470\/2002-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq<\/p>\n\n\n\n

$ sudo -i\n# sudo apt-get remove --purge mysql\\* \n# cp -R \/var\/lib\/mysql \/home\/user\/backup\n# sudo rm -rf \/var\/lib\/mysql\/\n# sudo rm -rf \/etc\/mysql\n# sudo apt-get autoremove\n# sudo apt-get autoclean\n# sudo apt-get install mysql-server php5-mysql<\/code><\/pre>\n\n\n\n
Login at root from the CLI: https:\/\/stackoverflow.com\/questions\/61430362\/ubuntu-20-04-set-mysql-phpmyadmin-root-password<\/p>\n\n\n\n
sudo mysql -u root -p\n<\/code><\/pre>\n\n\n\n
Then<\/p>\n\n\n\n
ALTER USER 'root'@'localhost' IDENTIFIED BY '<New-Password-Here>';\n<\/code><\/pre>\n\n\n\n
To Really Get Things Working<\/h2>\n\n\n\n
From phpmyadmin.net<\/a><\/p>\n\n\n\n
Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 blah blah blah blah<\/em> https:\/\/bugs.php.net\/bug.php?id=76243<\/a>.<\/p>
There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin.<\/strong><\/p><\/blockquote>\n\n\n\n
So<\/p>\n\n\n\n
UPDATE user SET plugin=\"mysql_native_password\" WHERE user='root';\n<\/code><\/pre>\n\n\n\n
To Really Really Get Things Working… Really<\/h2>\n\n\n\n
MySQL Have changed their Security Model and root login now requires a sudo<\/strong>. This is ok for the CLI, but it means that PhpMyAdmin and ALL other clients will not be able to use root credentials<\/strong><\/p>\n\n\n\n
The best solution is to create a new user for PhpMyAdmin (or use the existing one if it was created during install) and grant it the required privileges.<\/p>\n\n\n\n
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY '<New-Password-Here>';\nGRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n
Use this user anywhere you want “root”<\/em> access.<\/p>\n\n\n\n
https:\/\/askubuntu.com\/questions\/1013955\/how-remove-or-reset-mysql-password<\/p>\n\n\n\n
  1. Open your terminal<\/li>
  2. sudo mysql -u root<\/code><\/li>
  3. use mysql;<\/code><\/li>
  4. SELECT user, plugin FROM user;<\/code><\/li>
  5. UPDATE user SET plugin = \"mysql_native_password\" WHERE user = \"root\" ;<\/code><\/li>
  6. SELECT user, plugin FROM user;<\/code><\/li>
  7. exit<\/code><\/li>
  8. service mysql restart<\/code><\/li><\/ol>\n\n\n\n
    mysql –user=root –password=mypass<\/p>\n\n\n\n
    mysql -u user -ppassword
    password should not have any space with -p<\/p>\n\n\n\n
    REVIEW https:\/\/linuxhint.com\/change-mysql-root-password-ubuntu\/<\/p>\n\n\n\n
    How to Install LAMP stack on Ubuntu<\/h2>\n\n\n\n
    Installing the popular open-source software on your computer<\/h3>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    A LAMP Stack is a set of open-source software that can be used to create websites and web applications. LAMP is an acronym: these stacks typically consist of the Linux operating system, the Apache HTTP Server, the MySQL relational database management system, and the PHP programming language. https:\/\/betterprogramming.pub\/how-to-install-lamp-stack-on-ubuntu-db77ac018116<\/p>\n\n\n\n
    To install LAMP on your computer follow these steps.<\/p>\n\n\n\n
    Step 1: Update your system<\/strong><\/h3>\n\n\n\n
    sudo apt-get update<\/code><\/p>\n\n\n\n
    Step 2: Install Mysql<\/strong><\/h3>\n\n\n\n
    sudo apt-get install mysql-server mysql-client libmysqlclient-dev<\/code><\/p>\n\n\n\n
    Step 3: Install Apache server<\/strong><\/h3>\n\n\n\n
    sudo apt<\/a>-get install apache2 apache2-doc apache2-npm-prefork<\/s> apache2-utils libexpat1 ssl-cert<\/code><\/mark><\/p>\n\n\n\n
    Step 4: Install PHP (php8.1 latest version of PHP)<\/strong><\/h3>\n\n\n\n
    sudo apt-get install libapache2-mod-php8.1 php8.1 php8.1-common php8.1-curl php8.1-dev php8.1-gd php-pear php-imagick php8.1-mcrypt php8.1-mysql php8.1-ps php8.1-xsl<\/em><\/code><\/p>\n\n\n\n
    Step 5: Install Phpmyadmin(for database)<\/strong><\/h3>\n\n\n\n
    sudo apt-get install phpmyadmin<\/code><\/p>\n\n\n\n
    tasksel<\/p>\n\n\n\n
    Install PHP mcrypt extension on Ubuntu<\/h2>\n\n\n\n
    $ sudo apt update<\/mark>\n$ sudo apt install php-mcrypt<\/mark>\nReading package lists... Done\nBuilding dependency tree       \nReading state information... Done\nPackage php-mcrypt is not available, but is referred to by another package.\nThis may mean that the package is missing, has been obsoleted, or\nis only available from another source\n\nE: Package 'php-mcrypt' has no installation candidate<\/mark><\/code><\/pre>\n\n\n\n
    sudo apt update<\/code><\/pre>\n\n\n\n
    sudo apt install -y build-essential<\/code><\/pre>\n\n\n\n
    $gcc --version<\/mark>\ngcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0\nCopyright (C) 2019 Free Software Foundation, Inc.\nThis is free software; see the source for copying conditions.  There is NO\nwarranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.\n\n$ make --version<\/mark>\nGNU Make 4.2.1\nBuilt for x86_64-pc-linux-gnu\nCopyright (C) 1988-2016 Free Software Foundation, Inc.\nLicense GPLv3+: GNU GPL version 3 or later \nThis is free software: you are free to change and redistribute it.\nThere is NO WARRANTY, to the extent permitted by law.<\/code><\/pre>\n\n\n\n
    sudo apt install php php-pear php-dev libmcrypt-dev<\/code><\/pre>\n\n\n\n
    $ which pecl <\/mark>\n\/usr\/bin\/pecl<\/code><\/pre>\n\n\n\n
    PECL usage:<\/p>\n\n\n\n
    $ pecl help<\/mark>\nCommands:\nbuild                  Build an Extension From C Source\nbundle                 Unpacks a Pecl Package\nchannel-add            Add a Channel\nchannel-alias          Specify an alias to a channel name\nchannel-delete         Remove a Channel From the List\nchannel-discover       Initialize a Channel from its server\nchannel-info           Retrieve Information on a Channel\nchannel-login          Connects and authenticates to remote channel server\nchannel-logout         Logs out from the remote channel server\nchannel-update         Update an Existing Channel\nclear-cache            Clear Web Services Cache\nconfig-create          Create a Default configuration file\nconfig-get             Show One Setting\nconfig-help            Show Information About Setting\nconfig-set             Change Setting\nconfig-show            Show All Settings\nconvert                Convert a package.xml 1.0 to package.xml 2.0 format\ncvsdiff                Run a \"cvs diff\" for all files in a package\ncvstag                 Set CVS Release Tag\ndownload               Download Package\ndownload-all           Downloads each available package from the default channel\ninfo                   Display information about a package\ninstall                Install Package\nlist                   List Installed Packages In The Default Channel\nlist-all               List All Packages\nlist-channels          List Available Channels\nlist-files             List Files In Installed Package\nlist-upgrades          List Available Upgrades\nlogin                  Connects and authenticates to remote server [Deprecated in favor of channel-login]\nlogout                 Logs out from the remote server [Deprecated in favor of channel-logout]\nmakerpm                Builds an RPM spec file from a PEAR package\npackage                Build Package\npackage-dependencies   Show package dependencies\npackage-validate       Validate Package Consistency\npickle                 Build PECL Package\nremote-info            Information About Remote Packages\nremote-list            List Remote Packages\nrun-scripts            Run Post-Install Scripts bundled with a package\nrun-tests              Run Regression Tests\nsearch                 Search remote package database\nshell-test             Shell Script Test\nsign                   Sign a package distribution file\nsvntag                 Set SVN Release Tag\nuninstall              Un-install Package\nupdate-channels        Update the Channel List\nupgrade                Upgrade Package\nupgrade-all            Upgrade All Packages [Deprecated in favor of calling upgrade with no parameters]\nUsage: pecl [options] command [command-options] <parameters>\nType \"pecl help options\" to list all options.\nType \"pecl help shortcuts\" to list all command shortcuts.\nType \"pecl help version\" or \"pecl version\" to list version information.\nType \"pecl help <command>\" to get the help for the specified command.<\/code><\/pre>\n\n\n\n
    $sudo pecl channel-update pecl.php.net<\/mark>\nUpdating channel \"pecl.php.net\"\nUpdate of Channel \"pecl.php.net\" succeeded\n\n$ sudo pecl update-channels<\/mark>\nUpdating channel \"doc.php.net\"\nUpdate of Channel \"doc.php.net\" succeeded\nUpdating channel \"pear.php.net\"\nUpdate of Channel \"pear.php.net\" succeeded\nUpdating channel \"pecl.php.net\"\nChannel \"pecl.php.net\" is up to date<\/code><\/pre>\n\n\n\n
    Let\u2019s search for mcrypt<\/em> extension.<\/p>\n\n\n\n
    $ sudo pecl search mcrypt<\/mark>\nMatched packages, channel pecl.php.net:\n=======================================\nPackage       Stable\/(Latest) Local\nmcrypt        1.0.4 (stable)        Bindings for the libmcrypt library\nmcrypt_filter 0.1.0 (beta)          Applies mcrypt symmetric encryption using stream filters<\/code><\/pre>\n\n\n\n
    You can the install mcrypt extension using pecl<\/em> command with install option.<\/p>\n\n\n\n
    $ <\/strong>sudo pecl install mcrypt<\/mark>\ndownloading mcrypt-1.0.4.tgz ...\nStarting to download mcrypt-1.0.4.tgz (27,056 bytes)\n.........done: 27,056 bytes\n6 source files, building\nrunning: phpize\nConfiguring for:\nPHP Api Version:         20190902\nZend Module Api No:      20190902\nZend Extension Api No:   320190902\n........<\/code><\/pre>\n\n\n\n
    When you see a prompt<\/p>\n\n\n\n
    libmcrypt prefix? [autodetect] :<\/code><\/pre>\n\n\n\n
    Press Enter<\/strong> to autodetect.<\/p>\n\n\n\n
    You should get an output like below for completed installation of mcrypt<\/em> extension on Ubuntu Linux machine.<\/p>\n\n\n\n
    Build process completed successfully\nInstalling '\/usr\/lib\/php\/20190902\/mcrypt.so'\ninstall ok: channel:\/\/pecl.php.net\/mcrypt-1.0.4\nconfiguration option \"php_ini\" is not set to php.ini location\nYou should add \"extension=mcrypt.so\" to php.ini<\/code><\/pre>\n\n\n\n
    Enable extension in php.ini <\/em>file. You can use nano<\/code> or vim<\/code> editor:<\/p>\n\n\n\n
    $ sudo vim \/etc\/php\/*\/cli\/php.ini<\/mark>\nextension=mcrypt.so\n\n$ sudo vim \/etc\/php\/*\/apache2\/php.ini<\/mark>\nextension=mcrypt.so<\/code><\/pre>\n\n\n\n
    You can confirm that the module was installed and enabled with the command:<\/p>\n\n\n\n
    $ php -m | grep mcrypt<\/mark>\nmcrypt<\/code><\/pre>\n\n\n\n
    ### Restart Apache web server ###\n<\/mark><\/em>sudo systemctl restart apache2\n\n### Restart nginx web server ###\n<\/mark><\/em>sudo systemctl restart nginx<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Can’t connect to local MySQL server through socket ‘\/var\/run\/mysqld\/mysqld.sock’ https:\/\/stackoverflow.com\/questions\/37365470\/2002-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq Login at root from the CLI: https:\/\/stackoverflow.com\/questions\/61430362\/ubuntu-20-04-set-mysql-phpmyadmin-root-password Then To Really Get Things Working From phpmyadmin.net Due to changes in the MySQL authentication … Leer m\u00e1s<\/a><\/p>\n