IOTN :: Work Book :: MySQL

ȸ¿ø°¡ÀÔ

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

ÃÖ±æÈ£ [LIST]   2019-07-25 21:52:07, Á¶È¸ : 329 https://downloads.mariadb.org/mariadb/+releases/ mariadb-10.2.25-linux-x86_64.tar.gz gzipped tar file Linux x86_64 458.0 MB # useradd mysql # mkdir -p /mariadb/data # mariadb-10.2.25-linux-x86_64/scripts/mysql_install_db --user=mysql --datadir=/mariadb/data [svr:root mariadb]# mariadb-10.2.25-linux-x86_64/bin/mysqld_safe --datadir='/mariadb/data' --skip-grant  & [svr:root mariadb]# 190725 21:37:23 mysqld_safe Logging to '/var/log/mysqld.log'. 190725 21:37:23 mysqld_safe Starting mysqld daemon with databases from /mariadb/data [svr:root mariadb]# cat /var/log/mysqld.log 2019-07-25 21:33:54 139808953165600 [Note] /mariadb/mariadb-10.2.25-linux-x86_64/bin/mysqld: ready for connections. Version: '10.2.25-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server [svr:root mariadb]# mariadb-10.2.25-linux-x86_64/bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [svr:root mariadb]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock [svr:root mariadb]# mariadb-10.2.25-linux-x86_64/bin/mysql Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.2.25-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> # mysql -uroot -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 13 Server version: 5.5.5-10.2.25-MariaDB MariaDB Server Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mysql; UPDATE user SET password=passWORD('root') where user='root'; mv /usr/bin/mysql /usr/bin/mysql.old ln -s /mariadb/mariadb-10.2.25-linux-x86_64/bin/mysql /usr/bin/mysql # iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT # service iptables save # service iptables restart

LIST

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)