dosubot[bot] commented on issue #7808:
URL:
https://github.com/apache/incubator-devlake/issues/7808#issuecomment-2261265903
<!-- Answer -->
To perform a clean install of MySQL on Mac OSX and ensure the `merico` user
has the correct permissions, follow these steps:
1. **Install MySQL:**
```sh
brew install mysql
```
2. **Start MySQL:**
```sh
brew services start mysql
```
3. **Secure MySQL Installation:**
```sh
mysql_secure_installation
```
4. **Log in to MySQL:**
```sh
mysql -u root -p
```
5. **Create the `merico` User and Grant Permissions:**
```sql
CREATE USER 'merico'@'localhost' IDENTIFIED BY 'merico';
GRANT ALL PRIVILEGES ON *.* TO 'merico'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
```
6. **Create the `lake` Database and Set Permissions:**
```sql
CREATE DATABASE lake;
GRANT ALL PRIVILEGES ON lake.* TO 'merico'@'localhost';
FLUSH PRIVILEGES;
```
7. **Verify Permissions:**
```sh
mysql -u merico -p -e "SHOW GRANTS FOR 'merico'@'localhost';"
```
After completing these steps, try running the `mysqldump` command again:
```sh
mysqldump -u merico -p lake > db.sql
```
This should resolve the authentication errors and allow you to back up your
MySQL database successfully
<sup>[[1]](https://github.com/apache/incubator-devlake/blob/main/backend/scripts/docker/mysql/init-ds.sql)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
