Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

MediaWiki MySQL problem


  • Please log in to reply

#1
Supercalifragilistic

Supercalifragilistic

    Member

  • Member
  • PipPipPip
  • 404 posts
Okay, first of all, I don't know how to use MySQL, but I got a guide, which says the following:

create database wikidb;
grant create, select, insert, update, delete, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';
flush privileges;
\q

so I changed it to:

create database wikidb;
grant create, select, insert, update, delete, lock tables on wikidb.* to 'looie'@'mysql5.freepgs.com' identified by 'xxxxxxxx';
flush privileges;
\q

but I get an error:

#1044 - Access denied for user 'looie'@'%' to database 'wikidb'

I only have 1 database, "looiedatabase" which is empty, and it says unlimited databases are allowed.

Anyone know the problem?
  • 0

Advertisements


#2
Michael

Michael

    Retired Staff

  • Retired Staff
  • 1,869 posts
Where did you enter that?

Do you have cPanel access?
  • 0

#3
Supercalifragilistic

Supercalifragilistic

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 404 posts
Ah, nevermind. I found out the problem. That was a command for a root or su. I had to go into the MySQL panel and create a database, which I alread had, so I had to skip that part.
  • 0

#4
Michael

Michael

    Retired Staff

  • Retired Staff
  • 1,869 posts
Thought it might be something like that. But you gave very little info so I could not say so yet.
Good to know you fixed it :whistling:

Oh your user names lacks the expeealadocus....
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP