Title: really a mysql question
Last modified: August 18, 2016

---

# really a mysql question

 *  [felmon](https://wordpress.org/support/users/felmon/)
 * (@felmon)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/really-a-mysql-question/)
 * hello! when I set things up I took the default on ‘allowedusers’ being able to
   upload files. now I want to change that. I want to set the minimum level to a
   higher value.
    I think it best to alter the mysql table directly. unfortunately
   I can’t use phpmyadmin or such, I must do it by hand. I am not sure how to compose
   the sql command. the following snippet from upgrade-functions.php illuminates
   the table structure – I want to alter the ‘option_value’ field which in my case
   is now empty: “37” => “INSERT INTO $tableoptions (option_id, option_name, option_type,
   option_value, option_description, option_admin_level, option_width) VALUES (37,’
   fileupload_allowedusers’, 3 , ”, ‘…or you may authorize only some users. enter
   their logins here, separated by spaces. if you leave this variable blank, all
   users who have the minimum level are authorized to upload. examp le: \’barbara
   anne george\”, 8, 30)”, help with the incantation? thanks. Felmon

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [just_bruce](https://wordpress.org/support/users/just_bruce/)
 * (@just_bruce)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/really-a-mysql-question/#post-93374)
 * I suggest downloading sqlyog, [http://www.sqlyog.com](http://www.sqlyog.com) 
   and using it to manipulate the mysql databases, if it is on your machine.
    i 
   would not use raw sql yourself unless you have a way to test and undo and are
   familiar with it. i have used sqlyog for a couple of years and it works great.
 *  Thread Starter [felmon](https://wordpress.org/support/users/felmon/)
 * (@felmon)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/really-a-mysql-question/#post-93378)
 * hello again!
    the mysql databases are not on my machine – that’s the problem.
   I’d have fixed this all up and been on to some other problem if I had control!
   I have fooled with the raw stuff before but obviously I don’t know it. however,
   this alteration – changing the one value – should be a piece o’ cake for someone
   who’s versed. I will look into sqlyog though for my home-system databases, thanks!
   Felmon

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘really a mysql question’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [felmon](https://wordpress.org/support/users/felmon/)
 * Last activity: [21 years, 7 months ago](https://wordpress.org/support/topic/really-a-mysql-question/#post-93378)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics