The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WikiPedia Installation and My SQL

Discussion in 'Database Discussions' started by ldavis, Aug 25, 2007.

  1. ldavis

    ldavis Registered

    Joined:
    Aug 25, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Okay,
    This may not be the place to post and ask this question. I am trying to install wikipedia 1.10.1, the first time i attempt to install this i recieved the following error:
    Error selecting database Wikidb: 1044 Access denied for user 'username'@'localhost' to database 'Wikidb'

    I am not sure what I did wrong.

    In MySQL i created the database, added the username and password required for wikipedia to be able to acess said database and then i setup the user to be able to access the database.

    What I am doing wrong?

    Kind Regards,
    Ldavis
     
  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    If you have shell access to the server, login and connect to mysql using: mysql

    then execute the below commands:

    use mysql;
    GRANT ALL PRIVILEGES ON yourdatabase.* TO 'YourDBuser@localhost' IDENTIFIED BY 'dbpassword';

    This should fix the issue. If you do not have access to server, contact your webhosting company.
     
Loading...

Share This Page