I have a mysql database and i need to create an user for the login. This user need the privileges to only select on only one table where the login info are. on phpmyadmin when i use the gui i receive this error:
'#1194 - the table 'tables_priv' is signed as corrupted and need to be repaired. If i use the cli with this command: ''' GRANT SELECT ON dbname.tblname to 'dbuser' ''' i receve the seme error.
the database exist. the table exist. the user exit. i have root access.