can 27t create table errno 3a 13 permission denied mysql

Solutions on MaxInterview for can 27t create table errno 3a 13 permission denied mysql by the best coders in the world

home

app

help

profile

we are a community of more than 2 million smartest coders

registration for

employee referral programs

are now open

get referred to google, amazon, flipkart and more

showing results for - "can 27t create table errno 3a 13 permission denied mysql"

Luis

28 Sep 2016

1#1-fix permission
2$ mysql -u root -p -e 'SHOW VARIABLES WHERE Variable_Name="datadir"'
3
4#output
5+---------------+-----------------------+
6| Variable_name | Value                 |
7+---------------+-----------------------+
8| datadir       | /var/lib/mysql/ |
9+---------------+-----------------------+
10 
11#2- Check owner of each file
12$ ls -lh /var/lib/mysql/
13 
14#3- Update to correct owner
15$ sudo chown -R db_admin:server_name /var/lib/mysql/*
16

similar questions

mysql can 27t create 2fwrite to file 27 2fhome 2fresults csv 27 28errcode 3a 13 22permission denied 22 29 sqlstate 5bhy000 5d 5b2002 5d permission denied when connect to digitalocean cloud database mysql root permission denied lost 231142 select command denied to user 27 27 40 27localhost 27 for table 27pma table uiprefs 27 postgresql insufficient privilege 3a 7 error 3a permission denied for table 1396 28hy00 29 mysql error permission denied postgres 5ccopy csv command line error 1396 28hy000 29 3a operation drop user failed for 27ananyapam 27 40 27 25 27

queries leading to this page

access denied while creating database in mysql error 1005 28hy000 29 3a can 27t create table 27registration 27 28errno 3a 30 29 can 27t create database 28errno 3a 13 22permission denied 22 29 can 27t create table errno 3a 13 permission denied mysql can 27t create table errno 3a 13 permission denied mysql