mysql appends second hostname?

  • Resolved mrverbal

    (@mrverbal)


    12 years, 2 months ago

    OS: Fedora 17
    Server: MySql
    current site: https://www.mrverbal.com

    i currently have phpbb3 running, with 5 minecraft server, a murmur server, and squirrelmail. decided to add wordpress too.

    created a MySql database added a user, granted all privilage, and flushed. At first it would not let me connect saying i was denied access.
    ran a php script to test Mysql connect. it could connect to localhost, could see my DB. when i added user as ‘user@hostname’ it added an old hostname. i had recently chnaged it, due to a loopback error with dovecot/squirrelmail. So i was denied as ‘user@newhostname@oldhostname’. Thought this was a glitch, ran install.php again, and recieved no connection. redid wp-config.php to say user was just user, added no ‘@hostname’ to the end. Install script ran and gave me every error for lack of privilage you could think of. Went back to MySql and added just user and granted all privilages. no help. so here is what i am stuck at…

    WordPress

    [ MySQL Dump file moderated. Use Pastebin and don’t post your entire mysqldump on a public forum ]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter mrverbal

    (@mrverbal)

    https://pastebin.com/j9tRQ4C5

    oldlocalhost was a poorly chosen hostname that was replaced with newlocalhost. But it keeps wanting to use it!!

    Thread Starter mrverbal

    (@mrverbal)

    ok, how do i show my pastebin?

    what it will show is that i have pretty much no privilages at all as a user on a now non used hostname, that i didnt create the user on, or grant all privilages to them on.

    [Pastebin link fixed]

    [No bumping, thank you.]

    Thread Starter mrverbal

    (@mrverbal)

    please remove my entire post

    It is not the general policy to edit or delete forum posts. When a post is made and people contribute answers to an issue, that then becomes part of the community resource for others to benefit from. Deleting posts removes this added value. In extreme circumstances, the moderation team might be persuaded to remove sensitive information but. generally, your best course of action is not to publish anything that you wouldn’t want to be public. I’m sorry but this is not an extreme case.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘mysql appends second hostname?’ is closed to new replies.