Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 10:20 am EST

Geeklog Forums

database error


syphon

Anonymous
i get this error in index.php Warning: Access denied for user: 'syphon@127.0.0.1' (Using password: YES) in C:skin4geeklog-1.3.6systemdatabasesmysql.class.php on line 104 Warning: MySQL Connection Failed: Access denied for user: 'syphon@127.0.0.1' (Using password: YES) in C:skin4geeklog-1.3.6systemdatabasesmysql.class.php on line 104 Cannnot connect to DB server In my config file there is:// To get Geeklog up and running, you need to make sure the settings in the // following sections are correct: // + DATABASE SETTINGS // + SERVER SETTINGS // + SITE SETTINGS // You can adjust the other settings once your site is up and running. // +---------------------------------------------------------------------------+ // | DATABASE SETTINGS | // | | // | These settings tell Geeklog about your database and how to connect to it. | // +---------------------------------------------------------------------------+ $_DB_dbms = 'mysql'; // Do not change (currently, only MySQL is supported) $_DB_host = 'localhost'; $_DB_name = 'geeklog'; // Yes, your DB must exist before running the installer! $_DB_user = 'syphon'; $_DB_pass = 'mypassword'; $_DB_table_prefix = 'gl_'; // e.g. 'gl_' I just fill in db users and db pass, but i dont know how to use it with database.? can someone help
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
So does a MySQL user named "syphon" exist and does it have the proper permissions on the database? bye, Dirk
 Quote

syphon

Anonymous
the user name exists but i dont know how to give it permission to the database? And i'm running a apache server, does the database itself need to be on that server or not?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The MySQL server doesn't have anything to do with Apache. It can run on the same machine, but it can also run on another machine. To grant permissions to a MySQL user, you need to log in to MySQL as the (MySQL) root user and do this: GRANT ALL PRIVILEGES ON database_name TO user@host IDENTIFIED BY 'password'; FLUSH PRIVILEGES; (replacing the lowercase bits with the actual names / values). bye, Dirk
 Quote

Anonymous

Anonymous
Where do i have to type it? sorry i'm a newbie in it Smile in the my.ini Setup?
 Quote

Status: offline

vbgunz

Forum User
Full Member
Registered: 01/24/03
Posts: 169
If you're running your own server try phpmyadmin at http://www.phpmyadmin.net which provides a nice GUI for MySQL which can help you to easily administrate your MySQL databases... Otherwise its all command line from here... It takes ten minutes to install, 5 minutes to learn how to create databases and administer priviledges... Its a real piece of cake and you should be all ready to install Geeklog within just 15 minutes... Good luck Smile---Victor B. Gonzalez
Victor B. Gonzalez -
http://aeonserv.com
 Quote

All times are EST. The time is now 10:20 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