Welcome to Geeklog, Anonymous Wednesday, December 25 2024 @ 01:54 am EST

Geeklog Forums

Logging into new database


Anonymous

Anonymous
I'm getting the infamous Warning: Access denied for user: 'geeklog@localhost' (Using password: YES) in /home/e-smith/files/primary/system/databases/mysql.class.php on line 104 Warning: MySQL Connection Failed: Access denied for user: 'geeklog@localhost' (Using password: YES) in /home/e-smith/files/primary/system/databases/mysql.class.php on line 104 Cannnot connect to DB server when installing geeklog for the first time. I'm using phpmyadmin to work with this. So far I've created the geeklog database. Where do I create this user and password for the geeklog database? Is it in the mysql users table? Do I just Insert a Hostname, User and Password? If someone could please help me out, I'm a retard. There doesn't seem to be much help out there for this problem... How can so many people figure this out, but can't type the path in right? Thanks for the help...
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
You can set the username and password to use in config.php. If you haven't done so already, you need to create a MySQL user and then grant access to the Geeklog database to that user. You can do all that in phpMyAdmin (or you would need to read up on this in the MySQL manual). bye, Dirk
 Quote

Anonymous

Anonymous
Yes, I've edited my config.php file. How do I grant the user access to the GL database?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
phpMyAdmin will let you do it as well (look around for the user functions). Or you could type in the SQL by hand: GRANT ALL PRIVILEGES ON database_name TO user@host IDENTIFIED BY 'password'; FLUSH PRIVILEGES; bye, Dirk
 Quote

All times are EST. The time is now 01:54 am.

  • 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