Table 'user' is read only

Discussion in 'MySQL' started by hatifahanna, Mar 23, 2011.

0
  1. #1
    Hi all,

    I want to create user using phpmyadmin but got this error

    table 'user' is read only. it's a DB server. i have changed the table permission to 777 and restarted the service mysqld. then got this error

    table 'db' is read only.

    Do i need to change permission for all tables in DB, just to allow us to add new user? Need advise and help. Thanks.
     
    hatifahanna, Mar 23, 2011 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Use GRANT to create user in MySQL. Is this you are trying to do?
     
    mwasif, Mar 24, 2011 IP
  3. hatifahanna

    hatifahanna Peon

    Messages:
    671
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi,

    I already managed to create user. I have change all tables permission to -rwxrwxr-r inside mysql. Thank you ..:)
     
    hatifahanna, Mar 29, 2011 IP