LINUX.ORG.RU

Разморозка: Ubnuntu16.04/mysqld5.7 доступ к базе с другого хоста?

 , ,


0

1

PS: Порешал. Идиотство какое-то. Пару тюбиков мази Финалгон на их геморроидальные шишки!

Извините, криокамера протекла.
Я правильно понимаю что сертификаты надо генерировать для дефолтной инсталяции? В кусочке лога оно ругается.
Опцию skip-name-resolve прописал.


root@ubnt-1604:/var/log/mysql# tail -35 error.log
2017-12-19T14:54:35.708340Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-19T14:54:36.540939Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-12-19T14:54:36.541010Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-12-19T14:54:36.931007Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-12-19T14:54:36.931638Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-12-19T14:54:36.931647Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-12-19T14:54:36.931949Z 0 [Note] InnoDB: Waiting for purge to start
2017-12-19T14:54:36.982178Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 2649424
2017-12-19T14:54:36.982502Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-12-19T14:54:36.982630Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-12-19T14:54:37.701949Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-12-19T14:54:37.701976Z 0 [Note] Server hostname (bind-address): '192.168.0.5'; port: 3306
2017-12-19T14:54:37.701984Z 0 [Note]   - '192.168.0.5' resolves to '192.168.0.5';
2017-12-19T14:54:37.702002Z 0 [Note] Server socket created on IP: '192.168.0.5'.
2017-12-19T14:54:38.098432Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098475Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098482Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098489Z 0 [Warning] 'user' entry 'debian-sys-maint@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098497Z 0 [Warning] 'user' entry 'developer@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098773Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.098783Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.099174Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.297664Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171219 17:54:38
2017-12-19T14:54:38.337274Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.337319Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-12-19T14:54:38.800409Z 0 [Note] Event Scheduler: Loaded 0 events
2017-12-19T14:54:38.800629Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.20-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2017-12-19T14:54:38.800648Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-12-19T14:54:38.800651Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-12-19T14:54:39.273302Z 0 [Note] End of list of non-natively partitioned tables
2017-12-19T14:54:39.376397Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-12-19T15:42:30.230918Z 4 [Note] Access denied for user 'developer'@'192.168.0.18' (using password: NO)
2017-12-19T15:42:36.902764Z 5 [Note] Access denied for user 'developer'@'192.168.0.18' (using password: YES)
2017-12-19T16:01:30.529178Z 6 [Note] Access denied for user 'developer'@'192.168.0.18' (using password: YES)



mysql> select user,"[@]", host, account_locked from user;
+------------------+-----+-----------+----------------+
| user             | [@] | host      | account_locked |
+------------------+-----+-----------+----------------+
| root             | [@] | localhost | N              |
| mysql.session    | [@] | localhost | Y              |
| mysql.sys        | [@] | localhost | Y              |
| debian-sys-maint | [@] | localhost | N              |
| developer        | [@] | %         | N              |
| developer        | [@] | localhost | N              |
+------------------+-----+-----------+----------------+
6 rows in set (0.00 sec)

Deleted

Последнее исправление: RTP (всего исправлений: 2)

Ответ на: комментарий от goingUp

туплю я тогда :-(
mysql&&ubuntu в hyper-v, достучаться пытаюсь из хоста через mysql-workbench, а оно меня не пускает.

Deleted
()
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.