#1045 cannot log in to the mysql server – PhpMyAdmin

  • Hi guys,

    I’m pretty much a novice with all this stuff and am learning as I go, but have run into a problem. Hopefully, you guys can help me with it!?

    I’m setting up a WordPress site for a friend’s business. I am trying to upload the template’s .sql file to the database. I first found the hosting control panel didn’t have phpmyadmin so the hosting company installed it onto the account. https://www.apexprojects.co.nz/phpmyadmin

    They told me to use the database user and password to access it. When I try the account user and password I get the ‘#1045 cannot log in to the mysql server’ error.

    Are the database user and password the same as the hosting ones? If not, how do I find them?
    Do I need to use Mysql or anything like that since the phpmyadmin is on the server?
    Do I need to edit any config files or anything??

    Thanks in advance for your help!

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

  • Hi there.

    Did they provide any username or password? They must in order for you to be able to login to phpmyadmin.

    (After you have those credentials right, you’ll insert them in the WordPress’s config file so that it can connect to the database.)

    Thread Starter mooreao

    (@mooreao)

    Hi Coldpumpkin,

    Thanks for the reply.

    Yes, I’ve found the user and password and have logged into phpmyadmin. I’m trying to import the sql file now, so hopefully it will work. Fingers crossed.

    Nice ?? Don’t forget to update the wp-config.php file with the new database credentials. The file is located in WordPress’ main directory.

    If anything, let us know ?? Good luck!

    Thread Starter mooreao

    (@mooreao)

    It seems to be working fine now. Thanks again!

    Hi coldpumpkin

    I am having this same problem…I have done everything doable. I have been to the wp-config, config.inc, i have done several tweaking but i still get the #1045 cannot log in to the mysql server’ error. Please help me. I have TeamViewer installed on my system. That could come in handy.

    Thanks in anticipation of your kind reply.

    @seyecole – please start your own thread – it’s unlikely that your situation is the same –

    https://codex.www.ads-software.com/Forum_Welcome#Where_To_Post

    I have similar problem too. My site was working fine with WordPress 3.7 but later was told automatic update failed should update manually.
    After a few days, when view my site its blank dead White so decided to update through filezila.
    After the update when try to login to my WordPress page received this” There doesn’t seem to be a wp-
    config.php file. I need this before
    we can get started.
    Need more help? We got it .
    You can create a wp-config.php
    file through a web interface, but this
    doesn’t work for all server setups.
    The safest way is to manually create
    the file.
    Create a Configuration File”

    When i login into my host, i try to access phpmyadmin got this ” ‘#1045 cannot log in to the mysql
    server’ error.”

    Don’t really know if my host user n pass is to be used to login or the one I c hkyfdesz_?ipe in the database setting. But if this, have forgotten the password.
    What do I do now, pls help.

    Hi kipemun.

    Is there a wp-config.php file already created?

    You have to confirm if the username and the password there are correct.

    When I look through the FTP there is no wp-config.php but when i go through the host(cpanel) i see wp-config-sample.php and not sure the user name and password is there.

    You need to make a copy of the file “wp-config-sample.php” and rename it to “wp-config.php”. Then open it and change the database details!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘#1045 cannot log in to the mysql server – PhpMyAdmin’ is closed to new replies.