Two questions regarding MySQL

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

 

 

 

 

Top