Welcome to Geeklog, Anonymous Tuesday, November 26 2024 @ 04:58 pm EST
Geeklog Forums
Another Installer Questions from a Newbie...
sroknmar
Anonymous
Okay, I'm almost to the end of the install, struggling every step of the way.
Others have gotten the "104" error, cannot connect to DB...so did I. I tried Dirk's suggestion for the SQL query into phpmyadmin, and got an error in phpmyadmin.
Database palmcour_geeklog running on localhost
Error
SQL-query :
GRANT ALL PRIVILEGES ON palmcour_geeklog TO palmcour_geeklog@localhost IDENTIFIED BY 'password'
MySQL said:
Access denied for user: 'palmcour@localhost' to database 'mysql'
(Yes, of course I changed the password to match that in my config.php file)
I changed the lib-common as instructed
Any ideas on how to beat this problem??
11
13
Quote
Anonymous
Anonymous
you sure localhost is the db server? at my host it's on a diff server ie db34.webhost.com
11
14
Quote
Anonymous
Anonymous
Are you using Apache on windows by any chance? I had problems like that. Now I use IIS. good luck
10
13
Quote
Status: offline
ndarlow
Forum User
Junior
Registered: 06/30/02
Posts: 31
To grant privileges on a database requires modifications to the mysql database itself. This can only be achieved by the MySQL "root" user (for obvious reasons).
If you have control of the phpMyAdmin installation, execute the GRANT query as the MySQL "root" user. If you don't have the required permissions to do this then ask your server administrator to do the grant for you.
In fact, granting all privileges on the database is a little dangerous. Read the Geeklog documentation to see what privileges are actually required and just apply those.
Regards,
Neil Darlow M.Sc.
11
12
Quote
sroknmar
Anonymous
Thanks, guys and/or gals. Yes, I'm sure "localhost" is correct,
and yes, I suspect that you're right about root access being
required to execute the GRANT query.
I'm going to try again from scratch to install. Practice makes for
comprehension with me...when it fails similarly, I'll have the
server admin do the GRANT.
Muchas gracias. It's tough being new.
11
14
Quote
All times are EST. The time is now 04:58 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content