MySQL: Connection Problem

  • samplestudent

    (@samplestudent)


    9 years ago

    Hi!

    I tried to install wordpress with XAMPP, altered the wp-config file like it’s supposed to be and tried to go to myfolder/wp-admin/install.php

    If i do this i get an error saying, that the connection to my database is not possible. I checked everything twice, created new users, altered them tried with Port 3307 and without in the DB_HOST field, but still nothing. And yes my database is running 😉 Can you help me fix this?

    Thank you in advance for your help!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter samplestudent

    (@samplestudent)

    9 years ago

    add: If i change the User and PW to root it works. But i don’t like, taking root as my login. Hope that information helps!

    Greetings!

    RossMitchell

    (@rossmitchell)

    9 years ago

    Using root as your database login is apparently standard procedure. Realise that it is NOT your user “root” but just the database one (you did use a different password????). Also since your site is not facing the public internet it is not a serious issue.

    Thread Starter samplestudent

    (@samplestudent)

    9 years ago

    Thank you! Yes of course i did alter the PW for root 😉

    So you say there’s no way to access my Database with another User which has only the rights for the wordpress database and not for other databases? (In the installation guide, they suggest to create a new user with the rights on the specific database so i guess it should work somehow?)

    RossMitchell

    (@rossmitchell)

    9 years ago

    Yes it should work, create a user, grant them all privileges on just their WordPress database, this is what I do on my Linux based hosting (local and online). BUT it seems that using root is standard procedure, I despair on occasions as to who is making these decisions for us. Never mind, on a short term job years ago it was a practical necessity that I use the network password, and the password couldn’t be changed either.

    Thread Starter samplestudent

    (@samplestudent)

    9 years ago

    I tried this, created a user and granted them all privileges on the wordpress database, but still was not able to connect. So I will stick to the root user procedure, although I not like it very much.

    Thank you!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘MySQL: Connection Problem’ is closed to new replies.