Welcome to Geeklog, Anonymous Saturday, November 30 2024 @ 12:45 am EST
Geeklog Forums
Geeklog -> MYSQL error during install
Maxgeek
Anonymous
~ Installed MYSQL - went well
~ Created MYSQL account\password for geeklog - completed
~ Geeklog (1.5.1) install (index.php) - This is where it all went crazy.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ When I try to install geeklog - If I set the MYSQL username and password it errors and tells me incorrect database information.
~ If I use the same username and leave the password blank - geeklog inastalls and no problems.
~ I can login to MYSQL with the username and password with no problems from terminal.
~ I can login to MYSQLADMINISTRATOR with the username and password with no problems
Thoughts\Suggestions
Thanks,
Max
:banghead:
15
10
Quote
Status: offline
jmucchiello
Forum User
Full Member
Registered: 08/29/05
Posts: 985
Sounds like you only created the administrator account for MYSQL. Now you have to make a database and user account and grant that user account access to the database.
10
12
Quote
Status: offline
maxgeek
Forum User
Newbie
Registered: 09/21/08
Posts: 3
:banghead:
I created a specific account for Geeklog and assigned it a password. I also created a database specifically for geeklog and assigned the username rights to the database.
ex:
~ username - geeky
~ password - xxxxxxx
~ database - geeklogtest
~ geeky has admin (all) privileges to geeklogtest
Max
I created a specific account for Geeklog and assigned it a password. I also created a database specifically for geeklog and assigned the username rights to the database.
ex:
~ username - geeky
~ password - xxxxxxx
~ database - geeklogtest
~ geeky has admin (all) privileges to geeklogtest
Max
10
12
Quote
michael
Anonymous
check the socket used in /etc/my.cnf
It should be /var/mysql/mysql.sock
You'll have to restart mysql if you change it.
Mike
It should be /var/mysql/mysql.sock
You'll have to restart mysql if you change it.
Mike
9
12
Quote
davex
Anonymous
I too have this problem, however I am hosted on godaddy and unable to access the mysql cnf.
It acts like it cannot contact the server, yet I can acess mysqladmin and I can ping the server.
I tried localhost originally, then I remembered that godaddy uses separate mysql servers and went to the ip address, but to no avail.
Is there anything I can do? I really don't feel like using php-nuke, and I'm more interested in GeekLog!
It acts like it cannot contact the server, yet I can acess mysqladmin and I can ping the server.
I tried localhost originally, then I remembered that godaddy uses separate mysql servers and went to the ip address, but to no avail.
Is there anything I can do? I really don't feel like using php-nuke, and I'm more interested in GeekLog!
32
12
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Status: offline
1000ideen
Forum User
Full Member
Registered: 08/04/03
Posts: 1298
They have some instructions online: http://help.godaddy.com/article/1361?
But anyway, what it the error that is being displayed?
And if you don`t have problems "If I use the same username and leave the password blank - geeklog inastalls and no problems." what`s the problem then?
But anyway, what it the error that is being displayed?
And if you don`t have problems "If I use the same username and leave the password blank - geeklog inastalls and no problems." what`s the problem then?
14
13
Quote
All times are EST. The time is now 12:45 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