Author Topic: How to change owner and permission for sql. database?  (Read 1852 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
How to change owner and permission for sql. database?
« on: March 25, 2022, 08:29:10 PM »
Hii,

i copied the sql database from one user to another by FileManager in cwp, but when i was do, i get wrong owner and permissions, as u can see in the picture.



How i change the owner acces from phpmyadmin to moved database by filemanager?

Sorry for my ENG.

Thank you.


Offline
***
Re: How to change owner and permission for sql. database?
« Reply #1 on: March 25, 2022, 10:03:44 PM »
To change ownership:
Code: [Select]
chown user:user filenameTo change permission [x being a number]
Code: [Select]
chmod xxx filenameI don't know which permission you want. So I can't give you the number. You could also google it.

I recommend backing up the SQL through phpmyadmin and then import it. I feel like this would minimize database corruption.

but if you insist on copying it like you did, then you need to use this extra command option with the copy command to copy the ownership and permissions with it:
Code: [Select]
cp -p
« Last Edit: March 25, 2022, 10:06:42 PM by iraqiboy90 »