Some mysql.server troubles


#1

Hi guys,
Just installed HTTP / PHP & MARIADB on my brand new Mac Book Pro.
Everything is going ok during the installation.
But, I am getting some troubles. I should be able ton activate MySQL just by tipping mysql.server start & mysql.server stop right ?

But I am getting thos errors
MBP-de-Anthony:~ anthony$ mysql.server start
Starting MariaDB
.190205 22:07:06 mysqld_safe Logging to ‘/usr/local/var/mysql/MBP-de-Anthony.err’.
190205 22:07:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
------------ IT S FREEZING HERE SO I HAVE TO PRESS ENTER
SUCCESS!
MBP-de-Anthony:~ anthony$ mysql.server stop
ERROR! MariaDB server process #1346 is not running!

Please note that it’s freezing at the point I suggested.

Here are the error logs os MySQL

2019-02-05 22:14:57 0 [ERROR] mysqld: Can't lock aria control file '/usr/local/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2019-02-05 22:15:29 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/usr/local/var/mysql/aria_log_control'
2019-02-05 22:15:29 0 [ERROR] Plugin 'Aria' init function returned error.
2019-02-05 22:15:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-02-05 22:15:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-05 22:15:29 0 [Note] InnoDB: Uses event mutexes
2019-02-05 22:15:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-02-05 22:15:29 0 [Note] InnoDB: Number of pools: 1
2019-02-05 22:15:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-02-05 22:15:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-02-05 22:15:29 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-05 22:15:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 35
2019-02-05 22:15:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

(Sean Molenaar) #2

I think you should be using brew services start mysql