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...
5
5
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
6
5
Quote
Anonymous
Anonymous
Yes, I've edited my config.php file. How do I grant the user access to the GL database?
7
7
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
5
6
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