Can't create database mysql

Question

Before starting, I would like to point out that this question is not about the problem:

Access denied for user ''@'localhost' to database 'something'

and so, solutions for this or similar problems doesn't work.

I think I messed up with some chmod commands and now, I can log into all the users in my mysql installation but cannot create a database in any user. When I use command:

create database somedatabase;

I get an error saying,

ERROR 1006 (HY000): Can't create database 'somedatabase' (errno: 276999488)

For more information, I don't have a /var/lib/mysql directory but I have a /usr/local/mysql directory. So,

Should I use any other commands to identify the actual problem?
Have I messed up mysql permissions?

Community · Accepted Answer · 2017-05-23 12:02:10Z

1

Below solved my problem:

sudo chown -RL root:mysql /usr/local/mysql
sudo chown -RL mysql:mysql /usr/local/mysql/data
sudo /usr/local/mysql/support-files/mysql.server start

Taken from this SO answer.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jan 12, 2017 at 8:04

Shubham A.

2,5345 gold badges40 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

FooBar · Accepted Answer · 2019-05-04 09:17:21Z

0

I had a similar issue, and getting latest xcode solved the issue

answered May 4, 2019 at 9:17

FooBar

6,18912 gold badges53 silver badges107 bronze badges

Collectives™ on Stack Overflow

Can't create database mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related