• I can’t log in as administrator. This was likely because the blog settings were inadvertently set to the wrong site name. This looks like I am going to need to change the site name back to what it was through a mySQL shell interface. Luckily, I have web access, but lack the SQL chops to even retrieve the value.

    By examining the table x_options, I was able to see that “stridersjournal.net” (the wrong site name) is present in the database, however, I don’t know the SQL variable (or field) name to retrieve it with. Since I didn’t set up any of this except through the scripts, it must be some kind of standardized variable name. Examining the PHP scripts, “siteurl” and “home” are seen as suspects, but none of them worked (with quotes, I got an endless list of the word “siteurl” or “home”; and without quotes I got an error).

    Any help on this would be appreciated.

  • The topic ‘Accessing and changing values in MySQL db’ is closed to new replies.