Firstly, what should the directory permissions be on the mysql folder that holds all your databases? I tried 755 but that didnt let me create a database, so I switched to 777 and that does let me create the datasbe, but some I dont have a good feeling on keepy the mysql directory at 777

Secondly, how do you view a data inside a table in a database. I've setup a script, but it seems that the default username/pass combo isn't working. One of the tables in the database stores the username/passwords and I was just wondering what may be the right command to view the data stored inside. I tried producing a dump of that table with the Data+Structure option in phpMyAdmin but that didnt show anything.

Thanks
Abbas

i have the permissions for the 'data' folder set to 750 and the folder is owned by user 'mysql'

If your using phpMyAdmin then click the database name, when all the tables come up click on one, then browse that will show the data inside the table.

Hi

Originally posted by AbbasJaffarali
Firstly, what should the directory permissions be on the mysql folder that holds all your databases? I tried 755 but that didnt let me create a database, so I switched to 777 and that does let me create the datasbe, but some I dont have a good feeling on keepy the mysql directory at 777

Secondly, how do you view a data inside a table in a database. I've setup a script, but it seems that the default username/pass combo isn't working. One of the tables in the database stores the username/passwords and I was just wondering what may be the right command to view the data stored inside. I tried producing a dump of that table with the Data+Structure option in phpMyAdmin but that didnt show anything.

Thanks
Abbas


I am not sure that you still need help, but...

All of MySQL directories and files (tables) have mysql/mysql as owner/group and 700 as access mode

It means that only mysql has access to it ... and root, of course. That is enough.

Regards

How do you set mysql as owner?

You see, I have a CPU with two hard disks and just recently I moved the mysql directory on to the second drive. Now MySQL was working just fine until the other day when I decided to add a database and it gave me Error 13. Upon investigating, I found out that this is a permission related error and when I switched the directory to 777, it worked.

So what do I do now if I want to get that directory set to 700 with only mysql having permissions to it.

Thanks
Abbas

Hi

Please, check current owner of MySQl directories. If it other then mysql - I would not work too in place of mysql, becouse in such case you set their permission to 55 (Read and Execute, no Write)


You may mail me further questions
Regards

chown -R mysql.mysql /var/lib/mysql (or any other directory you store your mysql data inside)

Originally posted by priyadi
chown -R mysql.mysql /var/lib/mysql (or any other directory you store your mysql data inside)

That worked. Thanks!
Thanks to everyone who responded to this thread.

-Abbas