Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    Regular Coder
    Join Date
    Dec 2005
    Location
    Ohio
    Posts
    286
    Thanks
    7
    Thanked 9 Times in 9 Posts

    User names and MySQL databases

    I have just changed hosts and servers and I am trying desperately to correct my MySQL databases. My backed-up databases were under the user name, "kaitco_" and then the name of the database. I need to edit the databases so that instead of them pointing to kaitco_, they point to dorie3_, and I have no idea how to do accomplish this or if there is even something better that I should be doing.

    Any help on this would be appreciated.

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by kaitco View Post
    I need to edit the databases so that instead of them pointing to kaitco_, they point to dorie3_, and ...
    i've got no idea what you mean by that. can you explain this a bit more?
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    New to the CF scene
    Join Date
    Sep 2006
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Edit the SQL file and change the names to match, then upload via phpMyAdmin

  • #4
    Regular Coder
    Join Date
    Dec 2005
    Location
    Ohio
    Posts
    286
    Thanks
    7
    Thanked 9 Times in 9 Posts
    Okay...here is a stupid question: how do I edit the SQL file? Is it something that can be done with just notepad or do I need something else?

  • #5
    New to the CF scene
    Join Date
    Sep 2006
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yeah, Wordpad does better actually, but Notepad will work fine.

  • #6
    Regular Coder
    Join Date
    Dec 2005
    Location
    Ohio
    Posts
    286
    Thanks
    7
    Thanked 9 Times in 9 Posts
    I have another stupid, newbie question: how do I edit username information on a database that I have already created and is on my server?

    If I have a database set up, like a WordPress blog for example, and I need to change the username and password information associated with that database, how do I do this? I am very new to MySQL and phpMyAdmin, obviously, and I know that I need to edit the information in the database, but I have no idea how to even access it.

    Can anyone help me out with this?

  • #7
    Regular Coder
    Join Date
    Jan 2007
    Posts
    213
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by kaitco View Post
    I have another stupid, newbie question: how do I edit username information on a database that I have already created and is on my server?

    If I have a database set up, like a WordPress blog for example, and I need to change the username and password information associated with that database, how do I do this? I am very new to MySQL and phpMyAdmin, obviously, and I know that I need to edit the information in the database, but I have no idea how to even access it.

    Can anyone help me out with this?
    This depends on the applications, most applications encode the password in the database so unless you login to the administration of the script and change it there you will have a hard time.

    If you mean the mysql user then you can use your cpanel for that
    Matthew Bagley
    Paramiliar Design Studios
    Website Design | Website Development | Search Engine Optimisation (SEO)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •