Thread: MySQL Read-Only

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    13
    Rep Power
    0

    MySQL Read-Only


    I've been using MySQL for about 3 months now without any problems. Now all of a sudden, whenever I open a table, it opens in read-only mode, even when I have nothing else open, everything is saved, etc. I can't figure out why. I don't even know how I got it to open in read-only mode.

    However, if I alter the table by switching the column order and apply changes, then immediately switch it back and apply changes, I can open that individual table and edit the data.

    Obviously this is an annoying work-around. It has been driving me nuts for 2 days. I've searched the web, looked through every option I can find in MySQL, etc and can't figure out how I got it in this mode where everything is Read-Only.

    When I hover over "Read-Only" it says "The column information for 'table' was not found'. Make sure it is a valid table."

    I'm figuring it is something simple, but hoping my program isn't corrupted. Does anyone know how to fix this?
  2. #2
  3. Lord of the Dance
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2003
    Posts
    3,730
    Rep Power
    1959
    Which program do you use to connect to MySQL ?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    13
    Rep Power
    0
    Originally Posted by MrFujin
    Which program do you use to connect to MySQL ?
    I'm connecting to MySQL via PHP code in my HTML.

    I'm having the issue in MySQL though. I'm not sure if they're related or not.
  6. #4
  7. Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2004
    Location
    New Springfield, OH
    Posts
    1,250
    Rep Power
    1469
    When you hover over "Read Only"...what says that? Is this some PHP-MySQL manager application like phpMyAdmin?
    Don't like me? Click it.

    Scripting problems? Windows questions? Ask the Windows Guru!

    Stay up to date with all of my latest content. Follow me on Twitter!

    Help us help you! Post your exact error message with these easy tips!

IMN logo majestic logo threadwatch logo seochat tools logo