mysql SQL Error : 1036

[kyron2u]

Hi, my mysql crashed. luckily i backedup my databases through ssh.

now my host they slice my dedicated server and restored it.

so i reinstall my database through plesk and reuploaded my tables i use phpbb.com for my forums.

now its giving me this error when i try to access my site.

ive search mysql.com but its confusing.
can anyone please help

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1036 Table 'phpbb_sessions' is read only

 

[ShadowMan@]

"read only" is a hint.

Is the version of mysql the same as it was before the crash, or did the host put a newer version (4.1x)?

If you used to run 3.23 and are now running 4.xx you need to run the command (per mysql.org):

/usr/bin/mysql_fix_privilege_tables

(depending on your distro, the path may be different)

If that does not solve it, then you need to verify the database user permissions.

 

[kyron2u]

its the same version.
see what i think it is that since i reuploaded the databases through ssh, it now has root permissions and the database is trying to edit the database and its not letting it.
i've tried chmod a+x but that didnt work either.

ive tried what u just told me, but i got this error.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any errors from this
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[root@216-55-186-54 ~]#

 

[ShadowMan@]

Use the chown command to set the user and group to mysql

cd /var/lib/mysql
chown mysql:mysql name-of-database-you-uploaded

The path may depend on your distro, but you already know where the directory is...

 

[kyron2u]

that doesnt work

i dont know what else to do.

thanks again