Problen in mysql 'read only'
Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problen in mysql 'read only'
Did you change the permissions of the files after starting the sever, or before? Did you read the GRANT section of the manual. Does your user have the UPDATE privilege? Raman Aggarwal wrote: Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problen in mysql 'read only'
Did you change the permissions of the files after starting the sever, or before? Did you read the GRANT section of the manual. Does your user have the UPDATE privilege? Raman Aggarwal wrote: Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman IMHO I don't think Mysql should be restarted after changing the permissions of the files at the OS level. Does MySQL cache the permissions too[?] Anyway, perror gave me: $ perror 1036 Error code 1036: Unknown error 1036 Are you sure you are giving the error code correct here? regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php