Can't connect to MySQL through socket '/tmp/mysql.sock' (2)

dantgal

Verified User
Joined
Jul 11, 2018
Messages
17
Hi!

I am using Debian 7 and tried to migrate from mysql 5.6.38 to mariaDB 10.3 but something went wrong and mysqld did not start.

Turned back to 5.6, make was sucessfull but at the end:
Code:
[100%] Built target udf_example
Make complete
Packaging mysql-5.6.38...
CPack: Create package using TGZ
CPack: Install projects
CPack: - Run preinstall target for: MySQL
CPack: - Install project: MySQL
CPack: Create package
CPack: - package: /usr/local/directadmin/custombuild/mysql-5.6.38/mysql-5.6.38-linux-x86_64.tar.gz generated.
Moving mysql-5.6.38-*.tar.gz to /usr/local/directadmin/custombuild ...
Done.
Found created package: mysql-5.6.38-linux-x86_64.tar.gz
Stopping mysqld ...
Stopping mysqld:                [ FAILED ]
Linking /usr/local/mysql/bin/mysqlaccess.conf -> /usr/local/bin/mysqlaccess.conf...
Linking /usr/local/mysql/bin/mysqlbug -> /usr/local/bin/mysqlbug...
Linking /usr/local/mysql/bin/mysql_client_test_embedded -> /usr/local/bin/mysql_client_test_embedded...
Linking /usr/local/mysql/bin/mysql_config_editor -> /usr/local/bin/mysql_config_editor...
Linking /usr/local/mysql/bin/mysql_embedded -> /usr/local/bin/mysql_embedded...
Linking /usr/local/mysql/bin/mysqltest_embedded -> /usr/local/bin/mysqltest_embedded...
Linking /usr/local/mysql/bin/mysql_zap -> /usr/local/bin/mysql_zap...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Starting mysqld:                [ OK ]
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Error during call to mysql_check for fixing the db/tables names on mysql db
Restarting MySQL.
Stopping mysqld:                [ FAILED ]
Starting mysqld:                [ OK ]

Can't start mysql now, it says:
Code:
$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

my /etc/my.cnf is:
Code:
[mysqldump]
socket                         = /tmp/mysql.sock

[mysqld]
local-infile=0
innodb_file_per_table

I am newbie, can you help me making mysql run again?
 
Back
Top