Home>
I installed mariadb on MacOS using homewbrew and used a database, but when I restarted my PC, I tried to start mariadb again. I received an error message
I referred to various sites, but I still couldn't start it.
If anyone has experience like this, I'd like to get some tips for starting mariadb
$mysql.server start
Starting MariaDB
.191121 06:19:07 mysqld_safe Logging to '/usr/local/var/mysql/MBP-AY.local.err'.
191121 06:19:07 mysqld_safe Starting mysqld daemon with databases from/usr/local/var/mysql
/usr/local/bin/mysql.server: line 264: kill: (27551)-No such process
ERROR!
$mysql.server stop
ERROR! MariaDB server PID file could not be found!
$mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
$brew services restart mariadb
Stopping `mariadb` ... (might take a while)
==>Successfully stopped `mariadb` (label: homebrew.mxcl.mariadb)
==>Successfully started `mariadb` (label: homebrew.mxcl.mariadb)A similar message was displayed when starting after re-installing with homebrew.
Supplemental information (FW/tool version etc.)mariadb Ver 15.1 Distrib 10.4.10-MariaDB, for osx10.15 (x86_64) using readline 5.1
-
Answer # 1
-
Answer # 2
Did you really erase everything and reinstall! ?
-
Answer # 3
What about starting with
brew services start mariadb?
Related articles
- can't start mysql
- what to do if you can't start mysql
- i can't start mysql on ec2
- i can't connect to mysql
- php - xampp mysql does not start
- i don't know how to start mysql
- php - can't connect to mamp mysql
- can't connect to mysql from php
- mysql - [docker] container does not start
- mysql - phpmyadmin does not start with docker
- mysql stopped for a day and can't start
- laradock container start error message (mysql not started)
- mysql - i want to start springboot application on intellij idea
- can't start r commander
- i want to start mysql 57 with docker-compose and connect
- how to start multiple servers on the same host in mysql8 and perform replication
- what to do when mysql cannot start
- i want to start mysql container with docker-compose
- mysql installed on aws ec2 cannot start
- MySQL start error report InnoDB: Unable to lock/ibdata1 error
Related questions
- [javafx] i want to dynamically display data of any number of columns acquired from mysql in tableview
- error when executing sql in php
- laravel gives an error that the column cannot be found in the table
- mysql - i want to make a calendar with a database
- cannot log in to mysql with administrator privileges
- mysql - deploying on heroku gives a migration error
- error message from mysql when opening laravel app
- mysql - [heroku] how to solve the error when using git push heroku master (specific questions are described in the question colu
- mysql - about index creation of table assuming various queries generated by changing conditions and executing search
- cannot get id column array using select statement in php and mysql
Overview
Reinstall homebrew
Reinstall mariadb
Reinstall homebrewWe originally installed mariadb with homebrew and the installed mariadb wasn't functioning properly, so we tried to reinstall the package management tool itself. (Remarks: A permission error occurred when re-installing homebrew, so an error occurred when trying to grant authority with the chown command. When checked, the security setting of mac seems to be the cause and the security setting is set from recovery mode. (The chown command was enabled by changing it, and the permission error was also solved.) Reinstall mariadb
As you have pointed out, we deleted the configuration folder created during the Maria db installation again and reinstalled it. Thank you for your cooperation
SourceCountermeasures for permission error when installing Homebrew
For beginners Mac: Operation not permitted solution
Uninstall mariadb installed with homebrew
Mysql cannot be started (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))