Control Web Panel

WebPanel => MySQL => Topic started by: zigi00x on March 25, 2022, 08:29:10 PM

Title: How to change owner and permission for sql. database?
Post by: zigi00x 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.

(https://www.linkpicture.com/q/Vystřižek_1.jpg) (https://www.linkpicture.com/view.php?img=LPic623e25f6a361d755273276)

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

Sorry for my ENG.

Thank you.

Title: Re: How to change owner and permission for sql. database?
Post by: iraqiboy90 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