не могу войти в нее

12
J
На сайте с 28.05.2019
Offline
14
566

Добро пожаловать в phpMyAdmin

Невозможно подключиться к серверу MySQL

Язык - Language

АвторизацияДокументация

Пользователь:

Пароль:

mysqli_real_connect(): (HY000/2002): No such file or directory

:sudo mysql_secure_installation

mysql_secure_installation: [ERROR] unknown variable 'default-character-set=utf8mb4'

Securing the MySQL server deployment.

Enter password for user root:

Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

ZomBat
На сайте с 08.10.2016
Offline
24
#1

MySQL лежит, попробуй запустить:

service mysqld start

или

service mysql start

в свободное время шаманю над веб-окружением VPS...
J
На сайте с 28.05.2019
Offline
14
#2

service mysqld start

Failed to start mysqld.service: Unit mysqld.service not found

---------- Добавлено 30.06.2019 в 07:17 ----------

service mysql start

Job for mysql.service failed because the control process exited with error code.

See "systemctl status mysql.service" and "journalctl -xe" for details.

я не знаю какой пароль

A
На сайте с 19.06.2018
Offline
18
#3

Не могу войти в нее... Зашел в топег только из-за его названия

J
На сайте с 28.05.2019
Offline
14
#4

как войти в нее

suffix
На сайте с 26.08.2010
Offline
264
#5

И всё таки где же у НЕЁ кнопка :)

Клуб любителей хрюш (https://www.babai.ru)
ZomBat
На сайте с 08.10.2016
Offline
24
#6

давай по очереди, вводим

systemctl status mysql.service

скриншотим

потом

journalctl -xe

скриншотим и сюда выкладываем две ссылки на результат.

J
На сайте с 28.05.2019
Offline
14
#7

jpchv

---------- Добавлено 30.06.2019 в 07:57 ----------

ZomBat
На сайте с 08.10.2016
Offline
24
#8

нет, мы так далеко не уедем наверно)) перед journalctl -xe у тебя что-то еще случилось, посмотри логи MySQL они должны быть где-то в

/var/log/mysql.log

/var/log/mysql/error.log

IL
На сайте с 20.04.2007
Offline
415
#9
jpchv:
не могу войти в нее
ZomBat:
давай по очереди, вводим

Что здесь происходит?.. 🤪

Ошибки MySql искать в

tail -20 /var/log/mysql/error.log

p.s. Вангую нехватку памяти Cannot allocate memory

p.p.s. На втором месте - траблы с диском

J
На сайте с 28.05.2019
Offline
14
#10

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: The InnoDB memory heap is disabled

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Using Linux native AIO

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Using SSE crc32 instructions

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Completed initialization of buffer pool

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2019-06-28 21:34:01 139628204792960 [Warning] InnoDB: New log files created, LSN=45781

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Doublewrite buffer not found: creating new

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Doublewrite buffer created

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: 128 rollback segment(s) are active.

2019-06-28 21:34:01 139628204792960 [Warning] InnoDB: Creating foreign key constraint system tables.

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Foreign key constraint system tables created

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Creating tablespace and datafile system tables.

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Tablespace and datafile system tables created.

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Waiting for purge to start

2019-06-28 21:34:01 139628204792960 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 0

2019-06-28 21:34:01 139627541296896 [Note] InnoDB: Dumping buffer pool(s) not yet started

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: The InnoDB memory heap is disabled

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Using Linux native AIO

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Using SSE crc32 instructions

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Completed initialization of buffer pool

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Highest supported file format is Barracuda.

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: 128 rollback segment(s) are active.

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Waiting for purge to start

2019-06-28 21:34:04 140713491229824 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 1616697

2019-06-28 21:34:04 140712825845504 [Note] InnoDB: Dumping buffer pool(s) not yet started

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: The InnoDB memory heap is disabled

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Using Linux native AIO

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Using SSE crc32 instructions

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Completed initialization of buffer pool

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Highest supported file format is Barracuda.

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: 128 rollback segment(s) are active.

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Waiting for purge to start

2019-06-28 21:34:07 140149103324288 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 1616707

2019-06-28 21:34:07 140148431910656 [Note] InnoDB: Dumping buffer pool(s) not yet started

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: The InnoDB memory heap is disabled

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Using Linux native AIO

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Using SSE crc32 instructions

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Completed initialization of buffer pool

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Highest supported file format is Barracuda.

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: 128 rollback segment(s) are active.

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Waiting for purge to start

2019-06-28 21:34:10 140603252493440 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 1616717

2019-06-28 21:34:10 140603252493440 [Note] Plugin 'FEEDBACK' is disabled.

2019-06-28 21:34:10 140602582759168 [Note] InnoDB: Dumping buffer pool(s) not yet started

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: The InnoDB memory heap is disabled

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Using Linux native AIO

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Using SSE crc32 instructions

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2019-06-28 21:34:15 13981858a3317632 [Note] InnoDB: Completed initialization of buffer pool

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Highest supported file format is Barracuda.

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: 128 rollback segment(s) are active.

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Waiting for purge to start

2019-06-28 21:34:15 139818583317632 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 1616727

2019-06-28 21:34:15 139818583317632 [Note] Plugin 'FEEDBACK' is disabled.

2019-06-28 21:34:15 139817920755456 [Note] InnoDB: Dumping buffer pool(s) not yet started

2019-06-28 21:34:15 139818583317632 [Note] Server socket created on IP: '127.0.0.1'.

2019-06-28 21:34:15 139818583317632 [Note] /usr/sbin/mysqld: ready for connections.

Version: '10.1.40-MariaDB-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Ubuntu 18.04

2019-06-28 21:35:34 139818582521600 [Note] /usr/sbin/mysqld: Normal shutdown

2019-06-28 21:35:34 139818582521600 [Note] Event Scheduler: Purging the queue. 0 events

2019-06-28 21:35:34 139817979451136 [Note] InnoDB: FTS optimize thread exiting.

2019-06-28 21:35:34 139818582521600 [Note] InnoDB: Starting shutdown...

2019-06-28 21:35:35 139818582521600 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool

2019-06-28 21:35:37 139818582521600 [Note] InnoDB: Shutdown completed; log sequence number 1616737

2019-06-28 21:35:37 139818582521600 [Note] /usr/sbin/mysqld: Shutdown complete

12

Авторизуйтесь или зарегистрируйтесь, чтобы оставить комментарий