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

Search
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 29sqlstate 5bhy000 5d 5b2002 5d permission denied when connect to digitalocean cloud databasemysql root permission denied lost 231142 select command denied to user 27 27 40 27localhost 27 for table 27pma table uiprefs 27postgresql insufficient privilege 3a 7 error 3a permission denied for table1396 28hy00 29 mysql errorpermission denied postgres 5ccopy csv command lineerror 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 mysqlerror 1005 28hy000 29 3a can 27t create table 27registration 27 28errno 3a 30 29can 27t create database 28errno 3a 13 22permission denied 22 29can 27t create table errno 3a 13 permission denied mysqlcan 27t create table errno 3a 13 permission denied mysql