Answers for "can't create table errno: 13 permission denied mysql"

SQL
0

can't create table errno: 13 permission denied mysql

#1-fix permission
$ mysql -u root -p -e 'SHOW VARIABLES WHERE Variable_Name="datadir"'

#output
+---------------+-----------------------+
| Variable_name | Value                 |
+---------------+-----------------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------------+
 
#2- Check owner of each file
$ ls -lh /var/lib/mysql/
 
#3- Update to correct owner
$ sudo chown -R db_admin:server_name /var/lib/mysql/*
Posted by: Guest on November-03-2020

Code answers related to "can't create table errno: 13 permission denied mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language