programing

Macos에서 mariadb를 시작하는 데 문제가 있음

lovejava 2023. 9. 16. 08:21

Macos에서 mariadb를 시작하는 데 문제가 있음

mariah를 macos에서 사용하려고 합니다.양념장을 설치할 때 브루를 사용한 후.start server 명령을 실행합니다.그리고 저는 실수를 했습니다.오류 로그에서 얻은 내용은 다음과 같습니다.

161206 12:15:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
2016-12-06 12:15:15 140736096797632 [Note] /usr/local/Cellar/mariadb/10.1.19/bin/mysqld (mysqld 10.1.19-MariaDB) starting as process 20734 ...
2016-12-06 12:15:15 140736096797632 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: The InnoDB memory heap is disabled
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Using SSE crc32 instructions
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Completed initialization of buffer pool
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Highest supported file format is Barracuda.
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: 128 rollback segment(s) are active.
2016-12-06 12:15:15 140736096797632 [Note] InnoDB: Waiting for purge to start
2016-12-06 12:15:15 140736096797632 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1606768
2016-12-06 12:15:15 123145377161216 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-12-06 12:15:15 140736096797632 [Note] Plugin 'FEEDBACK' is disabled.
2016-12-06 12:15:15 140736096797632 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-12-06 12:15:15 140736096797632 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded    
2016-12-06 12:15:15 140736096797632 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-12-06 12:15:15 140736096797632 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist in engine
2016-12-06 12:15:15 140736096797632 [Note] Server socket created on IP: '::'.
2016-12-06 12:15:15 140736096797632 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 48: Address already in use
2016-12-06 12:15:15 140736096797632 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-12-06 12:15:15 140736096797632 [ERROR] Aborting

161206 12:15:17 mysqld_safe mysqld from pid file /usr/local/var/mysql/PhildeMacBook-Pro.local.pid ended

여기서 무슨 일이 일어났는지 정말 모르겠어요...

언급URL : https://stackoverflow.com/questions/40987754/having-issues-with-start-mariadb-on-mac-os