Migrating mysql database creating user and password

  • I’ve been using WordPress on a hosting package I am now moving to an Ubuntu server. Everything seems ok with the sites I have migrated so far but I am confused about mysql and wordpress login. Am I right in understanding that I log into mydomain.com/wp-admin with the same user and pass for the mysql database?

    When I import the database I do the following

    log into mysql
    Create a database with:
    >CREATE DATABASE new_db_name;

    Create a new user, grant privileges and assign a password for the new user.
    >GRANT ALL PRIVILEGES ON .* TO ‘new_db_user’@’localhost’ IDENTIFIED BY ‘new_password’;

    >FLUSH PRIVILEGES;

    then I log out of mysql

    Then I import the old database into the new one I just created

    >mysql -u new_db_username -p new_db_name < old_db_name.sql

    asks for the password I set above I enter this and everything is ok.

    Then I create and edit the file domain.co.uk.conf in /etc/apache2/sites-available

    Enable the virtual host files with:
    >sudo a2ensite domain.co.uk.conf

    and restart apache.

    I point my hosts file to the new server for that URL and everything is ok.

    My question is: Should I be able t log into the wordpress dashboard with the mysql user and password I created above?

  • The topic ‘Migrating mysql database creating user and password’ is closed to new replies.