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
- i can't start mysql on ec2
- what to do if you can't start mysql
- can't start mysql
- i can't log in to docker's mysql
- mysql - [docker] container does not start
- can't start r commander
- [mysql/homebrew] 56 → while updating to 57, mysql does not start in 57
- 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 stopped for a day and can't start
- mysql - phpmyadmin does not start with docker
- mysql server does not start up (error! the server quit without updating pid file)
- laradock container start error message (mysql not started)
- mysql - i want to start springboot application on intellij idea
- 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
Related questions
- mysql : fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index
- mysql - about database design and implementation
- i want to create an initial database when starting a mysql container with docker
- php - database i want to be able to select any sort
- ruby - after rails db: migrate: reset, the database disappeared
- [javafx] i want to dynamically display data of any number of columns acquired from mysql in tableview
- mysql - production environment column default value error
- mysql - i want to unify the date types created in wordpress custom fields
- php - please tell me about the availability of variables in the mysql command (update syntax)
- php - i can't connect to the db using pdo
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))