...
Just my blog

Blog about everything, mostly about tech stuff I made. Here is the list of stuff I'm using at my blog. Feel free to ask me about implementations.

My Github My LinkedIn
Soft I recommend
There are no referral links!
Py lib I recommend

I'm using these libraries so you can ask me about them.

There are no referral links!

MySQL troubleshooting

Возможные проблемы:

  •  отваливается сокет /var/lib/musql/mysql.sock

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Лечится при помощи проверки прав на папку в директории: Проверяем:

[root@web-server ~]# cd /var/lib/mysql
[root@web-server mysql]# ls -l

Ставим: chown -R :mysql /var/lib/mysql -R - все вложенные, получат такие же права

drwx------. 2 mysql mysql 4096 Oct 31 07:32 mysql
srwxrwxrwx. 1 mysql mysql 0 Nov 8 19:41 mysql.sock
drwx------. 2 mysql mysql 4096 Nov 4 15:38 radio_tk_def

  • не стартует служба mysqld

[root@web-server mysql]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Проверим, все ли нормально с конфигами /etc/my.cnf Самая простая и рабочая конфига:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/lib/mysql/mysql.sock

Конфигу поправили, папке, где лежит сокет дали разрешение для пользователя mysql:

[root@web-server mysql]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]

 

Modified: 2024 April 21 (Sun) 17:59
Alex 2013 Nov. 09 (Sat) 02:22 linux SQL DB
12
tech
Tech posts, about installing or setting-up something.
4
raspberry
Everything related to raspberry
3
python
Using Python or coding in Python.
48
linux
Anything related to Linux user experience
26
octopus
Octopus is a framework for test execution, statistics collection and virtual machine deployment automation.
4
windows
WIndows OS and related issues and stuff.
12
REST
REST API for\from different services
7
Django
Django Web(Server) Framework
4
virtualization
Topics related to OS virtualization software
28
SQL DB
SQL type database and related issues
7
project man
Project management tools and thoughts, software and not.
23
web
Site hostings, web server, web browsing, web developing.
9
personal
Just personal thoughts, they aren't always readable or adequate
2
photo
My photos or photo related stuff.
2